示例#1
0
function getAllMembersOfARole($roleId)
{
    $userList = array();
    // connect to db
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $sql = generateAllMembersOfARoleListSql($roleId);
    //var_dump($sql);
    $result = mysql_query($sql, $dbLink);
    if ($result) {
        if (mysql_num_rows($result) > 0) {
            while ($row = mysql_fetch_assoc($result)) {
                $oneUser = createUserFromRow($row);
                $userList[] = $oneUser;
            }
        }
    }
    return $userList;
}
示例#2
0
function getAllUsersSortedByName()
{
    // connect to db
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $getAllUsersSql = "SELECT * FROM login ORDER BY last_name, first_name";
    $result = mysql_query($getAllUsersSql, $dbLink);
    if (!$result) {
        //echo $findUserByEmailSql;
        throw new Exception('no results');
    }
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneUser = createUserFromRow($row);
        $userList[] = $oneUser;
        $row = mysql_fetch_assoc($result);
    }
    return $userList;
}