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

Free Space:

81.72 GB

🔧 Quick Actions

✏️ Editing: kelola_publikasi.php

<?php
// Enable error reporting untuk debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once 'config.php';
checkLogin();

$success = '';
$error = '';

// Create upload directories if they don't exist
$upload_pdf_dir = 'uploads/publikasi/';
$upload_thumb_dir = 'uploads/publikasi/thumbnails/';

// Create directories dengan error handling
try {
    if (!is_dir($upload_pdf_dir)) {
        if (!mkdir($upload_pdf_dir, 0755, true)) {
            throw new Exception("Gagal membuat folder upload PDF");
        }
    }
    
    if (!is_dir($upload_thumb_dir)) {
        if (!mkdir($upload_thumb_dir, 0755, true)) {
            throw new Exception("Gagal membuat folder upload thumbnail");
        }
    }
    
    // Check if directories are writable
    if (!is_writable($upload_pdf_dir)) {
        throw new Exception("Folder upload PDF tidak writable");
    }
    
    if (!is_writable($upload_thumb_dir)) {
        throw new Exception("Folder upload thumbnail tidak writable");
    }
} catch (Exception $e) {
    $error = $e->getMessage();
}

// Fungsi untuk kompres gambar
function compressImage($source, $destination, $quality = 75) {
    $info = getimagesize($source);
    
    if ($info['mime'] == 'image/jpeg') {
        $image = imagecreatefromjpeg($source);
        imagejpeg($image, $destination, $quality);
    } elseif ($info['mime'] == 'image/png') {
        $image = imagecreatefrompng($source);
        imagepng($image, $destination, 9); // PNG quality 0-9
    } elseif ($info['mime'] == 'image/gif') {
        $image = imagecreatefromgif($source);
        imagegif($image, $destination);
    } elseif ($info['mime'] == 'image/webp') {
        $image = imagecreatefromwebp($source);
        imagewebp($image, $destination, $quality);
    } else {
        return false;
    }
    
    return true;
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    try {
        if (isset($_POST['tambah'])) {
            // Validasi CSRF token
            if (!isset($_POST['csrf_token']) || $_POST['csrf_token'] !== $_SESSION['csrf_token']) {
                throw new Exception("Token keamanan tidak valid");
            }
            
            // Tambah publikasi baru
            if (empty($_POST['nama_publikasi'])) {
                throw new Exception("Nama publikasi harus diisi!");
            }
            
            $nama_publikasi = mysqli_real_escape_string($conn, $_POST['nama_publikasi']);
            $file_pdf_name = '';
            $thumbnail_name = '';
            
            // Handle file upload PDF
            if (!isset($_FILES['file_publikasi']) || $_FILES['file_publikasi']['error'] == UPLOAD_ERR_NO_FILE) {
                throw new Exception("File publikasi (PDF) harus diupload!");
            }
            
            $file_pdf = $_FILES['file_publikasi'];
            
            // Check upload error
            if ($file_pdf['error'] !== UPLOAD_ERR_OK) {
                $upload_errors = [
                    UPLOAD_ERR_INI_SIZE => "File PDF terlalu besar (melebihi batas server)",
                    UPLOAD_ERR_FORM_SIZE => "File PDF terlalu besar (melebihi batas form)",
                    UPLOAD_ERR_PARTIAL => "File PDF hanya terupload sebagian",
                    UPLOAD_ERR_NO_FILE => "Tidak ada file PDF yang diupload",
                    UPLOAD_ERR_NO_TMP_DIR => "Folder temporary tidak ada",
                    UPLOAD_ERR_CANT_WRITE => "Gagal menulis file PDF ke disk",
                    UPLOAD_ERR_EXTENSION => "Upload PDF dihentikan oleh ekstensi PHP"
                ];
                throw new Exception($upload_errors[$file_pdf['error']] ?? "Error upload PDF tidak diketahui (Code: {$file_pdf['error']})");
            }
            
            // Validate PDF file
            $file_pdf_ext = strtolower(pathinfo($file_pdf['name'], PATHINFO_EXTENSION));
            if ($file_pdf_ext !== 'pdf') {
                throw new Exception("Hanya file PDF yang diizinkan untuk publikasi!");
            }
            
            // Generate safe filename untuk PDF
            $file_pdf_name = uniqid() . '_' . preg_replace('/[^a-zA-Z0-9]/', '_', $nama_publikasi) . '.pdf';
            $upload_pdf_path = $upload_pdf_dir . $file_pdf_name;
            
            // Move uploaded PDF file - TANPA BATASAN UKURAN
            if (!move_uploaded_file($file_pdf['tmp_name'], $upload_pdf_path)) {
                throw new Exception("Gagal mengupload file PDF! Pastikan folder uploads memiliki permission yang tepat dan space yang cukup.");
            }
            
            // Handle thumbnail upload jika ada
            if (isset($_FILES['thumbnail']) && $_FILES['thumbnail']['error'] == UPLOAD_ERR_OK) {
                $file_thumb = $_FILES['thumbnail'];
                $file_thumb_ext = strtolower(pathinfo($file_thumb['name'], PATHINFO_EXTENSION));
                $allowed_ext = ['jpg', 'jpeg', 'png', 'gif', 'webp'];
                
                if (!in_array($file_thumb_ext, $allowed_ext)) {
                    throw new Exception("Format thumbnail tidak didukung! Gunakan JPG, JPEG, PNG, GIF, atau WebP.");
                }
                
                // Validate image
                $image_info = getimagesize($file_thumb['tmp_name']);
                if (!$image_info) {
                    throw new Exception("File thumbnail bukan gambar yang valid!");
                }
                
                $thumbnail_name = uniqid() . '_thumb_' . preg_replace('/[^a-zA-Z0-9]/', '_', $nama_publikasi) . '.' . $file_thumb_ext;
                $upload_thumb_path = $upload_thumb_dir . $thumbnail_name;
                
                // Kompres thumbnail sebelum disimpan
                if (!compressImage($file_thumb['tmp_name'], $upload_thumb_path, 75)) {
                    // Jika kompresi gagal, gunakan file asli
                    if (!move_uploaded_file($file_thumb['tmp_name'], $upload_thumb_path)) {
                        throw new Exception("Gagal mengupload thumbnail!");
                    }
                }
            }
            
            // Insert to database
            $thumbnail_value = $thumbnail_name ? "'$thumbnail_name'" : "NULL";
            $query = "INSERT INTO publikasi (nama_publikasi, file_publikasi, thumbnail) 
                     VALUES ('$nama_publikasi', '$file_pdf_name', $thumbnail_value)";
            
            if (!mysqli_query($conn, $query)) {
                throw new Exception("Gagal menambahkan publikasi ke database: " . mysqli_error($conn));
            }
            
            $success = "Publikasi berhasil ditambahkan!";
        }
        
        // Handle delete
        if (isset($_POST['hapus'])) {
            $id = mysqli_real_escape_string($conn, $_POST['id']);
            
            // Get file names first
            $query = "SELECT file_publikasi, thumbnail FROM publikasi WHERE id = '$id'";
            $result = mysqli_query($conn, $query);
            
            if (!$result || mysqli_num_rows($result) == 0) {
                throw new Exception("Publikasi tidak ditemukan!");
            }
            
            $row = mysqli_fetch_assoc($result);
            
            // Delete files
            $files_deleted = true;
            if ($row['file_publikasi'] && file_exists($upload_pdf_dir . $row['file_publikasi'])) {
                if (!unlink($upload_pdf_dir . $row['file_publikasi'])) {
                    $files_deleted = false;
                }
            }
            
            if ($row['thumbnail'] && file_exists($upload_thumb_dir . $row['thumbnail'])) {
                if (!unlink($upload_thumb_dir . $row['thumbnail'])) {
                    $files_deleted = false;
                }
            }
            
            if (!$files_deleted) {
                error_log("Warning: Gagal menghapus beberapa file untuk publikasi ID: $id");
            }
            
            // Delete from database
            $query = "DELETE FROM publikasi WHERE id = '$id'";
            if (!mysqli_query($conn, $query)) {
                throw new Exception("Gagal menghapus publikasi dari database: " . mysqli_error($conn));
            }
            
            $success = "Publikasi berhasil dihapus!";
        }
    } catch (Exception $e) {
        $error = $e->getMessage();
        
        // Cleanup uploaded files jika ada error setelah upload
        if (isset($file_pdf_name) && $file_pdf_name && file_exists($upload_pdf_dir . $file_pdf_name)) {
            unlink($upload_pdf_dir . $file_pdf_name);
        }
        if (isset($thumbnail_name) && $thumbnail_name && file_exists($upload_thumb_dir . $thumbnail_name)) {
            unlink($upload_thumb_dir . $thumbnail_name);
        }
    }
}

// Generate CSRF token
if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}

// Get all publikasi
$publikasi = [];
$query = "SELECT * FROM publikasi ORDER BY created_at DESC";
$result = mysqli_query($conn, $query);
if ($result) {
    $publikasi = mysqli_fetch_all($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>Kelola Publikasi - AVI</title>
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
</head>
<body class="bg-gray-100">
    <div class="flex">
        
        <?php include 'sidebar.php'; ?>

<div class="flex-1 p-8">
            <div class="max-w-6xl mx-auto">
                <div class="bg-white rounded-lg shadow-md p-6">
                    <div class="flex justify-between items-center mb-6">
                        <h1 class="text-2xl font-bold text-gray-800">Kelola Publikasi</h1>
                        <div class="text-sm text-gray-600">
                            <i class="fas fa-info-circle mr-1"></i>
                            Upload Dir: <?php echo is_writable($upload_pdf_dir) ? 'Writable' : 'Not Writable'; ?>
                        </div>
                    </div>

<?php if ($success): ?>
                        <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded mb-4">
                            <i class="fas fa-check-circle mr-2"></i><?php echo $success; ?>
                        </div>
                    <?php endif; ?>
                    
                    <?php if ($error): ?>
                        <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded mb-4">
                            <i class="fas fa-exclamation-circle mr-2"></i><?php echo $error; ?>
                        </div>
                    <?php endif; ?>

<?php if ($error && isset($_FILES['file_publikasi'])): ?>
                        <div class="bg-yellow-100 border border-yellow-400 text-yellow-700 px-4 py-3 rounded mb-4 text-sm">
                            <strong>Debug Information:</strong><br>
                            PHP Version: <?php echo phpversion(); ?><br>
                            Upload Max Filesize: <?php echo ini_get('upload_max_filesize'); ?><br>
                            Post Max Size: <?php echo ini_get('post_max_size'); ?><br>
                            Max Execution Time: <?php echo ini_get('max_execution_time'); ?>s<br>
                            Memory Limit: <?php echo ini_get('memory_limit'); ?><br>
                            PDF File Size: <?php echo isset($_FILES['file_publikasi']['size']) ? round($_FILES['file_publikasi']['size'] / 1024 / 1024, 2) . ' MB' : 'N/A'; ?>
                        </div>
                    <?php endif; ?>

<div class="bg-blue-50 border border-blue-200 rounded-lg p-6 mb-6">
                        <h2 class="text-lg font-semibold text-blue-800 mb-4">
                            <i class="fas fa-plus-circle mr-2"></i>Tambah Publikasi Baru
                        </h2>
                        <form method="POST" enctype="multipart/form-data" class="space-y-4">
                            <input type="hidden" name="csrf_token" value="<?php echo $_SESSION['csrf_token']; ?>">
                            
                            <div class="grid grid-cols-1 md:grid-cols-2 gap-4">
                                <div>
                                    <label for="nama_publikasi" class="block text-sm font-medium text-gray-700 mb-1">
                                        <i class="fas fa-heading mr-2"></i>Nama Publikasi *
                                    </label>
                                    <input type="text" id="nama_publikasi" name="nama_publikasi" required
                                        class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500"
                                        placeholder="Masukkan nama publikasi"
                                        value="<?php echo isset($_POST['nama_publikasi']) ? htmlspecialchars($_POST['nama_publikasi']) : ''; ?>">
                                </div>
                                
                                <div>
                                    <label for="file_publikasi" class="block text-sm font-medium text-gray-700 mb-1">
                                        <i class="fas fa-file-pdf mr-2"></i>File Publikasi (PDF) *
                                    </label>
                                    <input type="file" id="file_publikasi" name="file_publikasi" accept=".pdf" required
                                        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-xs text-gray-500 mt-1">*Wajib diisi, hanya file PDF (tanpa batas ukuran)</p>
                                </div>
                            </div>
                            
                            <div>
                                <label for="thumbnail" class="block text-sm font-medium text-gray-700 mb-1">
                                    <i class="fas fa-image mr-2"></i>Thumbnail (Gambar)
                                </label>
                                <input type="file" id="thumbnail" name="thumbnail" 
                                    accept=".jpg,.jpeg,.png,.gif,.webp"
                                    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-xs text-gray-500 mt-1">Opsional. Format: JPG, JPEG, PNG, GIF, WebP (akan dikompres otomatis)</p>
                                
                                
                                <div id="thumbnail-preview" class="mt-2 hidden">
                                    <p class="text-sm text-gray-600 mb-2">Preview Thumbnail:</p>
                                    <img id="preview-image" class="max-w-32 max-h-32 border rounded">
                                </div>
                            </div>
                            
                            <div class="bg-gray-100 p-4 rounded-lg">
                                <h3 class="text-sm font-semibold text-gray-700 mb-2">
                                    <i class="fas fa-info-circle mr-1"></i>Informasi Upload:
                                </h3>
                                <ul class="text-xs text-gray-600 space-y-1">
                                    <li>• File PDF: Tidak ada batasan ukuran</li>
                                    <li>• Thumbnail: Akan dikompres otomatis untuk menghemat space</li>
                                    <li>• Pastikan server memiliki storage yang cukup untuk file besar</li>
                                </ul>
                            </div>
                            
                            <div class="flex space-x-4">
                                <button type="submit" name="tambah" 
                                    class="bg-blue-600 text-white px-6 py-2 rounded-md hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500 transition duration-200">
                                    <i class="fas fa-plus mr-2"></i>Tambah Publikasi
                                </button>
                                <button type="button" onclick="clearForm()" 
                                    class="bg-gray-500 text-white px-6 py-2 rounded-md hover:bg-gray-600 focus:outline-none focus:ring-2 focus:ring-gray-500 transition duration-200">
                                    <i class="fas fa-times mr-2"></i>Bersihkan
                                </button>
                            </div>
                        </form>
                    </div>

<div class="bg-white border border-gray-200 rounded-lg">
                        <h2 class="text-lg font-semibold text-gray-800 p-4 border-b">
                            <i class="fas fa-list mr-2"></i>Daftar Publikasi
                        </h2>
                        
                        <?php if (empty($publikasi)): ?>
                            <div class="text-center py-8 text-gray-500">
                                <i class="fas fa-file-pdf text-4xl mb-2"></i>
                                <p>Belum ada publikasi</p>
                            </div>
                        <?php else: ?>
                            <div class="overflow-x-auto">
                                <table class="w-full">
                                    <thead>
                                        <tr class="bg-gray-50">
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">No</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Thumbnail</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Nama Publikasi</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">File PDF</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Ukuran File</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Tanggal Upload</th>
                                            <th class="px-4 py-3 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Aksi</th>
                                        </tr>
                                    </thead>
                                    <tbody class="bg-white divide-y divide-gray-200">
                                        <?php foreach ($publikasi as $index => $pub): 
                                            $file_path = $upload_pdf_dir . $pub['file_publikasi'];
                                            $file_size = file_exists($file_path) ? filesize($file_path) : 0;
                                        ?>
                                        <tr class="hover:bg-gray-50">
                                            <td class="px-4 py-4 whitespace-nowrap text-sm text-gray-900 font-medium">
                                                <?php echo $index + 1; ?>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap">
                                                <?php if ($pub['thumbnail']): ?>
                                                    <img src="uploads/publikasi/thumbnails/<?php echo $pub['thumbnail']; ?>" 
                                                         alt="Thumbnail" 
                                                         class="w-12 h-12 object-cover rounded border">
                                                <?php else: ?>
                                                    <div class="w-12 h-12 bg-gray-200 rounded border flex items-center justify-center">
                                                        <i class="fas fa-image text-gray-400"></i>
                                                    </div>
                                                <?php endif; ?>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap text-sm text-gray-900">
                                                <?php echo htmlspecialchars($pub['nama_publikasi']); ?>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap text-sm">
                                                <a href="uploads/publikasi/<?php echo $pub['file_publikasi']; ?>" 
                                                   target="_blank" 
                                                   class="text-blue-600 hover:text-blue-800 flex items-center font-medium">
                                                    <i class="fas fa-file-pdf mr-2 text-red-500"></i>
                                                    Lihat PDF
                                                </a>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap text-sm text-gray-900">
                                                <?php 
                                                if ($file_size > 0) {
                                                    if ($file_size >= 1024 * 1024) {
                                                        echo round($file_size / (1024 * 1024), 2) . ' MB';
                                                    } else {
                                                        echo round($file_size / 1024, 2) . ' KB';
                                                    }
                                                } else {
                                                    echo 'N/A';
                                                }
                                                ?>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap text-sm text-gray-900">
                                                <?php echo date('d/m/Y H:i', strtotime($pub['created_at'])); ?>
                                            </td>
                                            <td class="px-4 py-4 whitespace-nowrap text-sm">
                                                <form method="POST" onsubmit="return confirm('Apakah Anda yakin ingin menghapus publikasi ini?');">
                                                    <input type="hidden" name="csrf_token" value="<?php echo $_SESSION['csrf_token']; ?>">
                                                    <input type="hidden" name="id" value="<?php echo $pub['id']; ?>">
                                                    <button type="submit" name="hapus" 
                                                            class="text-red-600 hover:text-red-800 flex items-center font-medium">
                                                        <i class="fas fa-trash mr-1"></i> Hapus
                                                    </button>
                                                </form>
                                            </td>
                                        </tr>
                                        <?php endforeach; ?>
                                    </tbody>
                                </table>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

// Thumbnail preview
        document.getElementById('thumbnail').addEventListener('change', function(e) {
            const preview = document.getElementById('thumbnail-preview');
            const previewImage = document.getElementById('preview-image');
            
            if (this.files && this.files[0]) {
                const reader = new FileReader();
                
                reader.onload = function(e) {
                    previewImage.src = e.target.result;
                    preview.classList.remove('hidden');
                }
                
                reader.readAsDataURL(this.files[0]);
            } else {
                preview.classList.add('hidden');
            }
        });

// Clear form function
        function clearForm() {
            document.getElementById('nama_publikasi').value = '';
            document.getElementById('file_publikasi').value = '';
            document.getElementById('thumbnail').value = '';
            document.getElementById('thumbnail-preview').classList.add('hidden');
        }

// Tampilkan ukuran file PDF yang dipilih
        document.getElementById('file_publikasi').addEventListener('change', function(e) {
            const file = this.files[0];
            if (file) {
                const fileSize = file.size;
                let sizeText = '';
                
                if (fileSize >= 1024 * 1024 * 1024) {
                    sizeText = (fileSize / (1024 * 1024 * 1024)).toFixed(2) + ' GB';
                } else if (fileSize >= 1024 * 1024) {
                    sizeText = (fileSize / (1024 * 1024)).toFixed(2) + ' MB';
                } else if (fileSize >= 1024) {
                    sizeText = (fileSize / 1024).toFixed(2) + ' KB';
                } else {
                    sizeText = fileSize + ' bytes';
                }
                
                // Cari label untuk menampilkan ukuran file
                const label = this.parentElement;
                const existingSizeInfo = label.querySelector('.file-size-info');
                if (existingSizeInfo) {
                    existingSizeInfo.remove();
                }
                
                const sizeInfo = document.createElement('p');
                sizeInfo.className = 'file-size-info text-xs text-green-600 mt-1';
                sizeInfo.innerHTML = `<i class="fas fa-hdd mr-1"></i>Ukuran file: ${sizeText}`;
                label.appendChild(sizeInfo);
            }
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: kelola_publikasi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation