File: /home/u590867752/domains/artnculture.org/public_html/admin/AllArtists/index.php
<?php
include('../php-backend/connection.php');
session_start();
if(empty($_SESSION['Adminlogin']) || $_SESSION['Adminlogin'] == ""){
header('Location:http://www.artnartist.in/admin/index.html');
}
if($_SESSION['members'] == "False" || $_SESSION['members'] == ""){
header('Location:http://www.artnartist.in/admin/index.html');
}
try{
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$nsac_artist = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL ORDER BY DATE_FORMAT(date_time, '%d-%m-%y') DESC";
$nsac_artist_active = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND`status` = 'ACTIVE'";
$active = $con->query($nsac_artist_active);
$nsac_artist_deactive = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `status` = 'DEACTIVE'";
$deactive = $con->query($nsac_artist_deactive);
$exe = $con->query($nsac_artist);
$rslt = $exe->fetchAll(PDO::FETCH_ASSOC);
$i=0;
if($exe === 0){
}else{
}
}catch(PDOException $e){
echo "ERROR IS ".$e->getMessage();
}
?>
<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">
<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="../js/nsac.js"></script>
<script src="../js/abhishek.js"></script>
<script src="../js/messageAction.js"></script>
<script src="../js/paggination.js"></script>
<script src="../js/deleteAction.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 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">
<div class="table-ttl">
<div class="act-part">
<a href="all_members_details.php?all_members=<?php echo "ALL";?>"><span>Total Artist : <?php echo $exe->rowCount();?></span></a>
<a href="all_members_details.php?all_members=<?php echo "ACTIVE";?>"><span>Acive Artists : <?php echo $active->rowCount();?></span></a>
<a href="all_members_details.php?all_members=<?php echo "DEACTIVE";?>"><span>Deactiv Deactive: <?php echo $deactive->rowCount();?></span></a>
</div>
</div>
<table id="promotional_members_table">
<thead>
<tr>
<td><span class="delall"><i class="fa fa-trash" aria-hidden="true"></i></span></th>
<td>SNO</th>
<td><span class="spc mess">✉</span></th>
<td><span class="spc mobl">📞</span></th>
<td><span class="spc addr">🏰</span></th>
<td>NSAC Id</th>
<td>Member Name</th>
<td>Mobile</th>
<td>State</th>
<td>Membership</th>
</tr>
</thead>
<tbody id = "pagination">
<?php
foreach($rslt as $row){
$i++;
?>
<tr>
<td><label><input type="checkbox"><span class="checkicon" data-text="✓"></span></label></td>
<td data-table="SNO"><?php echo $i;?></td>
<td data-table="✉"><?php if($row['verify'] == "Verify"){
echo '<i class="fa fa-check active" aria-hidden="true"></i>';
}else{
echo '<i class="fa fa-times deactive" aria-hidden="true"></i>';
}?></td>
<td data-table="📞"><?php if($row['verify'] == "Verify"){
echo '<i class="fa fa-check active" aria-hidden="true"></i>';
}else{
echo '<i class="fa fa-times deactive" aria-hidden="true"></i>';
}?></td>
<td data-table="🏰"><?php if($row['verify'] == "Verify"){
echo '<i class="fa fa-check active" aria-hidden="true"></i>';
}else{
echo '<i class="fa fa-times deactive" aria-hidden="true"></i>';
}?></td>
<td data-table="NSAC Id"><?php echo $row['nsac'];?></td>
<td data-table="Member 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="Membership"><?php
if($row['artist_membership'] == "Participation_Membership"){
echo "<span class='showmt pm'>P</span>";
} else if($row['artist_membership'] == "Promotional_Membership"){
echo "<span class='showmt im'>I</span>";
}else if($row['artist_membership'] == "Executive_Membership"){
echo "<span class='showmt em'>E</span>";
}else if($row['artist_membership'] == "Volunteer"){
echo "<span class='showmt vm'>V</span>";
}else{
echo "";
}
?>
<div class="fd">
<i class="fa fa-arrow-down" aria-hidden="true"></i>
</div>
</td>
</tr>
<?php
}
?>
</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>