This is an old revision of the document!


Hjälp

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