/** * @param string $name * @return UserDataObject|null */ public function getUserByName($name) { $query = ' SELECT id, name, password_hash FROM users WHERE name = :name '; $results = $this->db->exec($query, [':name' => $name]); if (empty($results)) { return null; } $result = $results[0]; return $this->createUserDataObject($result); }
/** * demo/demo * user/user */ private static function insertUsers() { $sql = <<<'SQL_STATEMENT' INSERT INTO users (name, password_hash) VALUES ('demo', '$2y$10$z1JDj/OwmNO53NrJ5JBf7e560K.wMZ/qI75KOm66HeVCvrIAH5i8e'); SQL_STATEMENT; self::$pdo->exec($sql); $sql = <<<'SQL_STATEMENT' INSERT INTO users (name, password_hash) VALUES ('user', '$2y$10$7smqNme6IHUA5hYoTmoBLuoJN6cNrqDJI3S3ncTENWHExi86jI.T2'); SQL_STATEMENT; self::$pdo->exec($sql); $sql = <<<'SQL_STATEMENT' INSERT INTO users (name, password_hash) VALUES ('florian', '$2y$10$tfSWdnnAAGiCFkRa8uB80evMijOS1pfHINbLJOiKEH7C382tqOWuK'); SQL_STATEMENT; self::$pdo->exec($sql); }
/** * @param int $user_id * @return array */ public function emptyTrashByUserId($user_id) { $query = ' DELETE FROM urls WHERE user_id = :user_id AND trashed = 1 '; return $this->db->exec($query, [':user_id' => $user_id]); }