1#@!#!123s

: / home3 / encodto1 / bambooinn.in / admin /
Filename : manage-room-enquiry.php
back
<?php 
include'config.php';
include'function.php';
error_reporting();

$action = $_GET['action'];
$action_title = stringModify($action);
$room_name = "";
$enquiry_date = "";
$checkin_date = "";
$checkout_date = "";
$email = "";
$phone = "";
$person = "";
$child = "";

if($action == 'delete_enquiry'){
    $del_id = $_GET['id'];
    $del_event = mysqli_query($conn, "DELETE FROM `room_enquiry` WHERE enquiry_id = '$del_id'");
    if ($del_event) {
        echo '<script>alert("Travel Enquiry data deleted.")</script>';
        echo '<script> window.location.href = "room-enquiry.php";</script>';
    }
}

if($action == 'edit_enquiry'){
    $edit_id = $_GET['id'];
    $view_data = mysqli_query($conn, "SELECT * FROM `room_enquiry` WHERE enquiry_id = '$edit_id'");
    
    while($row = mysqli_fetch_array($view_data)) {
        $room_name = $row['room_name'];
        $enquiry_date = $row['enquiry_date'];
        $checkin_date = $row['checkin_date'];
        $checkout_date = $row['checkout_date'];
        $email = $row['email'];
        $phone = $row['phone'];
        $person = $row['person'];
        $child = $row['child'];
    }
}

?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>Admin, Manage Room Booking Enquiry| Jungle Bell Resort</title>
    <?php include'style.php'; ?>
</head>

<body>
        <!-- Begin page -->
<div id="layout-wrapper">
<?php include'header.php'; ?>
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0 font-size-18"><?php echo $action_title; ?></h4>

                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="./">Admin</a></li>
                                    <li class="breadcrumb-item active"><?php echo $action_title; ?></li>
                                </ol>
                            </div>

                        </div>
                    </div>
                </div>

                <div class="card">
                    <div class="card-body p-4"> 
                        <div class="row">
                            <div class="col-lg-6">
                                <form action="" method="POST" enctype="multipart/form-data" >
                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Room title:</label>
                                        <?php
                                        if ($room_name == "") {
                                            echo '<select class="form-select" name="room_name">
                                                    <option value="Super Deluxe AC @ Rs3000">Super Deluxe AC @ Rs3000</option>
                                                    <option value="Deluxe @ Rs 2000">Deluxe @ Rs 2000</option>
                                                </select>';
                                        }
                                        else{
                                            echo '<input class="form-control" type="text" value="<?php echo $room_name; ?>"  id="example-text-input" name="room_name" placeholder="Room Title">';
                                        }
                                        ?>
                                        
                                        
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Enquiry Date:</label>
                                        <input class="form-control" type="date" value="<?php echo $enquiry_date; ?>" name="enquiry_date" placeholder="Enquiry Date">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Enquiry Email:</label>
                                        <input class="form-control" type="email" name="email" placeholder="Travel Image" value="<?php echo $email; ?>">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Enquiry Phone:</label>
                                        <input class="form-control" type="tel" maxlength="10" name="phone" placeholder="Travel Image" value="<?php echo $phone; ?>">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Check In Date:</label>
                                        <input class="form-control" type="date" value="<?php echo $checkin_date; ?>" name="checkin_date" placeholder="Check In Date">
                                    </div>
                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Check Out Date:</label>
                                        <input class="form-control" type="date" value="<?php echo $checkout_date; ?>" name="checkout_date" placeholder="Check Out Date">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">No.of Persons:</label>
                                        <input class="form-control" type="number" name="person" placeholder="Travel Image" value="<?php echo $person; ?>">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">No. of Children:</label>
                                        <input class="form-control" type="number" name="child" placeholder="Travel Image" value="<?php echo $child; ?>">
                                    </div>

                                    <div class="mt-4">
                                        <div class="btn_div">
                                            <button type="submit" name="<?php echo $action; ?>" class="btn btn-primary w-md btn_manage"><?php echo $action_title; ?></button>
                                        </div>
                                    </div>
                                                    
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                        
            </div>
        </div>

    <?php include'right-sidebar.php'; ?>

    <?php include'script.php'; ?>

</body>
</html>

<?php

if (isset($_POST['add_enquiry'])) {
$room_name = $_POST['room_name'];
$enquiry_date = $_POST['enquiry_date'];
$checkin_date = $_POST['checkin_date'];
$checkout_date = $_POST['checkout_date'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$person = $_POST['person'];
$child = $_POST['child'];

    echo $insrt_item = "insert into room_enquiry (`enquiry_id`, `enquiry_date`, `room_name`, `email`, `phone`, `checkin_date`, `checkout_date`, `person`, `child`) values('', '$enquiry_date', '$room_name', '$email', '$phone', '$checkin_date', '$checkout_date', '$person', '$child')";
    $run_query = mysqli_query($conn, $insrt_item) or die(mysqli_error());

    if ($run_query){
        echo '<script>alert("Room Booking data uploaded.")</script>';
        // echo '<script> window.location.href = "room-enquiry.php";</script>';
    }
    else{
        echo '<script>alert("Room Booking data not uploaded.")</script>';
    }
}

if (isset($_POST['edit_enquiry'])) {
$room_name = $_POST['room_name'];
$enquiry_date = $_POST['enquiry_date'];
$checkin_date = $_POST['checkin_date'];
$checkout_date = $_POST['checkout_date'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$person = $_POST['person'];
$child = $_POST['child'];

    $update_item = "UPDATE `room_enquiry` SET `room_name`='$room_name', `enquiry_date`='$enquiry_date',`checkin_date`='$checkin_date',`checkout_date`='$checkout_date',`email`='$email',`phone`='$phone',`person`='$person',`child`='$child' WHERE `enquiry_id` = '$edit_id'";
    $run_query = mysqli_query($conn, $update_item);

    if ($run_query){
        echo '<script>alert("Room Booking Enquiry edited.")</script>';
        echo '<script> window.location.href = "room-enquiry.php";</script>';
    }
    else{
        echo '<script>alert("Room Booking not edited.")</script>';
    }
}

?>