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

    <!-- ==============================================
    ** Inner Banner **
    =================================================== -->
    <div class="inner-banner blog">
        <div class="container">
            <div class="row">
                <div class="col-sm-12">
                    <div class="content">
                        <h1 style="color:#f47435">Gallery - Video</h1>
                    </div>
                </div>
            </div>
        </div>
    </div>

     <?php
include 'admin/pages/config/config.php';
// Connect to MySQL
// MySQL query that selects all the images



?>
    <!-- ==============================================
    ** News & Events **
    =================================================== -->
    <section class="campus-tour padding-lg" style="padding-top: 5px;padding-bottom: 5px;">
        <div class="container">
            <?php
            $stmt1 =mysqli_query($con,"SELECT distinct category FROM `video_pdf` where type='PDF' ORDER BY `id` DESC");
            while($row1=mysqli_fetch_array($stmt1))
            {
                $category=$row1['category'];
            ?>
            <h5 style="margin-top:20px;"><?php echo $category; ?></h5>
            <div class="row">
                <?php
                    $stmt =mysqli_query($con,"SELECT * FROM `video_pdf` where type='PDF' and category='$category'  ORDER BY `id` DESC");
                    foreach ($stmt as $name) {
                ?>
                <div class="col-md-3" style="margin-top:20px;">
                    <a  target="blank" href="<?php echo $name['url']; ?>" >
                        <img style="width:100%;padding:10px;" src="<?php echo "/admin/pages/Admin/".$name['photo']; ?>" class="img-responsive" alt="">    
                    </a>
                    <h6 class="text-center" style="margin-bottom:10px;"><?php echo $name['Title']; ?></h6>
                </div>
                <?php
                    }
                ?>
            </div>
            <?php
                }
            ?>
        </div>
    </section>
  <?php include "footer.php"; ?>
</body>
</html>