1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / public_html / dump /
Filename : index.php
back
<?php
include("admin/inc/config.php");
include("inc/head.php");

define ('TITLE', 'ICT Home | ICT Courses to boost your skills');
?>

<body>
    <!-- ========== HEADER ========== -->
    <?php include("inc/header.php"); ?>
    <!-- ========== END HEADER ========== -->

    <!-- ========== MAIN CONTENT ========== -->
    <main id="content" role="main">
        <!-- Hero -->
        <div class="container content-space-2">
            <div class="row justify-content-md-between align-items-sm-center">
                <div class="col-8 col-sm-6 col-md-5 mb-5 mb-sm-0">
                    <img class="img-fluid" src="<?php echo $mainRoot; ?>assets/svg/illustrations/oc-growing.svg" alt="">
                </div>
                <!-- End Col -->

                <div class="col-sm-6">
                    <div class="mb-5">
                        <h1 class="display-4 mb-3">
                            Unlock your
                            <br>
                            <span class="text-theme text-highlight-warning">
                                <span class="js-typedjs" data-hs-typed-options='{
                        "strings": ["career.", "potential.", "skills."],
                        "typeSpeed": 90,
                        "loop": true,
                        "backSpeed": 30,
                        "backDelay": 2500
                      }'></span>
                            </span>
                        </h1>
                        <p class="lead">With our programs, you can widen your horizon, grow your skillset and stay competitive in 21<sup>st</sup> century labour market.</p>
                    </div>

                    <div class="d-grid d-md-flex gap-3 align-items-md-center">
                        <a class="btn btn-info" href="<?php echo $mainRoot; ?>">Enrol Now!</a>

                    </div>
                </div>
                <!-- End Col -->
            </div>
            <!-- End Row -->
        </div>
        <!-- End Hero -->

        <!-- Card Grid -->
        <div class="content-space-b-2 content-space-b-lg-3 bg-img-start" style="background: url(<?php echo $mainRoot; ?>assets/svg/components/shape-5.svg) center no-repeat;">
            <div class="position-relative">
                <div class="container content-space-2">
                    <div class="row align-items-md-center mb-7">
                        <div class="col-md-6 mb-4 mb-md-0">
                            <h2>Check out our programs</h2>
                        </div>
                        <!-- End Col -->

                        <div class="col-md-6 text-md-end">
                            <a class="link text-theme" href="#">See all programs <i class="bi-chevron-right small ms-1"></i></a>
                        </div>
                        <!-- End Col -->
                    </div>
                    <!-- End Row -->

                    <!-- Swiper Slider -->
                    <div class="swiper-center-mode-end">
                        <div class="js-swiper-course-hero swiper">
                            <div class="swiper-wrapper">
                                <?php
                                $query = mysqli_query($db, "SELECT courses.id AS cId, courses.title, courses.image, courses.dateAdded, courses.dateUpdated, courses.status, subcategories.name AS scName, categories.name AS cName FROM courses LEFT JOIN subcategories ON courses.category=subcategories.id LEFT JOIN categories ON categories.id=subcategories.category WHERE courses.status='Active' ORDER BY courses.dateAdded LIMIT 20");

                                while($row = mysqli_fetch_array($query)){
                                    $cId = $row['cId'];
                                    $title = $row['title'];
                                    $scName = $row['scName'];
                                    $cName = $row['cName'];
                                    $image = $row['image'];
                                    $dateAdded = strtotime($row['dateAdded']);
                                    $timeAgo = getTimeAgo($dateAdded);
                                    $emptyDU = $row['dateUpdated'];
                                    $status = $row['status'];

                                ?>
                                <!-- Slide -->
                                <div class="swiper-slide pt-2">
                                    <!-- Card -->
                                    <a class="card card-sm card-stretched-vertical card-transition bg-img-start" href="course/<?php echo $cId; ?>" style="background-image: url(<?php echo $uploadsRoot; ?>images/courses/<?php echo $image; ?>); min-height: 15rem;">
                                        <div class="card-body">
                                            <span class="card-subtitle text-white-70"><?php echo $cName; ?></span>
                                            <h4 class="card-title text-white"><?php echo $title; ?></h4>

                                            <div class="card-footer pt-0">
                                                <span class="card-link">View</span>
                                            </div>
                                        </div>
                                    </a>
                                    <!-- End Card -->
                                </div>
                                <!-- End Slide -->
                                <?php } ?>
                            </div>

                            <!-- Arrows -->
                            <div class="js-swiper-course-hero-button-next swiper-button-next"></div>
                            <div class="js-swiper-course-hero-button-prev swiper-button-prev"></div>
                        </div>
                    </div>
                    <!-- End Swiper Slider -->
                </div>

                <div class="w-100 w-md-65 bg-light position-absolute top-0 end-0 bottom-0 zi-n1"></div>
            </div>
        </div>
        <!-- End Card Grid -->

        <!-- Card Grid -->
        <div class="container content-space-sm-2">
            <!-- Title -->
            <div class="w-md-75 text-center mx-md-auto mb-9">
                <h2>Featured courses</h2>
                <p>Discover your perfect program in our courses.</p>
            </div>
            <!-- End Title -->

            <div class="row row-cols-1 row-cols-sm-1 row-cols-md-3 mb-5">
                <?php
                $query = mysqli_query($db, "SELECT courses.id AS cId, courses.title, courses.duration, courses.price, courses.discPrice, courses.image, courses.dateAdded, courses.dateUpdated, courses.status, subcategories.name AS scName, categories.name AS cName FROM courses LEFT JOIN subcategories ON courses.category=subcategories.id LEFT JOIN categories ON categories.id=subcategories.category WHERE courses.status='Active' ORDER BY courses.dateAdded LIMIT 6");

                while($row = mysqli_fetch_array($query)){
                    $cId = $row['cId'];
                    $title = $row['title'];
                    $scName = $row['scName'];
                    $cName = $row['cName'];
                    $duration = $row['duration'];
                    $price = number_format($row['price']);
                    $discPrice = number_format($row['discPrice']);
                    $image = $row['image'];
                    $dateAdded = strtotime($row['dateAdded']);
                    $timeAgo = getTimeAgo($dateAdded);
                    $emptyDU = $row['dateUpdated'];
                    $status = $row['status'];
                    $status = ($status == 'Active' ? 'Open' : 'Closed');
                ?>
                <div class="col mb-5">
                    <!-- Card -->
                    <div class="card card-bordered h-100">
                        <!-- Card Pinned -->
                        <div class="card-pinned">
                            <img class="card-img-top" src="<?php echo $uploadsRoot; ?>images/courses/<?php echo $image; ?>" alt="">
                            <div class="card-pinned-top-start">
                                <small class="badge bg-success rounded-pill"><?php echo $status; ?></small>
                            </div>
                            <div class="card-pinned-bottom-start">
                                <div class="d-flex align-items-center flex-wrap">
                                    <!-- Rating -->
                                    <div class="d-flex gap-1">
                                        <img src="<?php echo $mainRoot; ?>assets/svg/illustrations/star-muted.svg" alt="Review rating" width="16">
                                        <img src="<?php echo $mainRoot; ?>assets/svg/illustrations/star-muted.svg" alt="Review rating" width="16">
                                        <img src="<?php echo $mainRoot; ?>assets/svg/illustrations/star-muted.svg" alt="Review rating" width="16">
                                        <img src="<?php echo $mainRoot; ?>assets/svg/illustrations/star-muted.svg" alt="Review rating" width="16">
                                        <img src="<?php echo $mainRoot; ?>assets/svg/illustrations/star-muted.svg" alt="Review rating" width="16">
                                    </div>
                                    <!-- End Rating -->
                                    <div class="ms-3 text-white">
                                        <span class="fw-semi-bold  me-1">0.0</span>
                                        <span class="">(0 review)</span>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- End Card Pinned -->
                        <!-- Card Body -->
                        <div class="card-body">
                            <small class="card-subtitle"><?php echo $scName; ?></small>
                            <div class="mb-3">
                                <h3 class="card-title">
                                    <a class="text-dark" href="<?php echo $mainRoot; ?>course/<?php echo $cId; ?>"><?php echo $title; ?></a>
                                </h3>
                            </div>
                            <div class="row align-items-center">
                                <div class="col">
                                    <div class="avatar-group avatar-group-xs">
                                        <a class="avatar avatar-xs avatar-circle" data-toggle="tooltip" data-placement="top" title="Nataly Gaga" href="#">
                                            <!--<img class="avatar-img" src="<?php echo $mainRoot; ?>assets/img/160x160/img3.jpg" alt="">-->
                                        </a>
                                    </div>
                                </div>
                                <!-- End Col -->
                                <div class="col-auto">
                                    <ul class="list-inline list-separator small ms-auto">
                                        <li class="list-inline-item">
                                            <i class="bi-calendar me-1"></i> <?php echo $duration.($duration > 1 ? 's' : ''); ?>
                                        </li>
                                        <li class="list-inline-item">
                                            <i class="bi-people me-1"></i> 27
                                        </li>
                                    </ul>
                                </div>
                                <!-- End Col -->
                            </div>
                            <!-- End Row -->
                        </div>
                        <!-- End Card Body -->

                        <!-- Card Footer -->
                        <div class="card-footer pt-0">
                            <div class="d-flex justify-content-between align-items-center">
                                <div class="me-2">
                                    <?php if($discPrice != 0): ?>
                                    <span class="d-block text-muted small"><del>₦<?php echo $price; ?></del></span>
                                    <h5 class="card-title">₦<?php echo $discPrice; ?></h5>
                                    <?php else: ?>
                                    <h5 class="card-title">₦<?php echo $price; ?></h5>
                                    <?php endif ?>
                                </div>
                                <a class="btn btn-info btn-sm btn-transition" href="<?php echo $mainRoot; ?>course/<?php echo $cId; ?>">Preview</a>
                            </div>
                        </div>
                        <!-- End Card Footer -->
                    </div>
                    <!-- End Card -->
                </div>
                <!-- End Col -->
                <?php } ?>
            </div>
            <!-- End Row -->

            <div class="text-center">
                <a class="btn btn-link" href="">See all courses <i class="bi-chevron-right small ms-1"></i></a>
            </div>
        </div>
        <!-- End Card Grid -->

        <!-- CTA -->
        <?php include("inc/cta.php"); ?>
        <!-- End CTA -->
    </main>
    <!-- ========== END MAIN CONTENT ========== -->

    <!-- ========== FOOTER ========== -->
    <?php include("inc/footer.php"); ?>
    <!-- ========== END FOOTER ========== -->

    <!-- ========== SECONDARY CONTENTS ========== -->
    <?php include("inc/sec.php"); ?>
    <!-- ========== END SECONDARY CONTENTS ========== -->

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

</html>