1#@!#!123s

: / home / diafrica / spre.dominicaninstitute.edu.ng /
Filename : gallery.php
back
<?php

$page_title;
$page_title = ucfirst(basename(__FILE__, '.php'));

if ($page_title === 'index') {
    $page_title = 'Home';
}
include './inc/config.php';
if (isset($_GET['sn'])) {
    $id = $_GET['sn'];
    $sql = "SELECT * FROM `programme` WHERE `id` = '$id'";
    $result = mysqli_query($con, $sql);
    $row = mysqli_fetch_assoc($result);
    $page_title = $row['title'];
}

$page_title = include 'sections/pages-header.php';
?>

<div class="container">
<section class="gallery sec-padd2" style="background-color:#ffffff">
    <div class="">
        <div class="row filter-layout">
            <?php
            include_once 'inc/config.php';
            if (isset($_GET['page']) && $_GET['page'] !== '') {
                $page_no = $_GET['page'];
            } else {
                $page_no = 1;
            }
            $total_records_per_page = 16;

            $offset = ($page_no - 1) * $total_records_per_page;
            $previous_page = $page_no - 1;
            $next_page = $page_no + 1;
            $adjacents = '2';

            $result_count = mysqli_query(
                $con,
                'SELECT COUNT(*) As total_records FROM `gallery`'
            );
            $total_records = mysqli_fetch_array($result_count);
            $total_records = $total_records['total_records'];
            $total_no_of_pages = ceil($total_records / $total_records_per_page);
            $second_last = $total_no_of_pages - 1; // total pages minus 1

            $result = mysqli_query(
                $con,
                "SELECT * FROM `gallery` LIMIT $offset, $total_records_per_page"
            );
            if (mysqli_num_rows($result) > 0) {
                // output data of each row
                while ($row = mysqli_fetch_assoc($result)) { ?>
            <article class="col-md-3 col-sm-6 col-xs-12 filter-item Consulting" style="margin-bottom:10px">
                <div class="item">
                    <img src="./uploads/gallery/<?= $row['image'] ?>" alt="">
                    <div class="overlay">
                        <div class="top">
                            <div class="box">
                                <div class="content">
                                    <a data-group="1" href="./uploads/gallery/<?= $row[
                                        'image'
                                    ] ?>" class="img-popup"><i class="fa fa-link"></i></a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="bottom">
                    <h4 href="#">
                        <p><?= $row['caption'] ?></p>
                    </h4>
                </div>
            </article>

            <?php }
            } else {
                 ?>

            <?php
            }
            ?>
        </div>

<?php if (mysqli_num_rows($result) > 0): ?>
            <ul class="page_pagination center">
                                        <?php if ($page_no > 1) {
                                            echo "<li><a href='?page=1' class='active tran3s'>1</a></li>";
                                        } ?>

                                            <li  <?php if ($page_no <= 1) {
                                                echo "class='disabled'";
                                            } ?>><a <?php if ($page_no > 1) {
    echo "href='?page=$previous_page'";
} ?> class="tran3s"><i class="fa fa-angle-left" aria-hidden="true"></i></a></li>

                                        <li >
                                        <strong>Page <?php echo $page_no .
                                            ' of ' .
                                            $total_no_of_pages; ?></strong>
                                        </li>
                                                
                                        
                                            <li <?php if (
                                                $page_no >= $total_no_of_pages
                                            ) {
                                                echo "class='disabled'";
                                            } ?>><a <?php if (
    $page_no < $total_no_of_pages
) {
    echo "href='?page=$next_page'";
} ?> class="tran3s"><i class="fa fa-angle-right" aria-hidden="true"></i></a></li>

                                            
                                            <?php if (
                                                $page_no < $total_no_of_pages
                                            ) {
                                                echo "<li><a href='?page=$total_no_of_pages'>Last</a></li>";
                                            } ?>
                        </ul>
    

        <?php endif; ?>
                 
    </div>
</section>


</div>

<?php include_once 'sections/footer.php'; ?>