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/www/Khmer/ |
<?php // Start or resume the session session_start(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>មាតិកា</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" /> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.0/css/all.min.css" rel="stylesheet"> <style> .truncate-text { max-height: 5em; /* Adjust the value as needed for 5 lines */ overflow: hidden; text-overflow: ellipsis; white-space: nowrap; } .zoom-effect { transition: transform 0.5s; transition: transform 0.5s, box-shadow 0.5s; } .zoom-effect:hover { transform: scale(1.02); box-shadow: 0 0 20px rgba(0, 255, 0, 0.5); /* Green shadow when hovering */ } </style> </head> <body> <!-- <div id="preloader"></div> --> <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>ព័ត៌មាន</h2> <div class="ft-breadcrumb-list ul-li"> <ul> <li><a href="index.php">ទំព័រដើម</a></li> <li>Airport</li> </ul> </div> </div> </div> </section> <!-- End of Breadcrumb section ============================================= --> <!-- Start of blog post feed section ============================================= --> <section id="ft-blog-post-feed" class="ft-blog-post-feed-section page-padding"> <div class="container"> <div class="row"> <div class="col-lg-9"> <div class="ft-blog-post-feed-content"> <div class="row"> <?php include 'db_con.php'; $tag = isset($_GET['tag']) ? $_GET['tag'] : null; $postsPerPage = 5; $page = isset($_GET['page']) ? $_GET['page'] : 1; $offset = ($page - 1) * $postsPerPage; if ($tag) { // Fetch total number of posts with the selected tag for pagination $sqlTotal = "SELECT COUNT(id) AS total FROM posts WHERE tag = '$tag'"; $resultTotal = $conn->query($sqlTotal); $rowTotal = $resultTotal->fetch_assoc(); $totalPosts = $rowTotal['total']; $totalPages = ceil($totalPosts / $postsPerPage); // Fetch posts with the selected tag for the current page $sql = "SELECT id, title, content, date, posted_by, tag, image FROM posts WHERE tag = '$tag' ORDER BY date DESC, id DESC LIMIT $offset, $postsPerPage"; $result = $conn->query($sql); if ($result->num_rows > 0) { $count = 0; // Initialize post count while ($row = $result->fetch_assoc()) { if ($count % 2 == 0) { // Start a new row for every second post echo '<div class="row">'; } // Display post content echo '<div class="col-md-6">'; echo '<div class="ft-blog-post-feed-innerbox">'; echo '<a href="blog-single.php?id=' . $row["id"] . '">'; echo '<div class="ft-blog-post-feed-img">'; echo '<img class="zoom-effect" src="../dnl_dashboard/' . $row["image"] . '" alt="" />'; echo '</div>'; echo '</a>'; echo '<div class="ft-blog-post-feed-text-wrapper headline pera-content">'; echo '<div class="blog-meta">'; echo '<a href="#"><i class="fas fa-user"></i> ' . $row["posted_by"] . '</a>'; echo '<a href="#"><i class="far fa-clock"></i> ' . $row["date"] . '</a>'; echo '<a href="#"><i class="fas fa-tag"></i> ' . $row["tag"] . '</a>'; echo '</div>'; echo '<div class="ft-blog-feed-title-text">'; echo '<h3>'; $title = $row["title"]; // Limit the title to 100 characters $title = (mb_strlen($title, 'UTF-8') > 50) ? mb_substr($title, 0, 50, 'UTF-8') . '...' : $title; $content = $row["content"]; // Limit the content to 500 characters $content = (mb_strlen($content, 'UTF-8') > 150) ? mb_substr($content, 0, 150, 'UTF-8') . '...' : $content; echo '<h3><a href="blog-single.php?id=' . $row["id"] . '">' . $title . '</a></h3>'; echo '<p>' . $content . '</p>'; echo '</p>'; echo '</div>'; echo '</div>'; echo '</div>'; echo '</div>'; if ($count % 2 != 0 || $count == $result->num_rows - 1) { // Close the row after the second post or if it's the last post echo '</div>'; } $count++; } // Pagination links echo '<div class="pagination">'; if ($page > 1) { echo '<a href="?page=' . ($page - 1) . '" class="page" style="color: white;">Previous</a>'; } if ($totalPages > 2) { for ($i = 1; $i <= $totalPages; $i++) { if ($i == $page) { echo '<a href="?page=' . $i . '" class="page current-page" style="background-color: red; color: white;">' . $i . '</a>'; } else { echo '<a href="?page=' . $i . '" class="page" style="color: white;">' . $i . '</a>'; } } } if ($page < $totalPages) { echo '<a href="?page=' . ($page + 1) . '" class="page" style="color: white;">Next</a>'; } echo '</div>'; } else { // No posts found with the selected tag echo '<p>No posts found with the selected tag.</p>'; } } else { // No tag selected echo '<p>No tag selected.</p>'; } $conn->close(); ?> </div> </div> </div> <div class="col-lg-3"> <div class="ft-side-bar-wrapper top-stikcy"> <div class="ft-side-bar-widget-area"> <?php include 'db_con.php'; // SQL query to get the count of posts for each tag $sql = "SELECT tag, COUNT(*) AS count FROM posts GROUP BY tag"; $result = $conn->query($sql); // Initialize an empty array for tag counts $tagCounts = []; // Check if there are any results if ($result->num_rows > 0) { // Loop through the results and store the tag counts in the array while ($row = $result->fetch_assoc()) { $tagCounts[$row['tag']] = $row['count']; } } // Close the database connection $conn->close(); ?> <div class="ft-side-bar-widget headline ul-li-block"> <div class="category-widget"> <h3 class="widget-title position-relative">Categories</h3> <ul> <?php // Sort the $tagCounts array by count in descending order arsort($tagCounts); // Get the top three categories $topCategories = array_slice($tagCounts, 0, 3, true); // Display the top three categories foreach ($topCategories as $tag => $count) { echo '<li>'; echo '<a href="tag?tag=' . urlencode($tag) . '">' . htmlspecialchars($tag) . ' <span>' . $count . '</span></a>'; echo '</li>'; } ?> </ul> </div> </div> <div class="ft-side-bar-widget headline ul-li-block"> <div class="recent-news-widget"> <h3 class="widget-title position-relative">ព័ត៌មានថ្មីៗ</h3> <?php // Include your database configuration file include 'db_con.php'; // SQL query to select recent news $sql = "SELECT id, title, image, date FROM posts ORDER BY date DESC LIMIT 3"; $result = $conn->query($sql); // Check if there are any results if ($result->num_rows > 0) { // Loop through the results and output the HTML markup while ($row = $result->fetch_assoc()) { $title = $row["title"]; // Limit the title to 100 characters $title = (mb_strlen($title, 'UTF-8') > 40) ? mb_substr($title, 0, 40, 'UTF-8') . '...' : $title; echo '<div class="recent-blog-img-text clearfix">'; echo '<div class="recent-blog-img float-left">'; echo '<img src="../dnl_dashboard/' . $row["image"] . '" alt="" />'; echo '</div>'; echo '<div class="recent-blog-text headline">'; echo '<h3><a href="preview?id=' . $row["id"] . '">' . $title . '</a></h3>'; echo '<span><i class="far fa-calendar-alt"></i> ' . $row["date"] . '</span>'; echo '</div>'; echo '</div>'; } } else { echo "No recent news found."; } // Close the database connection ?> </div> </div> <div class="ft-side-bar-widget headline ul-li-block"> <div class="tag-widget"> <h3 class="widget-title position-relative">Archives</h3> <ul> <li><a href="tag.php?category=business">Business</a></li> <li><a href="tag.php?category=cargo">Cargo</a></li> <li><a href="tag.php?category=freight">Freight</a></li> <li><a href="tag.php?category=truck">Truck</a></li> <li><a href="tag.php?category=ship">Ship</a></li> </ul> </div> </div> </div> </div> </div> </div> </div> </section> <!-- End of blog post 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">សេវាកម្មរបស់យើងខ្ញុំ</h3> <ul> <li><a href="#">កំពង់ផែស្ងួតដែលមានសក្តានុពល </a></li> <li><a href="#">ការដឹកជញ្ជូនក្នុងស្រុក</a></li> <li><a href="#">ទំនិញអន្តរជាតិ សមុទ្រ ផ្លូវគោក ផ្លូវអាកាស</a></li> <li><a href="#">ពាក្យស្នើសុំ C/O ទម្រង់ D & E</a></li> <li><a href="#">កម្មវិធី QIP (កម្មវិធី CDC)</a></li> <li><a href="#">បែបបទគយនាំចូល និងនាំចេញ</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">តំណភ្ជាប់រហ័ស</h3> <ul> <li><a href="index.php">ទំព័រដើម</a></li> <li><a href="about.php">អំពីក្រុមហ៊ុន</a></li> <li><a href="#">ប្រវត្តិរបស់កម្ពុជា</a></li> <li><a href="#">ព្រឹត្តិការណ៍ផ្សេងៗ</a></li> <li><a href="activities.php"> ការគ្រប់គ្រងខ្សែសង្វាក់ផ្គត់ផ្គង់</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>រក្សាសិទ្ធ@2024 ដោយក្រុមហ៊ុន ដាយនែមិក ណេតវើក ឡូជីស្ទីក</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/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> <style> .ft-blog-post-feed-innerbox { max-width: 870px; margin-bottom: 40px; background-color: #f4f4f4; } </style>