File: /home/u590867752/domains/artnculture.org/public_html/admin/ParticipationArtists/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');
}
try{
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$nsac_artist = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `artist_membership` = 'Participation_Membership' ORDER BY DATE_FORMAT(date_time, '%d-%m-%y') DESC";
$nsac_artist_active = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `artist_membership` = 'Participation_Membership' AND `status` = 'ACTIVE'";
$active = $con->query($nsac_artist_active);
$nsac_artist_deactive = "SELECT * FROM `artist_registration` WHERE `nsac` IS NOT NULL AND `artist_membership` = 'Participation_Membership' 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>Participation 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>Participation 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="participation_members_details.php?participation_members=<?php echo "ALL";?>"><span>Total Artist : <?php echo $exe->rowCount();?></span></a>
<a href="participation_members_details.php?participation_members=<?php echo "ACTIVE";?>"><span>Acive Active : <?php echo $active->rowCount();?></span></a>
<a href="participation_members_details.php?participation_members=<?php echo "DEACTIVE";?>"><span>Deactiv Deactiv: <?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>Date</th>
<td>Member Name</th>
<td>Mobile</th>
<td>State</th>
<td>Membership</th>
<td>OTP Status</th>
</tr>
</thead>
<tbody>
<?php
foreach($rslt as $row){
$i++;
?>
<tr>
<td><label><input type="checkbox"><span class="checkicon" data-text="✓"></span></label></th>
<td data-table="SNo."><?php echo $i;?></th>
<td data-table="Date"><?php echo $row['date_time'];?></th>
<td data-table="Member Name"><?php echo $row['artist_name'];?></th>
<td data-table="Mobile"><?php echo $row['artist_mobile'];?></th>
<td data-table="State"><?php echo $row['artist_state'];?></th>
<td data-table="Membership"><?php echo str_replace("_"," ",$row['artist_membership']);?></th>
<td data-table="OTP Status"><?php echo $row['verify'];?>
<div class="fd">
<i class="fa fa-arrow-down" aria-hidden="true"></i>
<i class="fa fa-trash" aria-hidden="true"></i>
</div></th>
</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>