Server : Apache System : Linux server1.cgrithy.com 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64 User : nobody ( 99) PHP Version : 8.1.23 Disable Function : NONE Directory : /home/dnlcambodia/public_html/ |
<?php include './dnl_dashboard/PHP/config/db_conn.php'; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Our Some Activities</title> <meta name="description" content="DNL" /> <meta name="keywords" content="cargo, clean, contractor, corporate, freight, industry, localization, logistics, page builder, shipment, transport, transportation, truck, trucking" /> <meta name="author" content="Themexriver" /> <link rel="shortcut icon" href="assets/img/logo/logo3.png" type="image/x-icon" /> <!-- Mobile Specific Meta --> <meta name="viewport" content="width=device-width, initial-scale=1" /> <link rel="stylesheet" href="assets/css/bootstrap.min.css" /> <link rel="stylesheet" href="assets/css/fontawesome-all.css" /> <link rel="stylesheet" href="assets/css/flaticon.css" /> <link rel="stylesheet" href="assets/css/animate.css" /> <link rel="stylesheet" href="assets/css/nice-select.css" /> <link rel="stylesheet" href="assets/css/video.min.css" /> <link rel="stylesheet" href="assets/css/animated-slider.css" /> <link rel="stylesheet" href="assets/css/jquery.mCustomScrollbar.min.css" /> <link rel="stylesheet" href="assets/css/slick.css" /> <link rel="stylesheet" href="assets/css/rs6.css" /> <link rel="stylesheet" href="assets/css/slick-theme.css" /> <link rel="stylesheet" href="assets/css/style.css" /> <style> .pagination .page-item .page-link { color: green; border-color: green; } .pagination .page-item .page-link:hover { background-color: green; color: white; } .pagination .page-item.active .page-link { background-color: green; color: white; } </style> </head> <body> <div class="up"> <a href="#" class="scrollup text-center"><i class="fas fa-chevron-up"></i></a> </div> <!-- Start of header section ============================================= --> <?php include "./hearder-2.php" ?> <!-- End of header section ============================================= --> <!-- Start of Breadcrumb section ============================================= --> <section id="ft-breadcrumb" class="ft-breadcrumb-section position-relative" data-background="assets/img/bg/bread-bg.jpg"> <span class="background_overlay"></span> <span class="design-shape position-absolute"><img src="assets/img/shape/tmd-sh.png" alt="" /></span> <div class="container"> <div class="ft-breadcrumb-content headline text-center position-relative"> <h2>Project</h2> <div class="ft-breadcrumb-list ul-li"> <ul> <li><a href="index.html">Home</a></li> <li>Activities</li> </ul> </div> </div> </div> </section> <!-- End of Breadcrumb section ============================================= --> <!-- Start of Project section ============================================= --> <section id="ft-project-page" class="ft-project-page-section page-padding"> <div class="container"> <div class="ft-section-title-2 headline pera-content text-center"> <span class="sub-title">Project</span> <h2>Let's Checkout our All Top Ratted Latest Project</h2> </div> <div class="ft-project-post-item-content"> <?php // Query to fetch unique categories from the database $sql_categories = "SELECT DISTINCT category FROM project"; $result_categories = $conn->query($sql_categories); if ($result_categories->num_rows > 0) { echo '<div class="ft-project-item-filter-btn ul-li">'; echo '<ul id="filters" class="nav-gallery text-center">'; echo '<li class="filtr-button filtr-active" data-filter="All" id="filter-all">All</li>'; while ($row_category = $result_categories->fetch_assoc()) { echo '<li class="filtr-button" data-filter="' . $row_category["category"] . '" id="filter-' . $row_category["category"] . '">' . $row_category["category"] . '</li>'; } echo '</ul>'; echo '</div>'; } else { echo "No categories found"; } // Pagination $limit = 6; // Number of projects per page $page = isset($_GET['page']) ? $_GET['page'] : 1; $start = ($page - 1) * $limit; // Determine the category to focus on $category = isset($_GET['category']) ? $_GET['category'] : 'All'; $category_filter = ($category != 'All') ? "WHERE category = '$category'" : ""; // Query to fetch data from the database with pagination and category filter $sql_projects = "SELECT project_id, image, category, type_of_product, description FROM project $category_filter LIMIT $start, $limit"; $result_projects = $conn->query($sql_projects); if ($result_projects->num_rows > 0) { echo '<div class="ft-project-item-wrapper filtr-container row">'; // Output data of each row while ($row_project = $result_projects->fetch_assoc()) { echo '<div class="col-lg-4 col-sm-6 filtr-item" data-category="' . $row_project["category"] . '" data-sort="Busy streets">'; echo '<div class="ft-portfolio-slider-innerbox position-relative">'; echo '<div class="ft-portfolio-img">'; echo '<img src="./dnl_dashboard/Project/' . $row_project["image"] . '" alt="" />'; echo '</div>'; echo '<div class="ft-portfolio-text headline headline pera-content" style="top: 280px;">'; echo '<h3><a href="#">' . $row_project["category"] . '</a></h3>'; echo '<p>' . $row_project["description"] . '</p>'; // If you have a link field in your database, you can uncomment the following line // echo '<div class="ft-btn-3"><a class="d-flex justify-content-center align-items-center" href="' . $row_project["link"] . '">Read More <i class="flaticon-right-arrow"></i></a></div>'; echo '</div>'; echo '</div>'; echo '</div>'; } echo '</div>'; // Pagination links $sql_total_projects = "SELECT COUNT(project_id) AS total FROM project $category_filter"; $result_total_projects = $conn->query($sql_total_projects); $row_total_projects = $result_total_projects->fetch_assoc(); $total_pages = ceil($row_total_projects["total"] / $limit); echo '<ul class="pagination justify-content-center">'; if ($page > 1) { echo '<li class="page-item"><a class="page-link" href="?page=' . ($page - 1) . '&category=' . $category . '">Previous</a></li>'; } for ($i = 1; $i <= $total_pages; $i++) { echo '<li class="page-item ' . ($page == $i ? 'active' : '') . '"><a class="page-link" href="?page=' . $i . '&category=' . $category . '">' . $i . '</a></li>'; } if ($page < $total_pages) { echo '<li class="page-item"><a class="page-link" href="?page=' . ($page + 1) . '&category=' . $category . '">Next</a></li>'; } echo '</ul>'; } else { echo "No projects found"; } $conn->close(); ?> </div> <!-- <div class="ft-btn text-center"> <a class="d-flex justify-content-center align-items-center" href="#">Load More</a> </div> --> </div> </div> </section> <script> document.addEventListener('DOMContentLoaded', function() { var filters = document.querySelectorAll('#filters .filtr-button'); filters.forEach(function(filter) { filter.addEventListener('click', function() { var category = this.getAttribute('data-filter'); filterProjects(category); }); }); function filterProjects(category) { var projects = document.querySelectorAll('.ft-project-item-wrapper .filtr-item'); projects.forEach(function(project) { if (category === 'All' || project.getAttribute('data-category') === category) { project.style.display = 'block'; } else { project.style.display = 'none'; } }); } }); var filterButtons = document.querySelectorAll('.filtr-button'); // Loop through each button and add click event listener filterButtons.forEach(function(button) { button.addEventListener('click', function() { // Remove active class from all buttons filterButtons.forEach(function(btn) { btn.classList.remove('filtr-active'); }); // Add active class to the clicked button this.classList.add('filtr-active'); }); }); </script> <!-- End of Project section ============================================= --> <!-- Start of Footer section ============================================= --> <footer id="ft-footer-2" class="ft-footer-section-2" data-background="assets/img/bg/f-bg.png"> <div class="ft-footer-widget-wrapper-2 p-5"> <div class="container"> <div class="row"> <div class="col-lg-3 col-md-6"> <div class="ft-footer-widget ul-li-block headline pera-content"> <div class="logo-widget"> <div class="site-logo"> <a href="#"><img src="assets/img/logo/dnl01-1@2x.png" alt="" /></a> </div> <div class="ft-footer-address"> <!-- <span>DNL Logistics #133, Street 178, Phnom Penh, Cambodia</span> --> <span> www.dnl.com.kh</span> <span>Email: info@dnlglobe.com</span> <span>Phone:+855 23 885 335 </span> </div> </div> </div> </div> <div class="col-lg-3 col-md-6"> <div class="ft-footer-widget ul-li-block headline pera-content"> <div class="menu-widget"> <h3 class="widget-title">Our Services</h3> <ul> <li><a href="#">Potential dry port and SEZ investment </a></li> <li><a href="#">Domestic Transportation</a></li> <li><a href="#">International Freight Sea, Land, Air </a></li> <li><a href="#">Application of C/O, form D & E</a></li> <li><a href="#">Application of QIP (Application CDC)</a></li> <li><a href="#">Import & Export Customs formalities</a></li> <li><a href="#">Project Working </a></li> </ul> </div> </div> </div> <div class="col-lg-3 col-md-6"> <div class="ft-footer-widget ul-li-block headline pera-content"> <div class="menu-widget"> <h3 class="widget-title">Quick Links</h3> <ul> <li><a href="index.php">Home</a></li> <li><a href="about.php">About us</a></li> <li><a href="#">Company History</a></li> <li><a href="#">Company Events</a></li> <li><a href="activities.php">Supply Chain Managment</a></li> <li><a href="#">Gallery</a></li> </ul> </div> </div> </div> <div class="col-lg-3 col-md-6"> <div class="ft-footer-widget ul-li-block headline pera-content"> <iframe src="https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2Fdynamicnetworklogisticscoltd&tabs=timeline&width=340&height=500&small_header=true&adapt_container_width=false&hide_cover=false&show_facepile=false&appId=697689201745453" width="340" height="300" style="border:none;overflow:hidden" scrolling="no" frameborder="0" allowfullscreen="true" allow="autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share"></iframe> </div> </div> </div> </div> </div> <div class="ft-footer-copywrite-2 text-center"> <span>Copyright @ 2024 DNL Dynamic Network Logistics.All Rights Reserved</span> </div> </footer> <!-- End of FAQ why choose section ============================================= --> <!-- For Js Library --> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/bootstrap.min.js"></script> <script src="assets/js/popper.min.js"></script> <script src="assets/js/jquery.magnific-popup.min.js"></script> <script src="assets/js/appear.js"></script> <script src="assets/js/slick.js"></script> <script src="assets/js/jquery.counterup.min.js"></script> <script src="assets/js/waypoints.min.js"></script> <script src="assets/js/jquery.nice-select.min.js"></script> <script src="assets/js/jquery.mCustomScrollbar.concat.min.js"></script> <script src="assets/js/wow.min.js"></script> <script src="assets/js/imagesloaded.pkgd.min.js"></script> <script src="assets/js/jquery.filterizr.js"></script> <script src="assets/js/rbtools.min.js"></script> <script src="assets/js/jquery.cssslider.min.js"></script> <script src="assets/js/rs6.min.js"></script> <script src="assets/js/knob.js"></script> <script src="assets/js/script.js"></script> <script src="assets/js/gmaps.min.js"></script> <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyDk2HrmqE4sWSei0XdKGbOMOHN3Mm2Bf-M&ver=2.1.6"></script> </body> </html>