File: /home/u590867752/domains/artnculture.org/public_html/admin/AllArtists/all_members_details.php
<?php
include('../conn.php');
session_start();
if(empty($_SESSION['Adminlogin']) || $_SESSION['Adminlogin'] == ""){
header('Location:http://www.artnartist.in/admin/index.html');
}
$q="";
if($_GET['all_members'] == "ALL"){
$q = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL ORDER BY DATE_FORMAT(date_time, '%d-%m-%y') DESC";
}else if($_GET['all_members'] == "ACTIVE"){
$q = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `status` = 'ACTIVE' ORDER BY DATE_FORMAT(date_time, '%d-%m-%y') DESC";
}else if($_GET['all_members'] == "DEACTIVE"){
$q = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `status` = 'DEACTIVE' ORDER BY DATE_FORMAT(date_time, '%d-%m-%y') DESC";
}else{
header('location:index.php');
}
$rslt = mysqli_query($con,$q);
?>
<html>
<head>
<title>Participant Members</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="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
</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>Participant Members</span></div>
<div class="rfp">
<a href="../Home/index.php" class="homeicon"><i class="fa fa-home" aria-hidden="true"></i></a>
</div>
</div>
<div class="shdws"></div>
</div>
<div class="admtable-con">
<div class="table-ttl fordwldep">
<a href="index.php"><i class="fa fa-arrow-left" aria-hidden="true"></i></a>
<div class="act-part">
<span id="excel"><i class="fa fa-file-excel-o" aria-hidden="true"></i></span>
<span id="pdf"><i class="fa fa-file-pdf-o" aria-hidden="true"></i></span>
</div>
</div>
<div >
<table id="user_table">
<thead>
<tr>
<th scope="col">SNo.</th>
<th scope="col">NSAC ID</th>
<th scope="col">Member Name</th>
<th scope="col">Mobile</th>
<th scope="col">State</th>
<th scope="col">Email-ID</th>
<th scope="col">Membership</th>
<th scope="col">Status</th>
</tr>
</thead>
<tbody id="data">
<?php
$i=1;
while($row = mysqli_fetch_assoc($rslt)){
?>
<tr>
<td data-table="SNo."><?php echo $i;?></td>
<td data-table="NSAC ID"><?php echo $row['nsac'];?></td>
<td data-table="Name"><?php echo $row['artist_name'];?></td>
<td data-table="Mobile"><?php echo $row['artist_mobile'];?></td>
<td data-table="State"><?php echo $row['artist_state'];?></td>
<td data-table="Email"><?php echo $row['artist_email'];?></td>
<td data-table="Membership"><?php echo str_replace("_"," ",$row['artist_membership']);?></td>
<td data-table="Status"><?php echo $row['status'];?></td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
<div id="editor"></div>
</div>
</div>
<div class="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>
<script src="../js/tableHTMLExport.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/1.3.5/jspdf.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.2.4/jspdf.plugin.autotable.min.js"></script>
<script src="../js/importToExcel.js"></script>
</body>
</html>