public static function getOrFail($id) { $sql = sprintf("SELECT A.*, (\n SELECT name FROM accounts WHERE id=A.from_account\n ) as from_account_display, B.name as to_account_display, B.id as account_id, B.photo as account_photo\n FROM messages A LEFT JOIN accounts B\n ON A.to_account = B.id WHERE A.id=%d", $id); $data = self::query($sql)->fetch(); # if no data are return if (empty($data)) { Response::render('app/views/404.php'); } return $data; }
/** * @param $param * @return mixed */ public static function get_object_or_404($param) { $data = self::find($param); # if no data are return if (empty($data)) { Response::render('app/views/404.php'); } return $data; }