1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / www / view /
Filename : course-cat.php
back
<?php
include("../admin/inc/config.php");
define("TITLE", "Course Catalog");
define("HEADER", "Course Catalog");
define("BREADCRUMB", "courses");
$pgView = true;

$paginatnUrl = "";
if(isset($_GET['cId'])) {
    $cId = $_GET['cId'];
    $getSubcats = getRows('subcategories',"*","category=$cId");
    $scArr = [];
    while($scRows=mysqli_fetch_array($getSubcats)){ $scArr[] = $scRows['id']; }

    $getItems = dbSelect("courses", "*", "LCASE(status)='active' AND category=$cId");
}
else{
    exit();
}

$itemsCnt = mysqli_num_rows($getItems);


include("../inc/head.php");
?>
<div class="">
    <?php include("../inc/header.php"); ?>
    <!-- /header -->

    <?php include("../inc/page-header.php"); ?>
    <!-- /page-header -->

    <section class="wrapper bg-light">
        <div class="container pb-8 pb-md-10 pt-12">
            <div class="row gy-10">
                <div class="col-lg-12">
                    <form action="">
                        <div class="row align-items-center mb-10 position-relative zindex-1">
                            <div class="col-md-7 col-xl-5 pe-xl-20">
                                <h4 class="display-6 fs-22 mb-1">Available Courses &amp; Programs</h4>
                                <p class="mb-0 text-muted"><?php echo $itemsCnt." item".($itemsCnt > 1 ? 's' : ''); ?> available</p>
                            </div>
                            <!--/column -->

                        </div>
                        <!--/.row -->
                    </form>
                    <div class="grid grid-view projects-masonry shop mb-13">
                        <div class="row gx-md-8 gy-10 gy-md-13 isotope">

                            <?php
                            if (isset($_GET['page_no']) && $_GET['page_no']!="") { $page_no = $_GET['page_no']; }
                            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";

                            if(isset($_GET['cId'])){
                                $cId = $_GET['cId'];
                                $catName = $_GET['catName'];
                                $result_count = dbSelect('courses',"COUNT(*) AS total_records","LCASE(status)='active' AND category=$cId");
                            }else{
                                $result_count = dbSelect('courses',"COUNT(*) AS total_records", "LCASE(status)='active'");
                            }
                            $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 page minus 1
                            if($total_records > 0){

                                if(isset($_GET['cId'])){
                                    $cId = $_GET['cId'];
                                    $catName = $_GET['catName'];
                                    $getItems = dbSelect("courses","*","LCASE(status)='active'","title");
                                }else{
                                    $getItems = dbSelect("courses","*","LCASE(status)='active'","title");
                                }
                                if($itemsCnt > 0){
                                    while($row = mysqli_fetch_array($getItems)){
                                            if(!in_array($row['category'],$scArr)){ continue; }
                                        ?>
                                        <div class="project item col-md-4 col-xl-4">
                                            <article>
                                                <div class="card shadow-lg">
                                                    <figure class="card-img-top overlay overlay-1"><a href="<?= $mainRoot ?>course/<?= $row['id'] ?>/<?= makeSlug($row['title']) ?>"> <img src="<?= $uploadsRoot ?>images/courses/<?= $row['image'] ?>" alt="" /></a>
                                                        <figcaption>
                                                            <h5 class="from-top mb-0">Read More</h5>
                                                        </figcaption>
                                                    </figure>
                                                    <div class="card-body p-6">
                                                        <div class="post-header">
                                                            <div class="post-category">
                                                                <a href="#" class="hover fs-11" rel="category"><?= getDBVal('subcategories',$row['category']) ?></a>
                                                            </div>
                                                            <!-- /.post-category -->
                                                            <h2 class="post-title h3 mt-1 mb-3"><a class="link-dark" href="<?= $mainRoot ?>course/<?= $row['id'] ?>/<?= makeSlug($row['title']) ?>"><?= $row['title'] ?></a></h2>
                                                        </div>
                                                        <!-- /.post-header -->
                                                        <div class="post-footer">
                                                            <ul class="post-meta d-flex mb-0">
                                                                <li class="post-likes text-primary fw-bold fs-16"><?= ($row['discPrice'] > 0) ? '₦'.number_format($row['discPrice']) : '₦'.number_format($row['price']) ?></li>
                                                                <li class="post-date ms-auto"><i class="uil uil-calendar-alt"></i><span><?= $row['duration']." weeks" ?></span></li>
                                                                <li class="post-users"><a href="<?= $mainRoot ?>enrol/<?= $row['id'] ?>/<?= makeSlug($row['title']) ?>" class="text-primary font-weight-bold">Apply</a></li>
                                                            </ul>
                                                            <!-- /.post-meta -->
                                                        </div>
                                                        <!-- /.post-footer -->
                                                    </div>
                                                    <!--/.card-body -->
                                                </div>
                                                <!-- /.card -->
                                            </article>
                                            <!-- /article -->
                                        </div>
                                        <!-- /.item -->
                                    <?php }}} else{ ?>
                                <div class="col-md-12">
                                    <h4 class="display-4">Item(s) coming soon</h4>
                                </div>
                            <?php } ?>
                        </div>
                        <!-- /.row -->
                    </div>
                    <!-- /.grid -->

                    <?php if($total_records > 0){ include("../inc/pagination.php"); } ?>

                </div>
                <!-- /column -->

            </div>
            <!-- /.row -->
        </div>
        <!-- /.container -->
    </section>
    <!-- /section -->
</div>
<?php include("../inc/footer.php"); ?>

<?php include("../inc/foot.php"); ?>