AL\Common\DAO\GameReviewDAO::getLatestGameReviews()

Complexity

Conditions	2
Paths	2

Size

Total Lines	42
Code Lines	33

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getLatestGameReviews($limit = 20) {
        $stmt = \AL\Db\execute_query(
            "GameReviewDAO: getLatestGameReviews",
            $this->mysqli,
            "SELECT
                review_main.review_id,
                review_main.review_text,
                review_main.review_date,
                users.userid,
                game.game_name
            FROM
                review_game
            LEFT JOIN review_main ON review_main.review_id = review_game.review_id
            LEFT JOIN game ON game.game_id = review_game.game_id
            LEFT JOIN users ON review_main.user_id = users.user_id
            ORDER BY
                review_date
            DESC
            LIMIT ?",
            "i", $limit
        );

        \AL\Db\bind_result(
            "GameReviewDAO: getLatestGameReviews",
            $stmt,
            $id, $text, $date, $user, $game_name
        );

        $reviews = [];
        while ($stmt->fetch()) {
            $reviews[] = new \AL\Common\Model\Review\GameReview(
                $id,
                $text,
                $date,
                $user,
                $game_name
            );
        }

        $stmt->close();

        return $reviews;
    }