Advertisement
Guest User

Untitled

a guest
Apr 21st, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.70 KB | None | 0 0
  1. selectLastMessage() тоже выполняет запрос в базу, это жутко...
  2.  
  3.  public function select(string $user)
  4.     {
  5.         $query = "SELECT * FROM `dialogs` WHERE `receiver` = '$user' OR `sender` = '$user'; ";
  6.         $result = $this->pdo->query($query);
  7.         $all = $result->fetchAll(\PDO::FETCH_ASSOC);
  8.  
  9.         for ($i = 0; $i < count($all); $i++) {
  10.             if (!($this->selectLastMessage($all[$i]['id']))) $this->delete($all[$i]['id']);
  11.         }
  12.  
  13.         $query = "SELECT * FROM `dialogs` WHERE `receiver` = '$user' OR `sender` = '$user'; ";
  14.         $result = $this->pdo->query($query);
  15.         $all = $result->fetchAll(\PDO::FETCH_ASSOC);
  16.  
  17.         return $all;
  18.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement