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" /> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <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 */ } /* CSS for two posts per row */ /* CSS for three rows with two posts each */ .ft-blog-post-feed-innerbox { display: flex; flex-wrap: wrap; justify-content: space-between; margin-bottom: 30px; /* Margin between rows, adjust as needed */ } .ft-blog-post-feed-box { width: calc(50% - 15px); /* 50% width with margin */ margin-bottom: 30px; background-color: #f4f4f4; border-radius: 5px solid gray; /* Margin between posts, adjust as needed */ } @media (max-width: 768px) { .ft-blog-post-feed-box { width: 100%; /* Full width on smaller screens */ } } .pagination { display: flex; justify-content: center; margin-top: 20px; } .page { padding: 5px 10px; margin: 0 2px; border: 1px solid #ddd; color: white; /* Change text color to white */ text-decoration: none; border-radius: 3px; background-color: #00570e; } .page:hover { background-color: #0d941a; color: #f4f4f4; } .current { padding: 5px 10px; margin: 0 2px; border: 1px solid #333; background-color: #333; color: white; /* Change text color to white */ border-radius: 3px; } .ellipsis { margin: 0 5px; color: #333; } </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>ព័ត៌មានថ្មីៗ</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-side-bar-widget search-widget-area headline ul-li-block"> <div class="search-widget position-relative"> <input type="text" id="searchInput" placeholder="Search." /> </div> </div> <div id="searchResults"></div> <script> // Function to fetch search results function fetchSearchResults(query) { $.ajax({ url: 'search.php', type: 'GET', data: { search: query }, success: function(response) { $('#searchResults').html(response); } }); } // Trigger search on keyup event $('#searchInput').on('keyup', function() { var query = $(this).val(); if (query.length > 0) { fetchSearchResults(query); } else { $('#searchResults').html(''); } }); </script> <div class="ft-blog-post-feed-content"> <?php include 'db_con.php'; // Pagination $postsPerPage = 6; // Displaying six posts per page (3 rows with 2 posts each) $page = isset($_GET['page']) ? $_GET['page'] : 1; $offset = ($page - 1) * $postsPerPage; // Count total number of posts $sqlTotalPosts = "SELECT COUNT(*) AS totalPosts FROM posts"; $resultTotalPosts = $conn->query($sqlTotalPosts); $rowTotalPosts = $resultTotalPosts->fetch_assoc(); $totalPosts = $rowTotalPosts['totalPosts']; // Calculate total number of pages $totalPages = ceil($totalPosts / $postsPerPage); // Order the posts by date in descending order and then by ID in descending order $sql = "SELECT id, title, content, date, posted_by, tag, image FROM posts ORDER BY date DESC, id DESC LIMIT $offset, $postsPerPage"; $result = $conn->query($sql); // Check if there are rows in the result if ($result->num_rows > 0) { for ($i = 0; $i < 3; $i++) { // Loop for three rows echo '<div class="ft-blog-post-feed-innerbox">'; // Start row container for ($j = 0; $j < 2; $j++) { // Two posts per row if ($row = $result->fetch_assoc()) { echo '<div class="ft-blog-post-feed-box">'; // Start post box echo '<a href="preview?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="tag?tag=' . $row["tag"] . '"><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="preview?id=' . $row["id"] . '">' . $title . '</a></h3>'; echo '<p>' . $content . '</p>'; echo '</p>'; echo '</div>'; echo '<div class="ft-btn-2">'; // echo '<a href="preview?id=' . $row["id"] . '">'; // echo '<i class="icon-first flaticon-right-arrow"></i>'; // echo '<span>Read More</span>'; echo '</a>'; echo '</div>'; echo '</div>'; echo '</div>'; // End post box } } echo '</div>'; // End row container } // 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>'; } // Close the database connection $conn->close(); ?> </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">Recent News</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="gallery-widget"> <h3 class="widget-title position-relative">Gallery</h3> <ul class="zoom-gallery"> <li> <a href="assets/img/gallery/gl1.jpg" data-source="assets/img/gallery/gl1.jpg" ><img src="assets/img/gallery/gl1.jpg" alt="" /></a> </li> <li> <a href="assets/img/gallery/gl2.jpg" data-source="assets/img/gallery/gl2.jpg" ><img src="assets/img/gallery/gl2.jpg" alt="" /></a> </li> <li> <a href="assets/img/gallery/gl3.jpg" data-source="assets/img/gallery/gl3.jpg" ><img src="assets/img/gallery/gl3.jpg" alt="" /></a> </li> <li> <a href="assets/img/gallery/gl4.jpg" data-source="assets/img/gallery/gl4.jpg" ><img src="assets/img/gallery/gl4.jpg" alt="" /></a> </li> <li> <a href="assets/img/gallery/gl5.jpg" data-source="assets/img/gallery/gl4.jpg" ><img src="assets/img/gallery/gl5.jpg" alt="" /></a> </li> <li> <a href="assets/img/gallery/gl6.jpg" data-source="assets/img/gallery/gl4.jpg" ><img src="assets/img/gallery/gl6.jpg" alt="" /></a> </li> </ul> </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 class="ft-side-bar-add headline ul-li-block"> <a href="contact.php"> <img src="assets/img/bg/add-bg.png" alt=""> </a> </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>