echo $value['room_description']; ?> </option><?php } ?> </select></p> <p><input type="reset" value="Reset" class="dash-controls"> <input type="submit" value="Check Availability" name="submit" class="dash-controls"></p> </form> <?php if (isset($_POST['submit'])) { $from = $_POST['start']; $to = $_POST['end']; $room_type = $_POST['room_type']; $room_descrip = $_POST['description']; $available = getAvailablerooms($from, $to, $room_type, $room_descrip); ?> <table> <caption>Start Date: <?php echo $from; ?> End Date: <?php echo $to; ?> </caption><tr><td>Room_no</td> <td>Name</td> <td>Description</td> <td> Room type</td> </tr> <?php if ($available) {
$totalamnt = $_POST['total-amount']; $payment = $_POST['amount']; $date = date_create($from); $from = date_format($date, "Y-m-d 11:00:00"); $date = date_create($to); $to = date_format($date, "Y-m-d 14:00:00"); $date_issue = date('Y-m-d'); $room = check_availablestandard($from, $to); $stand_single = getAvailablerooms($from, $to, 1, 1); $stand_double = getAvailablerooms($from, $to, 1, 2); $stand_triple = getAvailablerooms($from, $to, 1, 3); $deluxe_single = getAvailablerooms($from, $to, 2, 1); $deluxe_double = getAvailablerooms($from, $to, 2, 2); $sup_single = getAvailablerooms($from, $to, 3, 1); $sup_double = getAvailablerooms($from, $to, 3, 2); $sup_triple = getAvailablerooms($from, $to, 3, 3); $query = "select * from invoice where cust_id={$cust} and section_id=5"; $invoice = getData($query); $invoice_no = $invoice[0]['invoice_number']; $amnt = $invoice[0]['amount'] + $totalamnt; $query = "update invoice set amount={$amnt} where cust_id='" . $cust . "' and section_id='5'"; update($query); $payid = getPayment(); if ($payment > 0) { //insert amount paid into payment $query = "insert into payment (pay_id, amount, section_id,cust_id) values ('" . $payid . "','" . $payment . "','5','" . $cust . "')"; update($query); } $cust_id = $cust; //Standard single rooms if (isset($_POST['standard_single'])) {
// unset $_SESSION variable for the run-time session_destroy(); // destroy session data in storage header('Location:index.php'); } else { session_regenerate_id(true); $_SESSION["last_acted_on"] = time(); $from = $_POST['arrival_date']; $to = $_POST['departure_date']; //check room availability $room = check_availablestandard($from, $to); $stand_single = getAvailablerooms($from, $to, 1, 1); $stand_double = getAvailablerooms($from, $to, 1, 2); $stand_triple = getAvailablerooms($from, $to, 1, 3); $deluxe_single = getAvailablerooms($from, $to, 2, 1); $deluxe_double = getAvailablerooms($from, $to, 2, 2); if (!empty($_POST['reserve'])) { $arrival = $_POST['arrival_date']; $departure = $_POST['departure_date']; } if (isset($_POST['update'])) { $no = $_POST['room_number']; $name = $_POST['name']; $tp = $_POST['room_type']; $des = $_POST['description']; $query = "update room set name='" . $name . "' , cat_id='" . $tp . "' , room_id='" . $des . "' where room_no='" . $no . "'"; //updateRoom($query); //header('Location: home.php'); } if (isset($_GET['order'])) { $order = $_GET['order'];