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.74 GB

🔧 Quick Actions

✏️ Editing: program.php

<?php
include 'config.php';

// Query untuk mengambil data program
$query = "SELECT p.*, c.program_category FROM program p 
          LEFT JOIN category c ON p.id_category = c.id 
          ORDER BY p.id DESC";
$result = mysqli_query($conn, $query);

// Hapus program
if (isset($_GET['delete'])) {
    $id = intval($_GET['delete']);
    
    // Mulai transaction
    mysqli_begin_transaction($conn);
    
    try {
        // 1. Hapus foto yang terkait dengan program
        $delete_photos = "DELETE FROM program_photo WHERE id_program = $id";
        if (!mysqli_query($conn, $delete_photos)) {
            throw new Exception("Gagal menghapus foto program: " . mysqli_error($conn));
        }
        
        // 2. Hapus program
        $delete_program = "DELETE FROM program WHERE id = $id";
        if (!mysqli_query($conn, $delete_program)) {
            throw new Exception("Gagal menghapus program: " . mysqli_error($conn));
        }
        
        // Commit transaction jika semua query berhasil
        mysqli_commit($conn);
        
        $success = "Program berhasil dihapus!";
        // Refresh halaman
        header("Location: program.php");
        exit();
        
    } catch (Exception $e) {
        // Rollback transaction jika terjadi error
        mysqli_rollback($conn);
        $error = "Terjadi kesalahan: " . $e->getMessage();
    }
}
?>

<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Kelola 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">
        <div class="flex justify-between items-center mb-6">
            <h1 class="text-2xl font-bold text-gray-800">Kelola Program</h1>
            <a href="program_add.php" class="bg-blue-500 text-white font-bold py-2 px-4 rounded-md hover:bg-blue-600">
                <i class="fas fa-plus mr-2"></i>Tambah Baru
            </a>
        </div>
        
        <?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 rounded-lg shadow overflow-hidden">
            <table class="w-full">
                <thead class="bg-gray-50">
                    <tr>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">Nama Program</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">Kategori</th>
                        <th class="px-6 py-3 text-left text-xs font-medium text-gray-500 uppercase">Aksi</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-200">
                    <?php while ($row = mysqli_fetch_assoc($result)): ?>
                    <tr>
                        <td class="px-6 py-4"><?php echo htmlspecialchars($row['program_name']); ?></td>
                        <td class="px-6 py-4"><?php echo htmlspecialchars($row['program_category']); ?></td>
                        <td class="px-6 py-4">
                            <a href="program_edit.php?id=<?php echo $row['id']; ?>" class="text-blue-500 hover:text-blue-700 mr-2">
                                <i class="fas fa-edit"></i>
                            </a>
                            <a href="program.php?delete=<?php echo $row['id']; ?>" class="text-red-500 hover:text-red-700" onclick="return confirm('Yakin ingin menghapus program ini? Semua foto yang terkait juga akan dihapus.')">
                                <i class="fas fa-trash"></i>
                            </a>
                        </td>
                    </tr>
                    <?php endwhile; ?>
                </tbody>
            </table>
        </div>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: program.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation