PHP User::LoadFromArray Examples

Example #1

File: data_access.php Project: andopor/doma-project

 public static function GetAllUsers($visibleOnly)
 {
     $sql = "SELECT U.*, COUNT(M.ID) AS NoOfMaps " . "FROM `" . DB_USER_TABLE . "` U " . "LEFT JOIN `" . DB_MAP_TABLE . "` M ON U.ID=M.UserID " . ($visibleOnly ? "WHERE U.Visible=1 " : "") . "GROUP BY U.ID " . "ORDER BY U.LastName, U.FirstName, U.ID";
     $rs = self::Query($sql);
     $users = array();
     while ($r = mysql_fetch_assoc($rs)) {
         $user = new User();
         $user->LoadFromArray($r);
         $user->NoOfMaps = $r["NoOfMaps"];
         $users[$user->ID] = $user;
     }
     return $users;
 }