Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.4.15

User:

u892747680

Directory:

/home/u892747680/domains/sisteminformasic.com/public_html/Estu/admin

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: manage-paket.php

<?php
require_once '../config/db.php';
include '../admin/includes/header-admin.php';

// Process form submission for adding or updating paket
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $id = isset($_POST['id']) ? intval($_POST['id']) : 0;
    $nama_paket = $conn->real_escape_string($_POST['nama_paket']);
    $kecepatan = $conn->real_escape_string($_POST['kecepatan']);
    $harga = intval($_POST['harga']);
    $deskripsi = $conn->real_escape_string($_POST['deskripsi']);
    
    // If ID is provided, update existing paket
    if ($id > 0) {
        $sql = "UPDATE paket SET nama_paket = ?, kecepatan = ?, harga = ?, deskripsi = ? WHERE id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("ssisi", $nama_paket, $kecepatan, $harga, $deskripsi, $id);
        
        if ($stmt->execute()) {
            $success_message = "Paket berhasil diperbarui!";
        } else {
            $error_message = "Error: " . $stmt->error;
        }
        $stmt->close();
    } 
    // Otherwise, add new paket
    else {
        $sql = "INSERT INTO paket (nama_paket, kecepatan, harga, deskripsi) VALUES (?, ?, ?, ?)";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("ssis", $nama_paket, $kecepatan, $harga, $deskripsi);
        
        if ($stmt->execute()) {
            $success_message = "Paket berhasil ditambahkan!";
        } else {
            $error_message = "Error: " . $stmt->error;
        }
        $stmt->close();
    }
}

// Delete paket
if (isset($_GET['delete'])) {
    $id = intval($_GET['delete']);
    
    // Check if paket is referenced in pesanan
    $check_sql = "SELECT COUNT(*) as count FROM pesanan WHERE paket_id = ?";
    $check_stmt = $conn->prepare($check_sql);
    $check_stmt->bind_param("i", $id);
    $check_stmt->execute();
    $check_result = $check_stmt->get_result();
    $check_row = $check_result->fetch_assoc();
    
    if ($check_row['count'] > 0) {
        $error_message = "Paket tidak dapat dihapus karena masih digunakan dalam pesanan!";
    } else {
        $sql = "DELETE FROM paket WHERE id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $id);
        
        if ($stmt->execute()) {
            $success_message = "Paket berhasil dihapus!";
        } else {
            $error_message = "Error: " . $stmt->error;
        }
        $stmt->close();
    }
}

// Get paket for editing
$edit_paket = null;
if (isset($_GET['edit'])) {
    $id = intval($_GET['edit']);
    $sql = "SELECT * FROM paket WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $result = $stmt->get_result();
    if ($result->num_rows == 1) {
        $edit_paket = $result->fetch_assoc();
    }
    $stmt->close();
}

// Get all paket
$sql = "SELECT * FROM paket ORDER BY harga ASC";
$result = $conn->query($sql);
?>

<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h1 class="h2">Kelola Paket Internet</h1>
        <button class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#paketModal">
            <i class="fas fa-plus"></i> Tambah Paket
        </button>
    </div>
    
    <?php if (isset($success_message)): ?>
    <div class="alert alert-success alert-dismissible fade show" role="alert">
        <?php echo $success_message; ?>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
    <?php endif; ?>
    
    <?php if (isset($error_message)): ?>
    <div class="alert alert-danger alert-dismissible fade show" role="alert">
        <?php echo $error_message; ?>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    </div>
    <?php endif; ?>
    
    <div class="card">
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
            <div class="table-responsive">
                <table class="table table-striped table-hover">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Nama Paket</th>
                            <th>Kecepatan</th>
                            <th>Harga</th>
                            <th>Deskripsi</th>
                            <th>Aksi</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php while ($row = $result->fetch_assoc()): ?>
                        <tr>
                            <td><?php echo $row['id']; ?></td>
                            <td><?php echo htmlspecialchars($row['nama_paket']); ?></td>
                            <td><?php echo htmlspecialchars($row['kecepatan']); ?></td>
                            <td>Rp <?php echo number_format($row['harga'], 0, ',', '.'); ?></td>
                            <td><?php echo substr(htmlspecialchars($row['deskripsi']), 0, 50) . (strlen($row['deskripsi']) > 50 ? '...' : ''); ?></td>
                            <td>
                                <a href="?edit=<?php echo $row['id']; ?>" class="btn btn-sm btn-info">
                                    <i class="fas fa-edit"></i> Edit
                                </a>
                                <a href="?delete=<?php echo $row['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirmDelete();">
                                    <i class="fas fa-trash"></i> Hapus
                                </a>
                            </td>
                        </tr>
                        <?php endwhile; ?>
                    </tbody>
                </table>
            </div>
            <?php else: ?>
            <p class="text-center">Tidak ada paket internet yang tersedia.</p>
            <?php endif; ?>
        </div>
    </div>
</div>

<div class="modal fade" id="paketModal" tabindex="-1" aria-labelledby="paketModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="paketModalLabel"><?php echo $edit_paket ? 'Edit Paket' : 'Tambah Paket Baru'; ?></h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="post" action="">
                <div class="modal-body">
                    <?php if ($edit_paket): ?>
                    <input type="hidden" name="id" value="<?php echo $edit_paket['id']; ?>">
                    <?php endif; ?>
                    
                    <div class="mb-3">
                        <label for="nama_paket" class="form-label">Nama Paket</label>
                        <input type="text" class="form-control" id="nama_paket" name="nama_paket" value="<?php echo $edit_paket ? htmlspecialchars($edit_paket['nama_paket']) : ''; ?>" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="kecepatan" class="form-label">Kecepatan</label>
                        <input type="text" class="form-control" id="kecepatan" name="kecepatan" value="<?php echo $edit_paket ? htmlspecialchars($edit_paket['kecepatan']) : ''; ?>" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="harga" class="form-label">Harga (Rp)</label>
                        <input type="number" class="form-control" id="harga" name="harga" value="<?php echo $edit_paket ? $edit_paket['harga'] : ''; ?>" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="deskripsi" class="form-label">Deskripsi</label>
                        <textarea class="form-control" id="deskripsi" name="deskripsi" rows="3" required><?php echo $edit_paket ? htmlspecialchars($edit_paket['deskripsi']) : ''; ?></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                    <button type="submit" class="btn btn-primary">Simpan</button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include '../admin/includes/footer-admin.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-paket.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation