D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
junglebellresort.com
/
admin
/
Filename :
manage-travel-enquiry.php
back
Copy
<?php include'config.php'; include'function.php'; error_reporting(); $action = $_GET['action']; $action_title = stringModify($action); $package_title = ""; $travel_date = ""; $name = ""; $email = ""; $phone = ""; $person = ""; $child = ""; $enquiry_date = ""; if($action == 'delete_enquiry'){ $del_id = $_GET['id']; $del_event = mysqli_query($conn, "DELETE FROM `travel_enquiry` WHERE enquiry_id = '$del_id'"); if ($del_event) { echo '<script>alert("Travel Enquiry data deleted.")</script>'; echo '<script> window.location.href = "travel-enquiry.php";</script>'; } } if($action == 'edit_enquiry'){ $edit_id = $_GET['id']; $view_data = mysqli_query($conn, "SELECT * FROM `travel_enquiry` WHERE enquiry_id = '$edit_id'"); while($row = mysqli_fetch_array($view_data)) { $package_title = $row['package_title']; $travel_date = $row['travel_date']; $enquiry_date = $row['enquiry_date']; $name = $row['name']; $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 Travel 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">Package title:</label> <input class="form-control" type="text" value="<?php echo $package_title; ?>" id="example-text-input" name="package_title" placeholder="Travel Title"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">travel Date:</label> <input class="form-control" type="date" value="<?php echo $travel_date; ?>" name="travel_date" placeholder="Travel Duration"> </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="Travel Type (Corporate/Wedding/Creative)."> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Enquiry Name:</label> <input class="form-control" type="text" value="<?php echo $name; ?>" name="name" placeholder="Travel Place"> </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">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'])) { $package_title = $_POST['package_title']; $travel_date = $_POST['travel_date']; $enquiry_date = $_POST['enquiry_date']; $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; $person = $_POST['person']; $child = $_POST['child']; echo $insrt_item = "insert into travel_enquiry(enquiry_id, package_title, travel_date, enquiry_date, name, email, phone, person, child) values('', '$package_title', '$travel_date', '$enquiry_date', '$name', '$email', '$phone', '$person', '$child')"; $run_query = mysqli_query($conn, $insrt_item); if ($run_query){ echo '<script>alert("Travel Enquiry data uploaded.")</script>'; echo '<script> window.location.href = "travel-enquiry.php";</script>'; } else{ echo '<script>alert("Travel Enquiry data not uploaded.")</script>'; } } if (isset($_POST['edit_enquiry'])) { $package_title = $_POST['package_title']; $travel_date = $_POST['travel_date']; $enquiry_date = $_POST['enquiry_date']; $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; $person = $_POST['person']; $child = $_POST['child']; echo $update_item = "UPDATE `travel_enquiry` SET `package_title`='$package_title', `travel_date`='$travel_date',`enquiry_date`='$enquiry_date',`name`='$name',`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("Travel Enquiry edited.")</script>'; echo '<script> window.location.href = "travel-enquiry.php";</script>'; } else{ echo '<script>alert("Travel package not edited.")</script>'; } } ?>