/** * * @param type $search_query * @param type $sort_type * @param type $sort_order * @return array */ public static function searchUsers($search_query, $is_deleted = false, $is_suspended = false, $sort_type = null, $sort_order = null) { $users = array(); $link = AdminUtility::getDefaultDBConnection(); //process query $fields = explode(" ", $search_query); $query = "select * from users where (is_deleted = " . ($is_deleted ? "1" : "0") . " and " . "is_suspended = " . ($is_suspended ? "1" : "0") . ") and " . "("; for ($count = 0; $count < count($fields); $count++) { $query .= "regno = '{$fields[$count]}' or " . "last_name like '%{$fields[$count]}%' or " . "level = '{$fields[$count]}' or " . "first_name like '%{$fields[$count]}%'"; if ($count !== count($fields) - 1) { $query .= " or "; } else { $query .= ")"; } } //Search $result = mysqli_query($link, $query); if ($result) { while ($row = mysqli_fetch_array($result)) { array_push($users, $row); } } AdminUtility::sortUser($users, $sort_type, $sort_order); //Log error AdminUtility::logMySQLError($link); return $users; }