Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: latest-updates.php

<section id="updates" class="py-4 px-4 bg-white relative overflow-hidden">
    <div class="container mx-auto">
        
        <div class="flex items-center justify-between mb-4">
            <div class="flex items-center">
                <h2 class="text-xl font-semibold text-secondary mr-3">Latest Updates</h2>
                <div class="h-4 w-px bg-gray-300 mx-2"></div>
            </div>
            <a href="updates.php" class="bg-primary text-white px-3 py-1.5 rounded-full font-medium text-xs shadow hover:shadow-md transition-all duration-300 hover:bg-green-600 inline-flex items-center group">
                View All
                <i class="fas fa-arrow-right ml-1 text-xs group-hover:translate-x-0.5 transition-transform duration-300"></i>
            </a>
        </div>
        
        
        <div class="relative">
            
            <div id="updatesSlider"
                class="flex overflow-x-auto snap-x snap-mandatory scroll-smooth no-scrollbar
                       justify-start md:justify-start
                       px-[calc(50%-140px)] md:px-0">

<?php
                // Include database connection
                require_once 'includes/db.php';
                
                // Fetch ALL published updates from database (removed date restriction)
                $query = "
                    SELECT id, title, content, update_type, featured_image, publish_date, created_at 
                    FROM updates 
                    WHERE status = 'published'
                    ORDER BY publish_date DESC, created_at DESC 
                    LIMIT 6
                ";
                
                $result = mysqli_query($conn, $query);
                
                if (!$result) {
                    echo '<div class="text-center text-red-500 py-8 w-full">Error loading updates. Please try again later.</div>';
                    error_log("Database error: " . mysqli_error($conn));
                } elseif (mysqli_num_rows($result) == 0) {
                    echo '<div class="text-center text-neutral py-8 w-full">No updates available at the moment.</div>';
                } else {
                    while ($update = mysqli_fetch_assoc($result)) {
                        // Format date
                        $publishDate = date('M j, Y', strtotime($update['publish_date']));
                        
                        // Get appropriate icon based on update type
                        $icon = getUpdateTypeIcon($update['update_type']);
                        
                        // Truncate content for preview
                        $contentPreview = truncateContent($update['content'], 100);
                        
                        // Generate slug for read more link
                        $slug = generateSlug($update['title']);
                        
                        echo '
                        <div class="card flex-shrink-0 w-[260px] md:w-[300px] lg:w-[320px]
                                    bg-white rounded-lg p-3 transition-all duration-300 group snap-center">
                            <div class="flex items-center mb-1">
                                <div class="w-6 h-6 rounded-full bg-highlight flex items-center justify-center mr-2">
                                    <i class="' . $icon . ' text-primary text-xs"></i>
                                </div>
                                <span class="text-xs text-neutral">' . htmlspecialchars($publishDate) . '</span>
                            </div>
                            <h3 class="text-sm font-semibold text-dark mb-1 group-hover:text-primary transition-colors">' . htmlspecialchars($update['title']) . '</h3>
                            <p class="text-neutral text-xs mb-1 leading-tight">' . htmlspecialchars($contentPreview) . '</p>
                            <a href="update-details.php?id=' . $update['id'] . '&slug=' . $slug . '" class="text-primary text-xs font-medium flex items-center group-hover:underline">
                                Read More <i class="fas fa-arrow-right ml-1 text-xs group-hover:translate-x-0.5 transition-transform"></i>
                            </a>
                        </div>';
                    }
                    // Free result set
                    mysqli_free_result($result);
                }

</div>

<button id="updatesPrevSlide"
                class="hidden md:block absolute left-2 top-1/2 -translate-y-1/2 bg-white border border-light p-1.5 rounded-full shadow hover:bg-primary hover:text-white transition-all z-10">
                <i class="fas fa-chevron-left text-xs"></i>
            </button>
            <button id="updatesNextSlide"
                class="hidden md:block absolute right-2 top-1/2 -translate-y-1/2 bg-white border border-light p-1.5 rounded-full shadow hover:bg-primary hover:text-white transition-all z-10">
                <i class="fas fa-chevron-right text-xs"></i>
            </button>
        </div>
    </div>

<script>
        const updatesSlider = document.getElementById('updatesSlider');
        const updatesNextBtn = document.getElementById('updatesNextSlide');
        const updatesPrevBtn = document.getElementById('updatesPrevSlide');
        
        // Only initialize slider if there are updates
        if (updatesSlider && updatesSlider.children.length > 0) {
            const updatesCard = updatesSlider.querySelector('.card');
            const updatesCardW = updatesCard ? updatesCard.offsetWidth : 260;
            const updatesScrollAmount = updatesCardW + 16; // + gap (1rem)
            let updatesAutoSlide;

// Check if buttons exist before adding event listeners
            if (updatesNextBtn) {
                updatesNextBtn.addEventListener('click', () => updatesSlider.scrollBy({ left: updatesScrollAmount, behavior: 'smooth' }));
            }
            
            if (updatesPrevBtn) {
                updatesPrevBtn.addEventListener('click', () => updatesSlider.scrollBy({ left: -updatesScrollAmount, behavior: 'smooth' }));
            }

updatesSlider.addEventListener('mouseenter', stopUpdatesAutoSlide);
            updatesSlider.addEventListener('mouseleave', startUpdatesAutoSlide);

startUpdatesAutoSlide();
            centerFirstUpdateOnMobile();
            window.addEventListener('resize', centerFirstUpdateOnMobile);
        }
    </script>

<style>
        .no-scrollbar::-webkit-scrollbar { display: none; }
        .no-scrollbar { -ms-overflow-style: none; scrollbar-width: none; }

#updatesSlider { gap: 1rem; }

@media (max-width: 768px) {
            #updatesSlider { padding-left: calc(50% - 130px); padding-right: calc(50% - 130px); }
        }
        @media (min-width: 769px) {
            #updatesSlider { padding-left: 0; padding-right: 0; }
        }
    </style>
</section>

<?php
// Helper functions
function getUpdateTypeIcon($type) {
    $icons = [
        'announcement' => 'fas fa-bullhorn',
        'event' => 'fas fa-calendar-alt',
        'news' => 'fas fa-newspaper',
        'maintenance' => 'fas fa-tools',
        'alert' => 'fas fa-exclamation-triangle',
        'community' => 'fas fa-users'
    ];
    
    return $icons[$type] ?? 'fas fa-info-circle';
}

function truncateContent($content, $length = 100) {
    $content = strip_tags($content);
    if (strlen($content) <= $length) {
        return $content;
    }
    return substr($content, 0, $length) . '...';
}

function generateSlug($title) {
    $slug = strtolower(trim($title));
    $slug = preg_replace('/[^a-z0-9-]/', '-', $slug);
    $slug = preg_replace('/-+/', '-', $slug);
    return $slug;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: latest-updates.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation