| $i |
$data[user_name] $data[user_lastname]
|
$data[order_id] |
Room: $data[room_name]
Price: $$data[price]/night
Total: $$data[total_pay]
|
Book date: $date
Check-in: $checkin
Check-out: $checkout
|
|
";
$i++;
}
echo $table_data;
}
if(isset($_POST['room_number'])){
$frm_data = filteration($_POST);
$query = "UPDATE `booking_order` bo INNER JOIN `booking_detail` bd ON bo.booking_id = bd.booking_id SET bo.arrival = ?, bo.review = ?, bd.room_no = ? WHERE bo.booking_id = ?";
$values = [1, 0, $frm_data['room_no'], $frm_data['booking_id']];
$res = update($query, $values, 'iisi');
echo ($res == 2) ? 1 : 0;
}
if(isset($_POST['cancel_booking'])){
$frm_data = filteration($_POST);
$query = "UPDATE `booking_order` SET `booking_status` =? WHERE booking_id =?";
$values = ['cancel', $frm_data['booking_id']];
$res = update($query, $values, 'si');
echo $res;
}
?>