This is an old revision of the document!
Hjälp genomgång
<?php class Garage extends mysqli { public function __construct($settings) { parent::__construct($settings['HostName'],$settings['UserName'], $settings['Password'],$settings['DatabaseName']); if ($this->connect_errno) { echo "Failed to connect to MySQL: (" . $this->connect_errno . ") " . $this->connect_error; exit; } $query = "SET NAMES utf8"; $this->query($query); } public function parkVehicle($vehicle) { $query ="INSERT INTO `Garage` (`ObjectData`) VALUES ('" . serialize($vehicle) . "')"; $this->query($query); } public function checkoutVehicle($reg_id) { // Hämta alla från databasen $query = "SELECT * FROM Garage"; $result = $this->query($query); while ($row = $result->fetch_assoc()) { // unserilize $object = unserialize($row['ObjectData']); // jämför regid om reg_id är rätt if ($reg_id == $object->getRegistration()) { // Ta bort från databas $query = "DELETE FROM `Garage` WHERE `VehicleID` = '" . $row['VehicleID'] . "'"; $this->query($query); // retunera objektet return $object; } } } }