public static function Search($workType, $experience, $education, $salary, $zip, $distance, $page)
{
if (($tmp = Client::getZipCodes($zip, $distance)) !== false) {
$i = 0;
$query = "SELECT * FROM staff WHERE (";
foreach ($tmp as $data) {
if ($i === 0) {
$query .= "zip='" . $data[code] . "'";
} else {
$query .= " OR zip='" . $data[code] . "'";
}
$i++;
}
$query .= ") AND experience >= '{$experience}' AND workType='{$workType}' AND education>='{$education}' AND salary<='{$salary}' AND available=1";
$paginator = new Paginator($query);
if (!($results = $paginator->getData($page))) {
$GLOBALS['message'] = "No potential candidates fit that criteria.";
return false;
} else {
$results->links = $paginator->createLinks(2, 'pages');
return $results;
}
} else {
return false;
}
}
