Code: Select all
// Inputs: Single/Multiple Word Search
// Output: Returns SQL Query
function big_search($query) {
$query_array = explode(" ", $query);
$count = count($query_array);
$sql = "SELECT pmpUserID, pmpFirstName, pmpLastName, pmpNickName FROM pmp_people WHERE ";
for ($i=0; $i<$count; $i++) {
$words = $query_array[$i];
$sql .= "(pmpFirstName LIKE '%$words%' OR pmpNickName LIKE '%$words%' OR pmpLastName LIKE '%$words%' OR pmpDescription LIKE '%$words%') ";
($i < $count-1) ? $sql .= "OR " : "";
}
$sql .= "ORDER BY pmpLastName";
return $sql;
}