D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
guruglobalpreschool.com
/
admin
/
Filename :
manage-inquiry.php
back
Copy
<?php include'config.php'; include'function.php'; error_reporting(); $action = $_GET['action']; $action_title = stringModify($action); $name = ""; $email = ""; $phone = ""; $date = ""; $subject = ""; $message = ""; if($action == 'delete_inquiry'){ $del_id = $_GET['id']; $del_event = mysqli_query($conn, "DELETE FROM contactus WHERE id = '$del_id'") or mysqli_error($conn); if ($del_event) { echo '<script>alert("Customer Inquiry data deleted.")</script>'; echo '<script> window.location.href = "inquiry-list";</script>'; } } if($action == 'edit_inquiry'){ $edit_id = $_GET['id']; $view_event = mysqli_query($conn, "SELECT * FROM contactus WHERE id = '$edit_id'"); while($row = mysqli_fetch_array($view_event)) { $name = $row['name']; $email = $row['email']; $phone = $row['phone']; $date = $row['date']; $subject = $row['subject']; $message = $row['message']; } } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Edit Inquiry | <?php echo $company; ?></title> <?php include'style.php'; ?> </head> <body> <!-- Begin page --> <div id="layout-wrapper"> <?php include'header.php'; ?> <!-- ============================================================== --> <!-- Start right Content here --> <!-- ============================================================== --> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <!-- start page title --> <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> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body editable_banner p-4"> <div class="row"> <div class="col-lg-6"> <form action="" method="POST"> <div class="mb-3"> <label for="example-text-input" class="form-label">Name:</label> <input class="form-control" type="text" name="name" placeholder="Full Name" value="<?php echo $name; ?>"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Customer Email:</label> <input class="form-control" type="email" name="email" placeholder="Email" value="<?php echo $email; ?>"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Customer Phone:</label> <input class="form-control" type="tel" maxlength="10" name="phone" placeholder="Contact Phone" value="<?php echo $phone; ?>"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Date:</label> <input class="form-control" type="date" name="date" placeholder="Date Of Inquiry" value="<?php echo $date; ?>"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Subject:</label> <input class="form-control" type="text" name="subject" placeholder="Subject" value="<?php echo $subject; ?>"> </div> <div class="mb-3"> <label for="example-text-input" class="form-label">Message:</label> <textarea class="form-control" type="text" name="message" placeholder="Message"><?php echo $message; ?></textarea> </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> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <?php include'right-sidebar.php'; ?> <?php include'script.php'; ?> </body> </html> <?php if (isset($_POST['edit_inquiry'])) { $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; $date = $_POST['date']; $subject = $_POST['subject']; $message = $_POST['message']; echo $update_contact = "UPDATE contactus SET `name`='$name', `email`='$email',`phone`='$phone',`date`='$date',`subject`='$subject',`message`='$message' WHERE `id` = '$edit_id'"; $run_query = mysqli_query($conn, $update_contact) or mysqli_error($conn); if ($run_query){ echo '<script>alert("Contact Inquiry data edited.")</script>'; echo '<script> window.location.href = "inquiry-list";</script>'; } else{ echo '<script>alert("Contact Inquiry data not edited.")</script>'; } } ?>