/**
*
* @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;
}
