Example #1
0
 function users()
 {
     if (isset($this->users)) {
         return $this->users;
     }
     static $query;
     DB::prepare_query($query, "SELECT user.userid as userid,login,firstname,midname,lastname,email FROM `user_submission`" . " LEFT JOIN `user` ON `user_submission`.`userid` = `user`.`userid`" . " WHERE submissionid=?");
     $query->execute(array($this->submissionid));
     $this->users = User::fetch_all($query);
     return $this->users;
 }
Example #2
0
 static function all($filter = "%")
 {
     static $query;
     // TODO: which fields to select?
     DB::prepare_query($query, "SELECT userid,login,firstname,midname,lastname,email,is_admin FROM `user`" . " WHERE `login` LIKE ?" . "    OR CONCAT_WS(' ',`firstname`,`midname`,`lastname`) LIKE ?" . "    OR CONCAT_WS(' ',`firstname`,`lastname`,`midname`) LIKE ?" . " ORDER BY `lastname`,`firstname`,`midname`");
     $query->execute(array($filter, $filter, $filter));
     return User::fetch_all($query);
 }