<?php
include_once("include/main.inc.php");
$hover = 'gallery';
$page_metatitle = "Photo Gallery - " . COMPANY_NAME;
$page_metakey = "Photo Gallery - " . COMPANY_NAME;
$page_metadesc = "Photo Gallery - " . COMPANY_NAME;
$gallery_sql = mysqli_query($GLOBALS['dbconn'], "select * from photo_tbl WHERE gallery_cat NOT IN ('1','2','3')");

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <?php include "app_top.php"; ?>
</head>

<body>

    <?php include "app_header.php"; ?>

    <div class="heading_banner" style="background-image: url(<?= site_url; ?>/designer/images/gallery-banner.jpg)">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12 text-center">
                    <h1 class="cat_title">Photo Gallery</h1>
                    <div class="clearfix"></div>
                </div>
            </div>
        </div>
    </div>

    <div class="inner_breadcrumb hidden_xs">
        <div class="container">
            <div class="row">
                <div class="col-xxl-12 col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <ul class="breadcrumb">
                        <li><a href="<?= site_url; ?>" title="Home">Home</a></li>
                        <li class="active">Photo Gallery</li>
                    </ul>
                </div>
            </div>
        </div>
    </div>


    <div class="gallery_page">
        <div class="container">
            <h2 class="title_2">Photo Gallery</h2>
            <div class="clearfix"></div>
            <div class="row">
                <?php while ($gallery_res = mysqli_fetch_assoc($gallery_sql)) { ?>

                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-6 col-12">
                        <div class="gallery_item">
                            <a class="hover_effect h_yellow" data-fancybox="photo-gallery" href="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_res['image']; ?>" title="<?= $gallery_res['title']; ?>">
                                <img src="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_res['image']; ?>" alt="<?= $gallery_res['title']; ?>" title="<?= $gallery_res['title']; ?>">
                            </a>
                            <div class="gallery_item_info">
                                <h4><?= $gallery_res['title']; ?></h4>
                            </div>
                        </div>
                    </div>
                <?php } ?>
            </div>
            <div class="clearfix"></div>
            <h3 class="title_2">Customers</h3>
            <div class="clearfix"></div>
            <div class="row">
                <?php
                $gallery_res1 = mysqli_query($GLOBALS['dbconn'], "select * from photo_tbl where gallery_cat='1'");
                while ($gallery_sql1 = mysqli_fetch_array($gallery_res1)) { ?>

                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-6 col-12">
                        <div class="gallery_item">
                            <a class="hover_effect h_yellow" data-fancybox="photo-gallery" href="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql1['image']; ?>" title="<?= $gallery_sql1['title']; ?>">
                                <img src="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql1['image']; ?>" alt="<?= $gallery_sql1['title']; ?>" title="<?= $gallery_sql1['title']; ?>">
                            </a>
                            <!-- <div class="gallery_item_info"><h4><?= $gallery_sql1['description']; ?></h4></div> -->
                        </div>
                    </div>
                <?php } ?>
            </div>
            <h4 class="title_2">Demo</h4>
            <div class="clearfix"></div>
            <div class="row">
                <?php
                $gallery_res3 = mysqli_query($GLOBALS['dbconn'], "select * from photo_tbl where gallery_cat='2'");
                while ($gallery_sql2 = mysqli_fetch_array($gallery_res3)) { ?>

                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-6 col-12">
                        <div class="gallery_item">
                            <a class="hover_effect h_yellow" data-fancybox="photo-gallery" href="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql2['image']; ?>" title="<?= $gallery_sql2['title']; ?>">
                                <img src="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql2['image']; ?>" alt="<?= $gallery_sql2['title']; ?>" title="<?= $gallery_sql2['title']; ?>">
                            </a>
                            <div class="gallery_item_info">
                                <h4><?= $gallery_sql2['description']; ?></h4>
                            </div>
                        </div>
                    </div>
                <?php } ?>
            </div>
            <h4 class="title_2">Training</h4>
            <div class="clearfix"></div>
            <div class="row">
                <?php
                $gallery_res3 = mysqli_query($GLOBALS['dbconn'], "select * from photo_tbl where gallery_cat='3'");
                while ($gallery_sql2 = mysqli_fetch_array($gallery_res3)) { ?>

                    <div class="col-xxl-4 col-xl-4 col-lg-4 col-md-4 col-sm-6 col-12">
                        <div class="gallery_item">
                            <a class="hover_effect h_yellow" data-fancybox="photo-gallery" href="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql2['image']; ?>" title="<?= $gallery_sql2['title']; ?>">
                                <img src="<?= site_url; ?>/uploaded-files/gallery/photos/<?= $gallery_sql2['image']; ?>" alt="<?= $gallery_sql2['title']; ?>" title="<?= $gallery_sql2['title']; ?>">
                            </a>
                            <div class="gallery_item_info">
                                <h4><?= $gallery_sql2['description']; ?></h4>
                            </div>
                        </div>
                    </div>
                <?php } ?>



            </div>
        </div>
    </div>
    <?php include "app_testimonials.php"; ?>
    <?php include "app_clients.php"; ?>
    <?php include "app_faq.php"; ?>

    <?php include "app_footer.php"; ?>
    <?php include "app_bottom.php"; ?>
</body>

</html>