functie getAllRubrics

util.php

  /*
        Returns all rubrics as an array.
    */
    function getAllRubrics() {
        global $conn;

        $sql = "SELECT * FROM rubriek ORDER BY rubriek, rubrieknaam ASC";
        $stmt = sqlsrv_query($conn, $sql);

        $newArr = [];
        while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
            $arr = [];
            $arr['id'] = $row['rubrieknummer'];
            $arr['name'] = utf8_encode($row['rubrieknaam']);
            $arr['parentid'] = $row['rubriek'];
            array_push($newArr, $arr);
        }
        return $newArr;
    }