/**
* @param $id
*
* @return \PDOStatement
*/
public static function read($id)
{
$sql = sprintf("SELECT A.*, B.username, B.name, B.id as account_id, B.photo as account_photo,\n C.name as category_name, C.id as category_id\n FROM posts A LEFT JOIN accounts B\n ON A.id_account = B.id\n LEFT JOIN categories C ON\n A.id_category = C.id\n WHERE A.id = :id");
$bindArray = [':id' => $id];
$data = self::query($sql, $bindArray)->fetch();
$data['comments'] = Comments::findByPost($id);
return $data;
}
