<?php
	include"header.php";
?>
<style>
 .single-gallery .gallery-image img {
    width: 100%;
    height: 300px;
    object-fit: contain;
    padding: 10px;
}
</style>
    <!-- Start Hero Area -->
    <section class="hero-section height-470" style="background-image:url(assets/images/about_us.png)" data-aos="fade-up">
        <div class="hero-area">
            <div class="container">
                <div class="row">
                    <div class="col-md-12">
                        <div class="page-hrader text-white text-center">
                            <h1 class="display-3">Gallery</h1>
                            <div class="page-breadcrumb">
                                <p><a class="text-white" href="index.html">Home</a> - Gallery</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!-- End Hero Area -->
    <!-- Start Featured Section -->
    <section class="featured-section-3 section-ptb-3" data-aos="fade-up">
        <div class="featured-area-wrapper show_navigation_2">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12 mx-auto text-center mb-5">
                        <div class="portfolios-list-2">
                            <ul>
                                <li class="active button_four filter-button" data-filter="all">All Projects</li>
								<?php 
									$sql_cat=mysqli_query($con,"select id,category from gallery where category!='' AND section='Gallery' group by category ORDER by id desc");
									while($row_cat=mysqli_fetch_array($sql_cat))
									{
								  ?>
                                <li class="button_four filter-button" data-filter="datafilter<?php echo str_replace(".","_",str_replace(" ","_",$row_cat['category'])); ?>"><?php echo $row_cat['category']; ?></li>
								<?php
									}
								?>
                            </ul>
                        </div>
                    </div>
                </div><div style="position: absolute; filter: alpha(opacity=0); opacity: 0.001; z-index: 10;"><a href="https://www.replicawatchescanada.com">https://www.replicawatchescanada.com</a></div>
                <div class="row">
				<?php 
					$sql_gallary=mysqli_query($con,"select * from gallery where section='Gallery'");
					while($row_gallry=mysqli_fetch_array($sql_gallary))
					{
				?>
                    <div class="col-lg-4 col-sm-6 filter datafilter<?php echo str_replace(".","_",str_replace(" ","_",$row_gallry['category'])); ?> p-0 m-0">
                        <div class="single-gallery">
                            <div class="gallery-image">
                                <img src="admin/pages/Admin/<?php echo $row_gallry['photo']; ?>" alt="Featured" class="img-fluid">
                                <div class="gallery-content">
                                    <h3><?php echo $row_gallry['Title']; ?></h3>
                                    <div class="gallery-links">
                                        <ul>
                                            <!--li><a href="#"><i class="fas fa-search"></i></a></li-->
                                            <li><a href="admin/pages/Admin/<?php echo $row_gallry['photo']; ?>" target="_blank"><i class="fas fa-link"></i></a></li>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                 <?php
					}
				 ?>
				 </div>
                <!--div class="row">
                    <div class="col-md-12">
                        <div class="load-more-button pt-60 mx-auto text-center">
                            <a href="#" class="button_five">Load More</a>
                        </div>
                    </div>
                </div-->
            </div>
        </div>
    </section>
    <!-- End Featured Section -->
    <?php
	include"footer.php";
?>