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