1#@!#!123s

: / home / diafrica / spre.dominicaninstitute.edu.ng /
Filename : programmes.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';
?>

<section class="service sec-padd">
    <div class="container">
        <div class="row">
            <div class="col-md-3 col-sm-12">
                <div class="default-sidebar">
                    <ul class="service-catergory all-service"><li class=""><a href="#">View All Programmes <i class="fa fa-cog"></i></a></li></ul>
                    <ul class="service-catergory">
                    <?php
                    include_once 'inc/config.php';
                    $sql = 'SELECT * FROM programme ';
                    $result = mysqli_query($con, $sql);
                    if (mysqli_num_rows($result) > 0) {
                        // output data of each row
                        while ($row = mysqli_fetch_assoc($result)) { ?>
                              <li class="active"><a href="programme?sn=<?= $row[
                                  'id'
                              ] ?>"><?= $row['title'] ?></a></li>
                            <?php }
                    } else {
                         ?>
                        <?php
                    }
                    ?>
                                            
                    </ul>
                     
                   </div>
            </div>
            <div class="col-md-9 col-sm-12">
                <div class="service-area-2">
                    <div class="row">
                       
                    <?php
                    include_once 'inc/config.php';
                    if (isset($_GET['page']) && $_GET['page'] !== '') {
                        $page_no = $_GET['page'];
                    } else {
                        $page_no = 1;
                    }
                    $total_records_per_page = 10;

                    $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 `programme`'
                    );
                    $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 `programme` LIMIT $offset, $total_records_per_page"
                    );

                    if (mysqli_num_rows($result) > 0) {
                        // output data of each row
                        while ($row = mysqli_fetch_assoc($result)) { ?>
                             <div class="col-md-4 col-sm-4 col-xs-12">
                             <!--Start single item-->
                             <div class="single-item text-center">
                                <div class="img-box">
                                    <img src="./uploads/programme/<?= $row[
                                        'image'
                                    ] ?>" alt="">                            
                                </div>
                                <div class="content">
                                    <div class="text-holder">
                                        <a href="#"><h4><?= $row[
                                            'title'
                                        ] ?></h4></a>  
                                        <p></p>
                                    </div>
                                    <div class="overlay">
                                        <p>
                                            <?= $row['caption'] ?>
                                        </p>
                                        <div class="link">
                                            <a href="programme?sn=<?= $row[
                                                'id'
                                            ] ?>" class="default_link">Read More<i class="fa fa-angle-right"></i></a>
                                        </div>
                                    </div>
                                </div>
                                    
                            </div>
                            <!--End single item-->
                            </div>
             <?php }
                    } else {
                         ?>

            <?php
                    }

// mysqli_close($con);
?>
                           

                       
                    </div>  
                </div>
                <?php include_once './sections/pagination-buttons.php'; ?>
            </div>
        </div>
    </div>
</section>


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