Example #1
0
 /**
  * User login
  *
  * @param LoginRequest $request
  * @return bool
  */
 public static function login(LoginRequest $request)
 {
     $password = md5($request->password);
     $db = Db::getConnection();
     $result = $db->query("SELECT id FROM user WHERE name = '{$request->name}' AND password = '******'");
     $result->setFetchMode(PDO::FETCH_ASSOC);
     $userId = $result->fetch();
     if ($userId === FALSE) {
         $response['error'] = self::ERROR_USER_NOT_FOUND;
         return $response;
     }
     self::auth($userId['id']);
     return true;
 }
Example #2
0
 /**
  * Set status edit feedback
  *
  * @param $id
  * @param $message
  * @return bool|string
  */
 public static function edit($id, $message)
 {
     $userId = User::getId();
     if ($userId) {
         try {
             $db = Db::getConnection();
             $sqlInsert = "UPDATE `feedback` SET `message` = '{$message}', `edit` = '{$userId}' WHERE `id` =" . $id;
             $preparedStatement = $db->prepare($sqlInsert);
             $preparedStatement->execute();
             return $message;
         } catch (PDOException $e) {
             return $e->getMessage();
         }
     }
     return $error['error'] = self::ERROR_TOKEN_EXCEPTION;
 }