Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

nginx/1.28.0

System:

Linux 6.8.0-90-generic

PHP Version:

8.4.15

User:

alqudsvolunteers

Directory:

/home/avi/htdocs/www.alqudsvolunteers.id

Free Space:

81.68 GB

🔧 Quick Actions

✏️ Editing: publication1.php

<?php
// Koneksi ke database
$host = "localhost";
$user = "alquds";
$password = "wZTGncNrXalGa8xuIIB6";
$database = "alquds";

$conn = mysqli_connect($host, $user, $password, $database);

if (!$conn) {
    die("Koneksi database gagal: " . mysqli_connect_error());
}

// Query untuk mengambil semua publication group untuk filter
$group_query = "SELECT * FROM publication_group ORDER BY name_group";
$group_result = mysqli_query($conn, $group_query);

// Mendapatkan parameter filter
$selected_group = isset($_GET['group']) ? $_GET['group'] : '';
$search_query = isset($_GET['search']) ? $_GET['search'] : '';

// Query untuk mengambil data publication dengan filter
$publication_query = "SELECT p.*, pg.name_group FROM publication p 
                     LEFT JOIN publication_group pg ON p.id_group = pg.id 
                     WHERE 1=1";

if (!empty($selected_group)) {
    $publication_query .= " AND p.id_group = $selected_group";
}

if (!empty($search_query)) {
    $publication_query .= " AND (p.title LIKE '%$search_query%' OR p.isi LIKE '%$search_query%')";
}

$publication_query .= " ORDER BY p.published_at DESC";

$publication_result = mysqli_query($conn, $publication_query);
$publications = mysqli_fetch_all($publication_result, MYSQLI_ASSOC);

// Query untuk mengambil semua publication untuk sidebar
$sidebar_query = "SELECT p.*, pg.name_group FROM publication p 
                 LEFT JOIN publication_group pg ON p.id_group = pg.id 
                 ORDER BY p.published_at DESC LIMIT 5";
$sidebar_result = mysqli_query($conn, $sidebar_query);
$sidebar_publications = mysqli_fetch_all($sidebar_result, MYSQLI_ASSOC);
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <title>Al-Quds Volunteers Indonesia</title>
   <link rel="icon" href="icon_avi.png" type="image/png">
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        .publication-card {
            transition: all 0.3s ease;
        }
        .publication-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 10px 25px -5px rgba(0, 0, 0, 0.1);
        }
        .category-filter {
            transition: all 0.2s ease;
        }
        .category-filter.active {
            background-color: #3B82F6;
            color: white;
        }
    </style>
</head>
<body class="bg-gray-50 font-sans">
    <?php include 'navbar.php'?>

<section class="bg-primary text-white py-16">
        <div class="container mx-auto px-4 text-center">
            <h1 class="text-4xl md:text-5xl font-bold mb-4">Berita & Kegiatan</h1>
            <p class="text-xl">Ikuti perkembangan terbaru dari kegiatan dan program kami</p>
        </div>
    </section>

<section class="py-12">
        <div class="container mx-auto px-4">
            <div class="flex flex-col lg:flex-row gap-8">
                
                <div class="lg:w-3/4">
                    
                    <div class="bg-white rounded-lg shadow-md p-6 mb-8">
                        <h2 class="text-xl font-bold mb-4">Filter Berita</h2>
                        <form method="GET" action="publication.php" class="flex flex-col md:flex-row gap-4">
                            <div class="flex-grow">
                                <input type="text" name="search" placeholder="Cari berita atau kegiatan..." 
                                       value="<?php echo htmlspecialchars($search_query); ?>"
                                       class="w-full px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-primary">
                            </div>
                            <div class="w-full md:w-64">
                                <select name="group" class="w-full px-4 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-primary">
                                    <option value="">Semua Kategori</option>
                                    <?php while ($group = mysqli_fetch_assoc($group_result)): ?>
                                        <option value="<?php echo $group['id']; ?>" 
                                                <?php echo ($selected_group == $group['id']) ? 'selected' : ''; ?>>
                                            <?php echo htmlspecialchars($group['name_group']); ?>
                                        </option>
                                    <?php endwhile; ?>
                                </select>
                            </div>
                            <button type="submit" class="bg-primary text-white px-6 py-2 rounded-lg font-semibold hover:bg-blue-600 transition-colors">
                                Filter
                            </button>
                            <?php if (!empty($selected_group) || !empty($search_query)): ?>
                                <a href="publication.php" class="bg-gray-200 text-gray-800 px-6 py-2 rounded-lg font-semibold hover:bg-gray-300 transition-colors flex items-center">
                                    Reset
                                </a>
                            <?php endif; ?>
                        </form>
                    </div>

<?php if (count($publications) > 0): ?>
                        <div class="grid grid-cols-1 md:grid-cols-2 gap-6">
                            <?php foreach ($publications as $publication): ?>
                                <div class="bg-white rounded-xl shadow-md overflow-hidden publication-card">
                                    <div class="h-48 bg-gray-200 overflow-hidden">
                                        <?php
                                        // Query untuk mengambil foto publication
                                        $photo_query = "SELECT * FROM publication_photo WHERE id_publication = {$publication['id']} ORDER BY urutan LIMIT 1";
                                        $photo_result = mysqli_query($conn, $photo_query);
                                        $photo = mysqli_fetch_assoc($photo_result);
                                        
                                        if ($photo) {
                                            $image_url = "uploads/publications/" . $photo['foto'];
                                        } else {
                                            $image_url = "https://images.unsplash.com/photo-1516321318423-f06f85e504b3?ixlib=rb-4.0.3&ixid=MnwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8&auto=format&fit=crop&w=600&q=80";
                                        }
                                        ?>
                                        <img src="<?php echo $image_url; ?>" alt="<?php echo htmlspecialchars($publication['title']); ?>" class="w-full h-full object-cover transition-transform duration-500 hover:scale-105">
                                    </div>
                                    <div class="p-6">
                                        <span class="text-sm text-primary font-semibold"><?php echo htmlspecialchars($publication['name_group']); ?></span>
                                        <h3 class="text-xl font-bold text-dark mt-2 mb-3"><?php echo htmlspecialchars($publication['title']); ?></h3>
                                        <p class="text-gray-600 mb-4">
                                            <?php 
                                            $content = strip_tags($publication['isi']);
                                            echo strlen($content) > 120 ? substr($content, 0, 120) . '...' : $content;
                                            ?>
                                        </p>
                                        <div class="flex justify-between items-center">
                                            <span class="text-sm text-gray-500"><?php echo date('d M Y', strtotime($publication['published_at'])); ?></span>
                                            <div class="flex items-center">
                                                <i class="far fa-heart text-gray-500 mr-1"></i>
                                                <span class="text-gray-500"><?php echo $publication['likes']; ?></span>
                                            </div>
                                        </div>
                                        <a href="publication-detail.php?id=<?php echo $publication['id']; ?>" class="inline-block mt-4 text-primary font-semibold hover:underline">
                                            Baca Selengkapnya <i class="fas fa-arrow-right ml-2"></i>
                                        </a>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                        </div>

<div class="mt-8 flex justify-center">
                            <div class="flex space-x-2">
                                <a href="#" class="px-4 py-2 bg-primary text-white rounded-lg">1</a>
                                <a href="#" class="px-4 py-2 bg-gray-200 text-gray-800 rounded-lg hover:bg-gray-300">2</a>
                                <a href="#" class="px-4 py-2 bg-gray-200 text-gray-800 rounded-lg hover:bg-gray-300">3</a>
                                <a href="#" class="px-4 py-2 bg-gray-200 text-gray-800 rounded-lg hover:bg-gray-300">Next</a>
                            </div>
                        </div>
                    <?php else: ?>
                        <div class="bg-white rounded-xl shadow-md p-8 text-center">
                            <i class="fas fa-newspaper text-4xl text-gray-400 mb-4"></i>
                            <h3 class="text-xl font-bold text-gray-600 mb-2">Tidak ada berita ditemukan</h3>
                            <p class="text-gray-500">Coba gunakan kata kunci atau filter yang berbeda.</p>
                        </div>
                    <?php endif; ?>
                </div>

<div class="lg:w-1/4">
                    
                    <div class="bg-white rounded-xl shadow-md p-6 mb-6">
                        <h3 class="text-xl font-bold mb-4">Kategori Berita</h3>
                        <ul class="space-y-2">
                            <li>
                                <a href="publication.php" class="flex justify-between items-center category-filter <?php echo empty($selected_group) ? 'active' : ''; ?> px-3 py-2 rounded-lg">
                                    <span>Semua Kategori</span>
                                    <span class="bg-gray-200 text-gray-800 text-xs px-2 py-1 rounded-full">
                                        <?php
                                        $count_query = "SELECT COUNT(*) as total FROM publication";
                                        $count_result = mysqli_query($conn, $count_query);
                                        $count = mysqli_fetch_assoc($count_result);
                                        echo $count['total'];
                                        ?>
                                    </span>
                                </a>
                            </li>
                            <?php
                            // Query ulang untuk kategori
                            $group_query_sidebar = "SELECT pg.*, COUNT(p.id) as count 
                                                  FROM publication_group pg 
                                                  LEFT JOIN publication p ON pg.id = p.id_group 
                                                  GROUP BY pg.id 
                                                  ORDER BY pg.name_group";
                            $group_result_sidebar = mysqli_query($conn, $group_query_sidebar);
                            while ($group = mysqli_fetch_assoc($group_result_sidebar)): ?>
                                <li>
                                    <a href="publication.php?group=<?php echo $group['id']; ?>" 
                                       class="flex justify-between items-center category-filter <?php echo ($selected_group == $group['id']) ? 'active' : ''; ?> px-3 py-2 rounded-lg">
                                        <span><?php echo htmlspecialchars($group['name_group']); ?></span>
                                        <span class="bg-gray-200 text-gray-800 text-xs px-2 py-1 rounded-full"><?php echo $group['count']; ?></span>
                                    </a>
                                </li>
                            <?php endwhile; ?>
                        </ul>
                    </div>

<div class="bg-white rounded-xl shadow-md p-6">
                        <h3 class="text-xl font-bold mb-4">Berita Terbaru</h3>
                        <div class="space-y-4">
                            <?php foreach ($sidebar_publications as $pub): ?>
                                <div class="flex items-start">
                                    <div class="flex-shrink-0 w-16 h-16 bg-gray-200 rounded-lg overflow-hidden mr-3">
                                        <?php
                                        // Query untuk mengambil foto publication
                                        $photo_query = "SELECT * FROM publication_photo WHERE id_publication = {$pub['id']} ORDER BY urutan LIMIT 1";
                                        $photo_result = mysqli_query($conn, $photo_query);
                                        $photo = mysqli_fetch_assoc($photo_result);
                                        
                                        if ($photo) {
                                            $image_url = "uploads/publications/" . $photo['foto'];
                                        } else {
                                            $image_url = "https://images.unsplash.com/photo-1516321318423-f06f85e504b3?ixlib=rb-4.0.3&ixid=MnwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8&auto=format&fit=crop&w=600&q=80";
                                        }
                                        ?>
                                        <img src="<?php echo $image_url; ?>" alt="<?php echo htmlspecialchars($pub['title']); ?>" class="w-full h-full object-cover">
                                    </div>
                                    <div>
                                        <a href="publication-detail.php?id=<?php echo $pub['id']; ?>" class="font-semibold text-gray-800 hover:text-primary line-clamp-2">
                                            <?php echo htmlspecialchars($pub['title']); ?>
                                        </a>
                                        <p class="text-sm text-gray-500"><?php echo date('d M Y', strtotime($pub['published_at'])); ?></p>
                                    </div>
                                </div>
                            <?php endforeach; ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>

<?php include 'footer.php'?>
</body>
</html>
<?php
// Tutup koneksi database
mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: publication1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation