Exemplo n.º 1
0
 public function sessionExpired()
 {
     //echo"Hello World";
     $filmBooking = new FilmBookingModel();
     $cart = new ShoppingCart();
     $totalPrice = new Session('grandPrice');
     foreach ($cart->shoppingCart->data as $item) {
         $seats = explode(" ", $item->Seats);
         foreach ($seats as $seat) {
             $sql = "UPDATE seats\n                       SET available='Y'\n                       WHERE Room_ID=:Room_ID AND Run_Time=:Run_Time AND Seat_Name=:Seat_Name";
             $param = ["Room_ID" => $item->Room_ID, "Run_Time" => $item->Run_Time, "Seat_Name" => $seat];
             $filmBooking->updateSeats($param, $sql);
         }
     }
     $cart->emptyCart();
     $totalPrice->emptySession();
     header("Location: ./index.php");
 }