AL\Common\DAO\InterviewDAO::getLatestInterviews()

Complexity

Conditions	2
Paths	2

Size

Total Lines	42
Code Lines	33

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getLatestInterviews($limit = 20) {
        $stmt = \AL\Db\execute_query(
            "InterviewDAO: getLatestInterviews",
            $this->mysqli,
            "SELECT
                interview_main.interview_id,
                interview_text.interview_intro,
                interview_text.interview_date,
                users.userid,
                individuals.ind_name
            FROM
                interview_main
            LEFT JOIN interview_text ON interview_text.interview_id = interview_main.interview_id
            LEFT JOIN users ON interview_main.user_id = users.user_id
            LEFT JOIN individuals ON individuals.ind_id = interview_main.ind_id
            ORDER BY
                interview_date
            DESC
            LIMIT ?",
            "i", $limit
        );

        \AL\Db\bind_result(
            "InterviewDAO: getLatestInterviews",
            $stmt,
            $id, $intro, $date, $user, $individual
        );

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

        $stmt->close();

        return $interviews;
    }