AL\Common\DAO\ArticleDAO::getLatestArticles()

Complexity

Conditions	2
Paths	2

Size

Total Lines	41
Code Lines	32

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getLatestArticles($limit = 20) {
        $stmt = \AL\Db\execute_query(
            "ArticleDAO: getLatestArticles",
            $this->mysqli,
            "SELECT
                article_main.article_id,
                article_text.article_title,
                article_text.article_intro,
                article_text.article_date,
                users.userid
            FROM
                article_main
            LEFT JOIN article_text ON article_text.article_id = article_main.article_id
            LEFT JOIN users ON article_main.user_id = users.user_id
            ORDER BY
                article_date
            DESC
            LIMIT ?",
            "i", $limit
        );

        \AL\Db\bind_result(
            "ArticleDAO: getLatestArticles",
            $stmt,
            $id, $title, $intro, $date, $user
        );

        $articles = [];
        while ($stmt->fetch()) {
            $articles[] = new \AL\Common\Model\Article\Article(
                $id,
                $title,
                $intro,
                $date,
                $user
            );
        }

        $stmt->close();

        return $articles;
    }