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

Free Space:

81.8 GB

🔧 Quick Actions

✏️ Editing: publication_group.php

<?php
require_once 'config.php';
checkLogin();

$success_msg = '';
$error_msg = '';

// Create operation
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['add_group'])) {
    $name = mysqli_real_escape_string($conn, $_POST['name_group']);
    
    $query = "INSERT INTO publication_group (name_group) VALUES ('$name')";
    if (mysqli_query($conn, $query)) {
        $success_msg = "Group publication berhasil ditambahkan!";
    } else {
        $error_msg = "Error: " . mysqli_error($conn);
    }
}

// Update operation
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['edit_group'])) {
    $id = mysqli_real_escape_string($conn, $_POST['id']);
    $name = mysqli_real_escape_string($conn, $_POST['name_group']);
    
    $query = "UPDATE publication_group SET name_group='$name' WHERE id='$id'";
    if (mysqli_query($conn, $query)) {
        $success_msg = "Group publication berhasil diperbarui!";
    } else {
        $error_msg = "Error: " . mysqli_error($conn);
    }
}

// Delete operation
if (isset($_GET['delete'])) {
    $id = mysqli_real_escape_string($conn, $_GET['delete']);
    
    // Check if group is used in any publication
    $check_query = "SELECT COUNT(*) as count FROM publication WHERE group_id = '$id'";
    $check_result = mysqli_query($conn, $check_query);
    $check_data = mysqli_fetch_assoc($check_result);
    
    if ($check_data['count'] > 0) {
        $error_msg = "Tidak dapat menghapus group karena masih digunakan oleh beberapa publication!";
    } else {
        $query = "DELETE FROM publication_group WHERE id='$id'";
        if (mysqli_query($conn, $query)) {
            $success_msg = "Group publication berhasil dihapus!";
        } else {
            $error_msg = "Error: " . mysqli_error($conn);
        }
    }
}

// Read operation - Fetch all groups
$query = "SELECT * FROM publication_group ORDER BY id DESC";
$result = mysqli_query($conn, $query);
$groups = mysqli_fetch_all($result, MYSQLI_ASSOC);

// Get group data for editing
$edit_group = null;
if (isset($_GET['edit'])) {
    $id = mysqli_real_escape_string($conn, $_GET['edit']);
    $query = "SELECT * FROM publication_group WHERE id='$id'";
    $edit_result = mysqli_query($conn, $query);
    $edit_group = mysqli_fetch_assoc($edit_result);
}
?>

<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    
    <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">
  
    <div class="flex">
      <?php include 'sidebar.php'; ?>
       
        
        <div class="flex-1 p-8">
            
                <div class="shadow-md p-6">
                    <h1 class="text-2xl font-bold mb-6 text-gray-800">Kelola Group Publication</h1>
                    
                    <?php if (!empty($success_msg)): ?>
                        <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded relative mb-4">
                            <span class="block sm:inline"><?php echo $success_msg; ?></span>
                        </div>
                    <?php endif; ?>
                    
                    <?php if (!empty($error_msg)): ?>
                        <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded relative mb-4">
                            <span class="block sm:inline"><?php echo $error_msg; ?></span>
                        </div>
                    <?php endif; ?>
                    
                    
                    <div class="bg-blue-50 p-4 rounded-lg mb-6">
                        <h2 class="text-lg font-semibold mb-3 text-blue-800">
                            <?php echo $edit_group ? 'Edit Group Publication' : 'Tambah Group Publication Baru'; ?>
                        </h2>
                        <form method="POST" action="">
                            <?php if ($edit_group): ?>
                                <input type="hidden" name="id" value="<?php echo $edit_group['id']; ?>">
                            <?php endif; ?>
                            
                            <div class="mb-3">
                                <label for="name_group" class="block text-sm font-medium text-gray-700 mb-1">Nama Group</label>
                                <input type="text" id="name_group" name="name_group" 
                                       value="<?php echo $edit_group ? $edit_group['name_group'] : ''; ?>" 
                                       class="w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500" 
                                       required>
                            </div>
                            
                            <div class="flex justify-end">
                                <?php if ($edit_group): ?>
                                    <button type="submit" name="edit_group" class="bg-blue-600 hover:bg-blue-700 text-white font-medium py-2 px-4 rounded-md">
                                        Update Group
                                    </button>
                                    <a href="publication_group.php" class="ml-2 bg-gray-500 hover:bg-gray-600 text-white font-medium py-2 px-4 rounded-md">
                                        Batal
                                    </a>
                                <?php else: ?>
                                    <button type="submit" name="add_group" class="bg-blue-600 hover:bg-blue-700 text-white font-medium py-2 px-4 rounded-md">
                                        Tambah Group
                                    </button>
                                <?php endif; ?>
                            </div>
                        </form>
                    </div>
                    
                    
                    <div>
                        <h2 class="text-lg font-semibold mb-3 text-gray-700">Daftar Group Publication</h2>
                        
                        <?php if (count($groups) > 0): ?>
                            <div class="overflow-x-auto">
                                <table class="min-w-full bg-white">
                                    <thead>
                                        <tr>
                                            <th class="py-2 px-4 border-b border-gray-200 bg-gray-50 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">ID</th>
                                            <th class="py-2 px-4 border-b border-gray-200 bg-gray-50 text-left text-xs font-medium text-gray-500 uppercase tracking-wider">Nama Group</th>
                                            <th class="py-2 px-4 border-b border-gray-200 bg-gray-50 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 ($groups as $group): ?>
                                            <tr>
                                                <td class="py-3 px-4 border-b border-gray-200"><?php echo $group['id']; ?></td>
                                                <td class="py-3 px-4 border-b border-gray-200"><?php echo $group['name_group']; ?></td>
                                                <td class="py-3 px-4 border-b border-gray-200">
                                                    <a href="publication_group.php?edit=<?php echo $group['id']; ?>" class="text-blue-600 hover:text-blue-900 mr-2">
                                                        <i class="fas fa-edit"></i> Edit
                                                    </a>
                                                    <a href="publication_group.php?delete=<?php echo $group['id']; ?>" 
                                                       class="text-red-600 hover:text-red-900" 
                                                       onclick="return confirm('Apakah Anda yakin ingin menghapus group ini?')">
                                                        <i class="fas fa-trash"></i> Hapus
                                                    </a>
                                                </td>
                                            </tr>
                                        <?php endforeach; ?>
                                    </tbody>
                                </table>
                            </div>
                        <?php else: ?>
                            <div class="bg-yellow-50 border border-yellow-200 rounded-md p-4">
                                <p class="text-yellow-800">Belum ada group publication. Silakan tambahkan group baru.</p>
                            </div>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: publication_group.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation