Root Explorer PHP

Editing: News-page.php

<?php
require_once('../php-backend/server.php');
$db = new server();
$ierp = $db->connect_sql();

$NewsData = [];
$whereClause = "";
$params = [];

if (isset($_GET['category']) && !empty($_GET['category'])) {
    $categoryFilter = urldecode($_GET['category']);
    $whereClause = "AND news_page_categories = ?";
    $params[] = $categoryFilter;
}

$sql = "SELECT * FROM news_page WHERE news_Act != 0 $whereClause   ORDER BY news_page_display ";

$stmt = $ierp->prepare($sql);

if (!empty($params)) {
    $stmt->bind_param("s", ...$params);  // bind category as string
}

$stmt->execute();
$result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
    $NewsData[] = $row;
}

<!DOCTYPE html>
<html lang="th-TH">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>
        Wichien Dynamic Industry </title>

</style>
</head>

<?php require '../nav-bar.php'; ?>

<div style="width: 100vw; overflow: hidden;">
        <img src="https://www.wdi.co.th/adminkit-dev/static/back-php/uploads/slides/frontpagewebsite1.jpg"
            style="width: 100%; height: 70%; object-fit: cover;" />
    </div>

<div class="container-news-page my-5">
        <div class="px-2">
            <div class="shortcut-name">NEWS</div>

<div class="categories-title">Categories</div>
                    <?php
                    $seenCategories = [];
                    ?>
                    <ul>
                        <?php foreach ($NewsData as $cat): ?>
                            <?php
                            $category = trim($cat['news_page_categories']);
                            if ($category && !in_array($category, $seenCategories)) {
                                $seenCategories[] = $category;
                                $encodedCategory = urlencode($category);
                            ?>
                                <li><a href="?category=<?= $encodedCategory ?>"><?= htmlspecialchars($category); ?></a></li>
                            <?php } ?>
                        <?php endforeach; ?>
                    </ul>

</div>

<div class="news-content-area">
    <?php foreach ($NewsData as $NewsD): ?>
        <?php
        $timestamp = strtotime($NewsD['date_post']);
        $day = date("d", $timestamp);
        $monthYear = date("m, Y", $timestamp);

// สร้างเนื้อหาสั้น
        $contentEn = htmlspecialchars_decode($NewsD['news_page_content_en']);
        $shortEn = mb_substr(strip_tags($contentEn), 0, 100, 'UTF-8');
        if (mb_strlen(strip_tags($contentEn), 'UTF-8') > 100) $shortEn .= '...';

$contentTh = htmlspecialchars_decode($NewsD['news_page_content_th']);
        $shortTh = mb_substr(strip_tags($contentTh), 0, 100, 'UTF-8');
        if (mb_strlen(strip_tags($contentTh), 'UTF-8') > 100) $shortTh .= '...';

$news_page_id_clean = trim($NewsD['news_page_id']);
        $encoded_news_page_id = rawurlencode(base64_encode($news_page_id_clean));
        ?>
        <div class="news-entry" 
             data-title-th="<?= strtolower($NewsD['news_page_title_th']); ?>" 
             data-title-en="<?= strtolower($NewsD['news_page_title_en']); ?>" 
             data-category="<?= strtolower($NewsD['news_page_categories']); ?>">

<?php if (!empty($NewsD['news_page_image'])): ?>
<div>
    <img src="../adminkit-dev/static/back-php/<?= htmlspecialchars($NewsD['news_page_image']); ?>" 
         alt="<?= htmlspecialchars($NewsD['news_page_title_th']); ?>" 
         class="news-img">
</div>
<?php endif; ?>

<div class="news-category">
                    <span class="category-th"><?= htmlspecialchars($NewsD['news_page_categories']); ?></span>
                    <span class="category-en" style="display:none;"><?= htmlspecialchars($NewsD['news_page_categories']); ?></span>
                </div>

<div class="news-content">
                    <span class="content-th"><?= $shortTh ?></span>
                    <span class="content-en" style="display:none;"><?= $shortEn ?></span>
                </div>

<a href="view-News-page.php?news_page_id=<?= $encoded_news_page_id ?>" 
                    class="btn btn-sm btn-outline-primary mt-2">

<span class="btn-th">อ่านเพิ่มเติม</span>
                        <span class="btn-en" style="display:none;">Read more</span>

</a>
            </div>
        </div>
    <?php endforeach; ?>
</div>
            </div>
        </div>
    </div>

<?php require '../footer-page.php'; ?>

$('.news-entry').each(function() {
                    const title = $(this).data('title');
                    const category = $(this).data('category');

if (title.includes(keyword) || category.includes(keyword)) {
                        $(this).show();
                    } else {
                        $(this).hide();
                    }
                });
            });
        });
    </script>
<script>
function switchLanguage(lang) {
    document.querySelectorAll('.news-entry').forEach(entry => {
        const titleEn = entry.querySelector('.title-en');
        const titleTh = entry.querySelector('.title-th');
        const contentEn = entry.querySelector('.content-en');
        const contentTh = entry.querySelector('.content-th');
        const categoryEn = entry.querySelector('.category-en');
        const categoryTh = entry.querySelector('.category-th');
        const btnTh = entry.querySelector('.btn-th');
        const btnEn = entry.querySelector('.btn-en');
        
        // Titles
        if (lang === 'en') {
            if (titleEn && titleEn.textContent.trim() !== '') {
                titleEn.style.display = 'inline';
                if (titleTh) titleTh.style.display = 'none';
            } else if (titleTh) {
                titleTh.style.display = 'inline';
                if (titleEn) titleEn.style.display = 'none';
            }
        } else {
            if (titleTh && titleTh.textContent.trim() !== '') {
                titleTh.style.display = 'inline';
                if (titleEn) titleEn.style.display = 'none';
            } else if (titleEn) {
                titleEn.style.display = 'inline';
                if (titleTh) titleTh.style.display = 'none';
            }
        }

// Content
        if (lang === 'en') {
            if (contentEn && contentEn.textContent.trim() !== '') {
                contentEn.style.display = 'inline';
                if (contentTh) contentTh.style.display = 'none';
            } else if (contentTh) {
                contentTh.style.display = 'inline';
                if (contentEn) contentEn.style.display = 'none';
            }
        } else {
            if (contentTh && contentTh.textContent.trim() !== '') {
                contentTh.style.display = 'inline';
                if (contentEn) contentEn.style.display = 'none';
            } else if (contentEn) {
                contentEn.style.display = 'inline';
                if (contentTh) contentTh.style.display = 'none';
            }
        }

// Category
        if (lang === 'en') {
            if (categoryEn && categoryEn.textContent.trim() !== '') {
                categoryEn.style.display = 'inline';
                if (categoryTh) categoryTh.style.display = 'none';
            } else if (categoryTh) {
                categoryTh.style.display = 'inline';
                if (categoryEn) categoryEn.style.display = 'none';
            }
        } else {
            if (categoryTh && categoryTh.textContent.trim() !== '') {
                categoryTh.style.display = 'inline';
                if (categoryEn) categoryEn.style.display = 'none';
            } else if (categoryEn) {
                categoryEn.style.display = 'inline';
                if (categoryTh) categoryTh.style.display = 'none';
            }
        }

// Button text
        if (lang === 'en') {
            if (btnEn) btnEn.style.display = 'inline';
            if (btnTh) btnTh.style.display = 'none';
        } else {
            if (btnTh) btnTh.style.display = 'inline';
            if (btnEn) btnEn.style.display = 'none';
        }
    });

// ซิงค์ปุ่ม active
    document.querySelector('.lang-en').classList.toggle('active', lang === 'en');
    document.querySelector('.lang-th').classList.toggle('active', lang === 'th');
}

// Event listeners
document.querySelector('.lang-en').addEventListener('click', e => {
    e.preventDefault();
    switchLanguage('en');
});

document.querySelector('.lang-th').addEventListener('click', e => {
    e.preventDefault();
    switchLanguage('th');
});

// ตรวจสอบตอนโหลดหน้า และปรับการแสดงผลตามปุ่ม active
document.addEventListener('DOMContentLoaded', () => {
    if (document.querySelector('.lang-en').classList.contains('active')) {
        switchLanguage('en');
    } else {
        switchLanguage('th');
    }
});
</script>

</body>

</html>

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📄 News-page.php	FILE	[EDIT]
📄 view-News-page.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: News-page.php