File: /home/u590867752/domains/artnculture.org/public_html/admin/query/index.php
<?php
include('../php-backend/connection.php');
session_start();
if(empty($_SESSION['Adminlogin']) || $_SESSION['Adminlogin'] == ""){
header('Location:https://www.artnculture.org/admin/index.html');
}
if($_SESSION['query'] == "False" || $_SESSION['query'] == ""){
header('Location:https://www.artnculture.org/admin/index.html');
}
try{
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$form_query = "SELECT * FROM `general_enquiry` ORDER BY id DESC" ;
$exe = $con->query($form_query);
$rslt = $exe->fetchAll(PDO::FETCH_ASSOC);
$i=1;
if($exe === 0){
}else{
}
}catch(PDOException $e){
echo "ERROR IS ".$e->getMessage();
}
?>
<html>
<head>
<title>NSAC Queries</title>
<link rel="stylesheet" href="../css/nsac.css">
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="//cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<script src="//cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@10"></script>
<script src="../js/nsac.js"></script>
<script src="../js/deleteAction.js"></script>
<script src="../js/paggination.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
body, table, td, th, p, span, div {
user-select: text !important;
}
</style></head>
<body>
<div class="main-con">
<div class="main">
<div class="logo-con"><span><img src="../images/nav-shri-art-n-culture-organisation.png"></span><span>NSAC Queries</span></div>
<div class="rfp">
<a href="../Home/index.php" class="homeicon"><i class="fa fa-home" aria-hidden="true"></i></a>
<div id="menuicon"><i class="fa fa-bars" aria-hidden="true"></i></div>
</div>
<div class="menuitems" id="menuitems"></div>
</div>
<div class="shdws"></div>
</div>
<div class="admtable-con">
<table id="promotional_members_table">
<thead>
<tr>
<td><span class="delall"><i class="fa fa-trash" aria-hidden="true" id="delete_nsac_query"></i></span></th>
<td>SNo.</th>
<td>Date</th>
<td>Name</th>
<td>Mobile</th>
<td>State</th>
<td>Email</th>
<td>Topic</th>
<td>Query</td>
</tr>
</thead>
<tbody>
<?php
foreach($rslt as $row){
?>
<tr id="<?php echo $row['id'];?>">
<td><label><input type="checkbox" value="<?php echo $row['id']; ?>"><span class="checkicon" data-text="✓"></span></label></td>
<td><?php echo $i;?></td>
<td><?php echo date('d-M-Y',strtotime($row['inserted_date']));?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['mobile'];?></td>
<td><?php echo str_replace("_"," ",$row['state_city']);?></td>
<td><?php echo $row['email'];?></td>
<td><?php echo $row['topic'];?></td>
<td><?php echo $row['query'];?></td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
</div>
<div class="footerpart" id="footerpart">
<div class="footer-text">
<span>Copyright © 2019 All Rights Reserved</span>
<a href="http://www.artnartist.in/" target="_blank">art N artist</a>
<a href="http://www.artnculture.org/" target="_blank">Art & Culture</a>
</div>
</div>
</body>
</html>