public static function getInstance($host = "localhost", $user = "******", $password = "", $database = "ProyectoNet")
{
if (self::$instance == null) {
self::$instance = new self();
}
if (self::$instance->dbconn == null) {
self::$instance->connectToDB($host, $user, $password, $database);
}
return self::$instance;
}
public function save()
{
$mc = MysqlConnectionHandler::getInstance();
$conn = $mc->getDbConn();
if (!$conn) {
echo "OMG";
} else {
$statement = $conn->prepare("insert into Item (name,code) values (?,?)");
if ($statement) {
$name = $this->getName();
$code = $this->getCode();
$statement->bind_param("ss", $name, $code);
$return = $statement->execute();
$statement->close();
return $return;
} else {
return false;
}
}
}
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 = $_POST['updateFormSearchInput'];
if (is_numeric($id)) {
$statement->bind_param("ssi", $searchBox, $searchBox, intval($id));
} else {
$id = 0;
$statement->bind_param("ssi", $searchBox, $searchBox, $id);
}
$statement->execute();
$return = $statement->get_result();
$statement->close();
self::$resultsFromSearch = array();
while ($item = $return->fetch_row()) {
$itemret = new Auto();
$itemret->setId($item[0]);
$itemret->setName($item[1]);
$itemret->setCode($item[2]);
// var_dump($itemret);
array_push(self::$resultsFromSearch, $itemret);
}
return True;
} else {
return false;
}
}
}
