function searchFromPeopleFinder($nameString, $mysqli_object)
{
//global $context;
//$returnVal = [];
//$baseURL = "https://webservices.doit.missouri.edu";
//if(empty($people_list)){
//return $returnVal;
//}
$qry = "SELECT LastName, FirstName, Department, Title, Email from MOSpacePeople where LastName = ? AND FirstName = ? ";
$parser = new HumanNameParser_Parser($nameString);
if (!($stmt = $mysqli_object->prepare($qry))) {
exit("statement prepared failed: (" . $mysqli_object->errno . ") " . $mysqli_object->error);
}
$bind_param_last_name = $parser->getLast();
$bind_param_first_name = $parser->getFirst();
if (!$stmt->bind_param("ss", $bind_param_last_name, $bind_param_first_name)) {
exit("bind parameter failed: (" . $stmt->errno . ")" . $stmt->error);
}
if (!$stmt->execute()) {
exit("Execute failed: (" . $stmt->errno . ")" . $stmt->error);
}
$stmt->store_result();
//echo $stmt->num_rows."\n";
if ($stmt->num_rows == 0) {
return false;
}
if ($stmt->num_rows > 0) {
$stmt->bind_result($last, $first, $dep, $title, $email);
$stmt->fetch();
return array("LastName" => $last, "FirstName" => $first, "Department" => $dep, "Title" => $title, "Email" => $email);
}
}