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