Egzaminer\Model\QuestionsModel

Complexity

Total Complexity

2

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getByExamId()	0	8	1
A	getByQuestionId()	0	8	1

<?php

namespace Egzaminer\Model;

use PDO;

class QuestionsModel extends AbstractModel
{
    public function getByExamId(int $examID): array
    {
        $stmt = $this->db->prepare('SELECT * FROM questions WHERE exam_id = :exam_id');
        $stmt->bindValue(':exam_id', $examID, PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    public function getByQuestionId(int $questionID): array
    {
        $stmt = $this->db->prepare('SELECT * FROM questions WHERE id = :id');
        $stmt->bindValue(':id', $questionID, PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetch(PDO::FETCH_ASSOC);
    }
}