1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / intekjyp / www / admin /
Filename : viewttm.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="">
							<h4 class="title-heading">TTM Uploads</h4>
						<table class="table table-striped table-bordered nowrap dataTable" id="example" style="width:100%;">
							<thead class="thead-dark">
    <tr>
      <th scope="col">Year</th>
      <th scope="col">Image</th>
      <th scope="col">Title</th>
      <th scope="col">Description</th>
      <th scope="col">Clicks</th>
      <th scope="col">Created By</th>
      <th scope="col">Date Created</th>
      <th scope="col">Status</th>
      <th scope="col">TTM File</th>
      <th scope="col">Edit</th>
      <th scope="col">Delete</th>      
    </tr>
  </thead>
   <tbody>
  	<?php 	/* Get data. */
    $get_event =mysqli_query($con, "SELECT * FROM ttm ORDER BY ttmid DESC");
    while($gal = mysqli_fetch_array($get_event)){
    ?>
    <tr>
      <td><?php echo $gal['ttmyear'];?></td>
      <td><img src="images/ttmimages/<?php echo $gal['ttmimage'];?>" style="width:80px; height:80px;" /></td>
      <td><?php echo $gal['ttmtitle'];?></td>
       <td><?php echo $gal['ttmdesc'];?></td>
      <td><?php echo $gal['ttmclicks'];?></td>
      
       <td><?php echo $gal['createdby'];?></td>
      <td><?php echo $gal['datecreated'];?></td>
      <td><?php echo $gal['showflag'];?></td>
      <td><a href="images/ttmfiles/<?php echo $gal['ttmfile'];?>" target="_blank"><i class="fa fa-file-pdf-o" style="font-size:3em"></i></a></td>
      <td><a href="editttm.php?ttmid=<?php echo $gal['ttmid'];?>"><i class="fa fa-edit" style="font-size:3em"></i></a></td>
      <td><form action="" method="POST">
                <input type="hidden" name="ttmid" value="<?php echo $gal['ttmid'];?>" />
                <input class="btn btn-danger" type="submit" value="Delete" name="delete_gallery">
            </form>
       </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"]))
	{
        $ttmid=$_POST['ttmid'];
        //echo "<script>confirm('Are you sure you want to delete?')</script>";
        $delete_gallery=mysqli_query($con,"DELETE FROM ttm WHERE ttmid='$ttmid'") or die(mysqli_error($con));
        echo "<script>window.location.href='viewttm.php'</script>";
        //header("Location: viewgallery.php");
  }
?>

</body>
</html>