function searchForItems($searchBox)
{
$mc = MysqlConnectionHandler::getInstance();
$conn = $mc->getDbConn();
if (!$conn) {
echo "OMG";
} else {
$statement = $conn->prepare("select * from Item where code LIKE CONCAT('%', ?, '%') OR name LIKE CONCAT('%', ?, '%') or id =?");
if ($statement) {
$id = $searchBox;
if (is_numeric($id)) {
$id = intval($id);
$statement->bind_param("ssi", $searchBox, $searchBox, $id);
} else {
$id = 0;
$statement->bind_param("ssi", $searchBox, $searchBox, $id);
}
$statement->execute();
$return = $statement->get_result();
$statement->close();
$ireturn = array();
while ($item = $return->fetch_row()) {
$itemret = new Auto();
$itemret->setId($item[0]);
$itemret->setName($item[1]);
$itemret->setCode($item[2]);
array_push($ireturn, $itemret);
}
ItemController::$resultsFromSearch = $ireturn;
return True;
} else {
return false;
}
}
}
