<!DOCTYPE php>
<php lang="en">

 <?php include('link/header.php');?>
        <!-- Content -->
        <div class="page-content new-style-admin-page">
            <!-- inner page banner -->
            <div class="dez-bnr-inr overlay-black-middle" style="background-image:url(images/background/gallery.jpg);">
                <div class="container">
                    <div class="dez-bnr-inr-entry">
                        <h1 class="text-white inner-page-title">Gallery</h1>
                    </div>
                </div>
            </div>
            <!-- inner page banner END -->
            <!-- Breadcrumb row -->
            <div class="breadcrumb-row">
                <div class="container">
                    <ul class="list-inline">
                        <li><a href="index.php">Home</a></li>
                        <li>Gallery</li>
                    </ul>
                </div>
            </div>
            <!-- Breadcrumb row END -->
            <!-- contact area -->
            <div class="content-area">
                <!-- Our Awesome Services -->

                <div class="section-full awesome-services bg-white list-in-admin">
                    <div class="container">
<?php
	
	include("link/databaseconnection.php");


$sel1="select * from gallery";
$t=mysqli_query($conn,$sel1);
$total=mysqli_num_rows($t);
$start=0;
$limit=9;
if(isset($_GET['id']))
{
	$id=$_GET['id'];
	$start=($id-1)*$limit;
}
else
{
	$id=1;
}
$page=ceil($total/$limit);
$sel="select * from gallery order by id desc limit $start,$limit";
$res=mysqli_query($conn,$sel);
	
	
	
	
	
	
	
	
	?>
                        <div class="row" id="results">
<?php 
		 
		while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
			
		{	
		
		?>
				<div class="col-sm-4 col-xs-6 gallery-grid">
					<div class="grid effect-apollo dez-media dez-img-overlay1 dez-img-effect zoom-slow radius-sm wow fadeInLeft"data-wow-delay="2ms" style='border:3px solid green'> 
						<a class="example-image-link" href="#" data-lightbox="example-set" class='wow ' style="height:250px;width:100%">
							<img src="code/img/<?php echo $row['image']?>" style="height:250px;width:100%" class='img-responsive'alt=""/>
							<div class="figcaption">
								
							</div>	
						</a> 
					</div>
				</div>
				
				<?php
			
		}
			?>

                        </div>
<BR/>
<ul class="pagination">
	<?php
	if($id > 1)
	{
	
	?>
	<li><a href="?id=<?php echo ($id-1) ;?>" >Previous</a></li>
	<?php 
	}
	?>
	<?php 
	for($i=1;$i<=$page;$i++)
	{
	
	?>
	<li><a href="?id=<?php echo $i;?>"><?php echo $i;?></a></li>
	<?php
	}
	
	?>
	<?php
	if($id<$page)
	{
	?>
	<li><a href="?id=<?php echo $id+1;?>">Next</li>
	<?php
	}
	?>
	</ul>
                        <div class="row m-t50">

                            <div class="col-md-12">
                                <div id="result"></div>
                            </div>

                        </div>


                    </div>
                </div>


            </div>
        </div>
        <!-- Content END-->
        <!-- Footer -->
  <?php include('link/footer.php')?>
        <!-- Footer END-->
        <!-- Footer End -->

        <button class="scroltop fa fa-long-arrow-up"></button>
    </div>
    <!-- JavaScript  files ========================================= -->
    <script type="text/javascript" src="js/jquery.min.js"></script>
    <!-- jquery.min js -->
    <script type="text/javascript" src="js/bootstrap.min.js"></script>
    <!-- bootstrap.min js -->
    <script type="text/javascript" src="js/bootstrap-select.min.js"></script>
    <!-- Form js -->
    <script type="text/javascript" src="js/jquery.bootstrap-touchspin.js"></script>
    <!-- Form js -->
    <script type="text/javascript" src="js/magnific-popup.js"></script>
    <!-- magnific-popup js -->
    <script type="text/javascript" src="js/waypoints-min.js"></script>
    <!-- waypoints js -->
    <script type="text/javascript" src="js/counterup.min.js"></script>
    <!-- counterup js -->
    <script type="text/javascript" src="js/imagesloaded.js"></script>
    <!-- masonry  -->
    <script type="text/javascript" src="js/masonry-3.1.4.js"></script>
    <!-- masonry  -->
    <script type="text/javascript" src="js/masonry.filter.js"></script>
    <!-- masonry  -->
    <script type="text/javascript" src="js/owl.carousel.js"></script>
    <!-- OWL  Slider  -->
    <script type="text/javascript" src="js/custom.min.js"></script>
    <!-- custom fuctions  -->
    <script type="text/javascript" src="js/sortcode.php"></script>
    <script src="js/wow.min.js"></script>
    <script>
        new WOW().init();
    </script>
</body>


</php>