class.ilExcMemberRepository.php

Go to the documentation of this file.

<?php
 
class ilExcMemberRepository
{
    protected ilDBInterface $db;
 
    public function __construct(?ilDBInterface $db = null)
    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
    }
 
    public function getExerciseIdsOfUser(
        int $user_id
    ): array {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT DISTINCT obj_id FROM exc_members " .
            " WHERE usr_id = %s ",
            array("integer"),
            array($user_id)
        );
        $ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $ids[] = $rec["obj_id"];
        }
 
        return $ids;
    }
}