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/alqudsvolunteers/htdocs/www.alqudsvolunteers.id/admin1

Free Space:

81.8 GB

🔧 Quick Actions

✏️ Editing: program_edit.php

<?php
require_once 'config.php';

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

// Query untuk mengambil data program
$program_query = "SELECT * FROM program WHERE id = $id";
$program_result = mysqli_query($conn, $program_query);
$program = mysqli_fetch_assoc($program_result);

// Query untuk mengambil kategori
$category_query = "SELECT * FROM category ORDER BY program_category";
$category_result = mysqli_query($conn, $category_query);

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

// Proses update program
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $program_name = mysqli_real_escape_string($conn, $_POST['program_name']);
    $program_content = mysqli_real_escape_string($conn, $_POST['program_content']);
    $id_category = intval($_POST['id_category']);
    
    $query = "UPDATE program SET 
              program_name = '$program_name', 
              program_content = '$program_content', 
              id_category = $id_category 
              WHERE id = $id";
    
    if (mysqli_query($conn, $query)) {
        $success = "Program berhasil diperbarui!";
        
        // Upload foto baru jika ada
        if (!empty($_FILES['photos']['name'][0])) {
            $target_dir = "../uploads/programs/";
            if (!file_exists($target_dir)) {
                mkdir($target_dir, 0777, true);
            }
            
            // Hapus foto lama
            $delete_photos_query = "DELETE FROM program_photo WHERE id_program = $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 = 'program_' . $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 program_photo (id_program, foto, urutan) 
                                       VALUES ($id, '$filename', $urutan)";
                        mysqli_query($conn, $photo_query);
                    }
                }
            }
        }
        
        header("Location: program.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 Program - 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 Program</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="program_name" class="block text-gray-700 text-sm font-bold mb-2">Nama Program</label>
                    <input type="text" id="program_name" name="program_name" required 
                        value="<?php echo htmlspecialchars($program['program_name']); ?>"
                        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="id_category" class="block text-gray-700 text-sm font-bold mb-2">Kategori</label>
                    <select id="id_category" name="id_category" 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 Kategori</option>
                        <?php 
                        mysqli_data_seek($category_result, 0);
                        while ($category = mysqli_fetch_assoc($category_result)): 
                        ?>
                            <option value="<?php echo $category['id']; ?>" <?php echo $category['id'] == $program['id_category'] ? 'selected' : ''; ?>>
                                <?php echo htmlspecialchars($category['program_category']); ?>
                            </option>
                        <?php endwhile; ?>
                    </select>
                </div>
                
                <div class="mb-4">
                    <label for="program_content" class="block text-gray-700 text-sm font-bold mb-2">Konten Program</label>
                    <textarea id="program_content" name="program_content" rows="6" 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($program['program_content']); ?></textarea>
                </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 if (mysqli_num_rows($photos_result) > 0): ?>
                            <?php while ($photo = mysqli_fetch_assoc($photos_result)): ?>
                                <div class="relative">
                                    <img src="../uploads/programs/<?php echo $photo['foto']; ?>" alt="Program 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; ?>
                        <?php else: ?>
                            <p class="text-gray-500">Belum ada foto untuk program ini.</p>
                        <?php endif; ?>
                    </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>
                
                <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 Program
                </button>
                <a href="program.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>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: program_edit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation