/** * * Create reservation records * @param $orderId * @param $item * */ static function createReservations($orderId, $item) { $order = new OrderModel(); $sql = "INSERT INTO `reservations` VALUES (NULL, :Running_films, :Cinema_Name, :Cinema_Address\n ,:Run_Time,:Room_Name,:Room_id,:Seats_Numbers,:Order_Id,:Price)"; $param = ["Running_films" => $item->Film_Name, "Cinema_Name" => $item->Cinema, "Cinema_Address" => $item->Cinema_Address, "Run_Time" => $item->Run_Time, "Room_Name" => $item->Room, "Room_id" => $item->Room_ID, "Seats_Numbers" => $item->Seats, "Order_Id" => $orderId, "Price" => $item->TotalPrice]; $order->modifyOrder($param, $sql); }