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