Example #1
0
 /**
  * @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);
 }
Example #2
0
    /**
     * 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);
    }
Example #3
0
 /**
  * @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]);
 }