mklkj / egzaminer

use PDO;

class ExamsGroupModel extends AbstractModel

{

    public function getExamsGroups(): array

    {

        $stmt = $this->db->query('SELECT id, title, description FROM exams_groups');

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

    }

    public function getExamsGroupInfoById(int $groupID): \stdClass

    {

        $stmt = $this->db->prepare('SELECT * FROM exams_groups WHERE id = :id');

        $stmt->bindValue(':id', $groupID, PDO::PARAM_INT);

        $stmt->execute();

        return $stmt->fetch(PDO::FETCH_OBJ);

    }

}

use PDO;

class ExamsListModel extends AbstractModel

{

    public function getList(): array

    {

        $stmt = $this->db->query('SELECT id, title, questions FROM exams');

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

    }

    public function getExamsByGroupId(int $groupID): array

    {

        $stmt = $this->db->prepare('SELECT id, title, questions FROM exams WHERE group_id = :gid');

        $stmt->bindValue(':gid', $groupID, PDO::PARAM_INT);

        $stmt->execute();

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

    }

}