Database

<br />
public static function getUsers(): Users {

        $users = new Users();

        $query = "
        SELECT 
               uid, 
               Username<br />
        FROM [user]
        WHERE User_type <> 'xxxxxxx' 
        ORDER BY Username";

        $conn = DbConnectRepository::createConn();
        $result = sqlsrv_query($conn, $query) or die(" getUsers " . LINE . " - " . $query . ' - ' . print_r(sqlsrv_errors()));
        while ($row = sqlsrv_fetch_array($result)) {

            $user = new User();
            $user->setUserId($row[0]);
            $user->setUserName($row[1]);<br />
            $users->add($user);

        }

        return $users;

    }