<?php 
	require_once('Connections/conn_ama.php');
	
	if(!isset($_SESSION)){
        session_start();
    }
    	

    	//Retrieve Galleries
    	$query_rsNews = "SELECT galleryID, ah, gallerytitle, gallerydesc, dateAdded  FROM galleries ORDER BY dateAdded DESC";
	    $rsNews = mysqli_query($conn_ama, $query_rsNews ) or die(mysqli_error($conn_ama));
	    $row_rsNews = mysqli_fetch_assoc($rsNews);
	    $totalRows_rsNews = mysqli_num_rows($rsNews);/**/
 ?>
<!-- <div class="col-md-9 data-area"> -->
	<div class="mreport-steps">
		<?php //include("mreport-steps.inc.php"); ?>
	</div><!-- End .mreport-step-->
	<div class="data-area-wrap">
		<div class="form-wrapper">
			<table id="example" class="table" cellspacing="0" width="100%">
		        <thead>
		            <tr>
		                <th>Gallery Title</th>
		                <th nowrap="nowrap">Date Created</th>

		                <th>Edit</th>
		                <th>Delete</th>
		            </tr>
		        </thead>
		       
		        <tbody>
		        <?php do { ?>
		            <tr>
		                <td><a href="#" class="data-gallery" data-gallery="<?php echo $row_rsNews['ah']; ?>"><?php echo $row_rsNews['gallerytitle']; ?></a>	</td>
	                  	<td><?php echo date('d-m-Y', strtotime($row_rsNews['dateAdded'])); ?></td>
						<td><a href="#" 
								class="galleryedit" 
								data-galleryedit="<?php echo $row_rsNews['ah']; ?>"
								><i class="fas fa-edit"></i></a></td>
						<td><a href="#" 
								class="gallerydelete" 
								data-gallerydelete="<?php echo $row_rsNews['ah']; ?>"
								><i class="fas fa-times-circle fa-1x"></i></a></td>
		            </tr>
		        <?php } while($row_rsNews = mysqli_fetch_assoc($rsNews));?>
		            
		    	</tbody>
		    </table>
		</div><!-- End .form-wrapper-->
	</div><!-- End .data-area-wrap-->	
<!-- </div> -->

<script>

    $(document).ready( function() {
        $('#example').dataTable({
        	"pageLength": 10,
        	"order": []
        });
    });
</script>