<?php
    include('header.php');
    $news_letter_class = "newsletter-area-2";
?>
<style>
    .single-event
    {
        padding:0;
    }
    .single-event .time {
        padding:10px;
    }
</style>
<section class="page-banner">
    <div class="page-banner-bg bg_cover" style="background-image: url(assets/images/page-banner.jpg);">
        <div class="container">
            <div class="banner-content text-center">
                <h2 class="title">Gallery</h2>
            </div>
        </div>
    </div>
</section>

<section class="mt-30 mb-50">
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-lg-8">
                <div class="event-menu pt-20 text-center">
                    <ul class="menu-items">
                        <li data-filter="*" class="active">All</li>
                        <?php 
                            $sel_cat = mysqli_query($con,"select category from gallery where is_active=1 and section='Gallery' group by category");
                            while($res_cat = mysqli_fetch_array($sel_cat))
                            {
                                $cat_name = $res_cat['category'];
                                $cat_img = '';
                                $sel_cat_img = mysqli_query($con,"select * from gallery where is_active=1 and section='Gallery' AND category='$cat_name' AND is_category_img=1");
                                while($row_cat_img = mysqli_fetch_array($sel_cat_img)) {
                                    $cat_img = $row_cat_img['photo'];
                                }
                        ?>
                        <li data-filter=".<?php echo str_replace(' ','-',$cat_name); ?>" style="display: inline-table;padding: 5px; font-size:15px;">
                            <?php
                                if($cat_img == '') {
                                    echo $cat_name;
                                }
                                else {
                                    ?>
                                    <img src="adminweb/<?php echo $cat_img; ?>" style="width:150px;" class="img-responsive" />
                                    <br />
                                    <?php
                                    echo $cat_name;
                                }
                            ?>
                        </li>
                        <?php
                            }
                        ?>
                    </ul>
                </div>
            </div>
        </div>
        <div class="event-wrapper">
            <div class="row grid">
                <?php 
                $sel_gallery = mysqli_query($con,"select * from gallery where is_active=1 and section='Gallery'");
                while($res_gallery = mysqli_fetch_array($sel_gallery))
                {
                ?>
                <div class="col-lg-3 col-sm-6 <?php echo str_replace(' ','-',$res_gallery['category']); ?>">
                    <div class="single-event text-center mt-10">
                        <a class="image-popup" href="adminweb/<?php echo $res_gallery['photo']; ?>">
                            <img src="adminweb/<?php echo $res_gallery['photo']; ?>" class="img-responsive" />
                        </a>
                        <span class="time"><?php echo $res_gallery['title']; ?></span>
                    </div>
                </div>
                <?php
                }
                ?>
            </div>
        </div>
    </div>
</section>

<?php include('footer.php'); ?>