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; } } }