1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / intekjyp / www / admin /
Filename : subscriptions.php
back
<?php
	require_once 'connect.php';
	 if(!isset($_SESSION['aemail'])){
        //header("Location:index.php");
        echo "<script>window.location.href='login.php'</script>"; 
    }
$aemail=$_SESSION['aemail'];
$aname=$_SESSION['aname'];
	require_once 'top.php';

?>

						<div class="pull-left" style="border:1px solid green; width:90%; margin-left:5%;">
							<div class="leave-comment-box">
							<h4 class="title-heading">Subscriptions</h4>
						<table class="table table-striped table-bordered nowrap dataTable" id="example" style="width:100%;">
							<thead class="thead-dark">
    <tr>
      <th scope="col">Full Name</th>
      <th scope="col">Email</th>
      <th scope="col">Package</th>
      <th scope="col">Status</th>
      <th scope="col">Date Subscribed</th>
      <th scope="col">Date Confirmed</th>
      <th scope="col">Administrator</th>
      <th scope="col">Activate/Deactive</th>
      
      
    </tr>
  </thead>
   <tbody>
  	<?php 	/* Get data. */
    $get_event =mysqli_query($con, "SELECT * FROM subscription ORDER BY semail DESC");
    while($gal = mysqli_fetch_array($get_event)){
    ?>
    <tr>
     
      <td><?php echo $gal['sname'];?></td>
      <td><?php echo $gal['semail'];?></td>
       <td><?php echo $gal['subtype'];?></td>
      <td><?php echo $gal['substatus'];?></td>
       <td><?php echo $gal['datecreated'];?></td>
      <td><?php echo $gal['dateconfirmed'];?></td>
      <td><?php echo $gal['createdby'];?></td>
      <td><a href="activate.php?semail=<?php echo $gal['semail'];?>" class="btn btn-primary">Activate/Deactivate</a></td>
      
    </tr>
<?php } ?>
  </tbody>

						</table>
					
						</div>
					</div>
	
		
	</div>
	<script src="js/vendor/modernizr.min.js"></script>
<script src="js/vendor/jquery.min.js"></script>
<script src="js/vendor/jquery-3.5.0.min.js"></script>

<script src="js/vendor/jquery.dataTables.min.js"></script>
<script src="js/vendor/dataTables.bootstrap.min.js"></script>
<script src="js/vendor/dataTables.responsive.min.js"></script>
<script src="js/vendor/responsive.bootstrap.min.js"></script>

<script type='text/javascript' src='js/script.js'></script>

<script>

$(document).ready(function() {
    var table = $('#example').DataTable( {
        responsive: true
    } );
} );

</script>

<?php
		//delete gallery
   if(isset($_POST["delete_gallery"]))
	{
        $jid=$_POST['jid'];
        //echo "<script>confirm('Are you sure you want to delete?')</script>";
        $delete_gallery=mysqli_query($con,"DELETE FROM career WHERE jid='$jid'") or die(mysqli_error($con));
        echo "<script>window.location.href='viewcareer.php'</script>";
        //header("Location: viewgallery.php");
  }
?>

</body>
</html>