D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
bambooinn.in
/
admin
/
Filename :
inquiry-list.php
back
Copy
<?php include'config.php'; $view_inquiry = "select * from room_enquiry"; $run_query = mysqli_query($conn, $view_inquiry); ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8" /> <title>Room Inquiry List | <?php echo $title; ?></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">Room Inquiry List</h4> <div class="page-title-right"> <ol class="breadcrumb m-0"> <li class="breadcrumb-item"><a href="javascript: void(0);">Admin</a></li> <li class="breadcrumb-item active">Room Inquiry</li> </ol> </div> </div> </div> </div> <!-- end page title --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <div class="table-responsive"> <table class='table table-editable table-nowrap align-middle table-edits'> <thead> <tr> <th># No.</th> <th>Name</th> <th>Email</th> <th>Phone Number</th> <th>Check In</th> <th>Check Out</th> <th>person</th> <th>Child</th> <th>Enquiry Date</th> <th>Action</th> </tr> </thead> <tbody> <?php $sn = 0; if($run_query-> num_rows > 0){ while($row = mysqli_fetch_assoc($run_query)) { $id = $row['enq_id']; $name = $row['room_name']; $email = $row['enq_email']; $phone = $row['enq_phone']; $checkin = $row['checkin_date']; $checkout = $row['checkout_date']; $person = $row['person']; $child = $row['child']; $enq_date = $row['enq_date']; $sn++; echo "<tr data-id='1'> <td data-field='contact_id' style='width: 80px'> ".$sn.". </td> <td data-field='contact_title' class='contact_title'>".$name." </td> <td data-field='contact_content' class='contact_content'> <p>".$email."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$phone."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$checkin."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$checkout."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$person."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$child."</p> </td> <td data-field='contact_content' class='contact_content'> <p>".$enq_date."</p> </td> <td style='width: 100px'> <a href='manage-inquiry.php?id=$id&action=delete_inquiry' class='btn btn-outline-secondary btn-sm edit' title='Delete'> <i class='fas fa-trash-alt'></i> </a> </td> </tr>"; } } else{ echo "<span style='color:#fe0002;font-size:15px;'>Room Enquiry list is Empty.</span>"; } ?> </tbody> </table> </div> </div> </div> </div> <!-- end col --> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <?php include'right-sidebar.php'; ?> <?php include'script.php'; ?> </body> </html>