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

Free Space:

9.89 TB

🔧 Quick Actions

✏️ Editing: prestasi_edit.php

<?php
$page_title = "Edit Prestasi";
include 'partials/header.php';
require_once '../includes/koneksi.php';

// Check if ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header('Location: kelola_prestasi.php');
    exit();
}

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

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $nama_siswa = trim($_POST['nama_siswa']);
    $kelas = trim($_POST['kelas']);
    $jenis_prestasi = trim($_POST['jenis_prestasi']);
    $tingkat = $_POST['tingkat'];
    $peringkat = $_POST['peringkat'];
    $tahun = $_POST['tahun'];
    $deskripsi = trim($_POST['deskripsi']);
    
    // Validation
    $errors = [];
    
    if (empty($nama_siswa)) {
        $errors[] = "Nama siswa harus diisi";
    }
    
    if (empty($kelas)) {
        $errors[] = "Kelas harus diisi";
    }
    
    if (empty($jenis_prestasi)) {
        $errors[] = "Jenis prestasi harus diisi";
    }
    
    if (empty($tingkat)) {
        $errors[] = "Tingkat harus dipilih";
    }
    
    if (empty($peringkat)) {
        $errors[] = "Peringkat harus dipilih";
    }
    
    if (empty($tahun)) {
        $errors[] = "Tahun harus dipilih";
    }
    
    if (empty($errors)) {
        // Get current data for image handling
        $stmt = $conn->prepare("SELECT gambar FROM prestasi WHERE id = ?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $current_data = $stmt->get_result()->fetch_assoc();
        
        $gambar = $current_data['gambar']; // Keep current image by default
        
        // Handle image upload
        if (isset($_FILES['gambar']) && $_FILES['gambar']['error'] == 0) {
            $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
            $max_size = 5 * 1024 * 1024; // 5MB
            
            if (in_array($_FILES['gambar']['type'], $allowed_types)) {
                if ($_FILES['gambar']['size'] <= $max_size) {
                    $upload_dir = '../uploads/prestasi/';
                    
                    // Create directory if it doesn't exist
                    if (!file_exists($upload_dir)) {
                        mkdir($upload_dir, 0777, true);
                    }
                    
                    $file_extension = pathinfo($_FILES['gambar']['name'], PATHINFO_EXTENSION);
                    $new_filename = 'prestasi_' . time() . '_' . uniqid() . '.' . $file_extension;
                    $upload_path = $upload_dir . $new_filename;
                    
                    if (move_uploaded_file($_FILES['gambar']['tmp_name'], $upload_path)) {
                        // Delete old image if exists
                        if ($current_data['gambar'] && file_exists($upload_dir . $current_data['gambar'])) {
                            unlink($upload_dir . $current_data['gambar']);
                        }
                        $gambar = $new_filename;
                    } else {
                        $errors[] = "Gagal mengupload gambar";
                    }
                } else {
                    $errors[] = "Ukuran gambar maksimal 5MB";
                }
            } else {
                $errors[] = "Format gambar harus JPG, JPEG, PNG, atau GIF";
            }
        }
        
        // If no errors, update the database
        if (empty($errors)) {
            $stmt = $conn->prepare("UPDATE prestasi SET nama_siswa = ?, kelas = ?, jenis_prestasi = ?, tingkat = ?, peringkat = ?, tahun = ?, deskripsi = ?, gambar = ? WHERE id = ?");
            
            if ($stmt === false) {
                $error_message = "Error preparing statement: " . $conn->error;
            } else {
                $stmt->bind_param("ssssssssi", $nama_siswa, $kelas, $jenis_prestasi, $tingkat, $peringkat, $tahun, $deskripsi, $gambar, $id);
                
                if ($stmt->execute()) {
                    $success_message = "Prestasi berhasil diperbarui!";
                    // Redirect after 2 seconds
                    echo "<script>
                        setTimeout(function() {
                            window.location.href = 'kelola_prestasi.php';
                        }, 2000);
                    </script>";
                } else {
                    $error_message = "Gagal memperbarui prestasi: " . $conn->error;
                }
            }
        } else {
            $error_message = implode('<br>', $errors);
        }
    } else {
        $error_message = implode('<br>', $errors);
    }
}

// Get prestasi data
$stmt = $conn->prepare("SELECT * FROM prestasi WHERE id = ?");
if ($stmt === false) {
    die('Prepare failed: ' . $conn->error);
}

$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$prestasi = $result->fetch_assoc();

if (!$prestasi) {
    header('Location: kelola_prestasi.php');
    exit();
}

// Options for select fields
$tingkat_options = ['Sekolah', 'Kecamatan', 'Kabupaten', 'Provinsi', 'Nasional', 'Internasional'];
$peringkat_options = ['Juara 1', 'Juara 2', 'Juara 3', 'Harapan 1', 'Harapan 2', 'Harapan 3', 'Finalis', 'Peserta'];
?>

<div class="container-fluid">
    <div class="row">
        <?php include 'partials/sidebar.php'; ?>
        
        <main class="col-lg-10 col-md-9 ms-sm-auto px-md-4 content-wrapper">
            <?php include 'partials/navbar.php'; ?>
            
            <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
                <h1 class="h2">
                    <i class="fas fa-edit text-warning"></i>
                    Edit Prestasi
                </h1>
                <div class="btn-toolbar mb-2 mb-md-0">
                    <a href="kelola_prestasi.php" class="btn btn-secondary">
                        <i class="fas fa-arrow-left"></i>
                        Kembali
                    </a>
                </div>
            </div>

<?php if ($success_message): ?>
                <div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle"></i>
                    <?php echo $success_message; ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<?php if ($error_message): ?>
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-circle"></i>
                    <?php echo $error_message; ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<div class="card shadow mb-4">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-warning">
                        <i class="fas fa-edit"></i>
                        Form Edit Prestasi
                    </h6>
                </div>
                <div class="card-body">
                    <form method="POST" enctype="multipart/form-data">
                        <div class="row">
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="nama_siswa" class="form-label">Nama Siswa <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" id="nama_siswa" name="nama_siswa" 
                                           value="<?php echo htmlspecialchars($prestasi['nama_siswa']); ?>" required>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="mb-3">
                                    <label for="kelas" class="form-label">Kelas <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" id="kelas" name="kelas" 
                                           placeholder="Contoh: XII IPA 1" 
                                           value="<?php echo htmlspecialchars($prestasi['kelas']); ?>" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-12">
                                <div class="mb-3">
                                    <label for="jenis_prestasi" class="form-label">Jenis Prestasi <span class="text-danger">*</span></label>
                                    <input type="text" class="form-control" id="jenis_prestasi" name="jenis_prestasi" 
                                           placeholder="Contoh: Olimpiade Matematika, Lomba Karya Tulis, dll"
                                           value="<?php echo htmlspecialchars($prestasi['jenis_prestasi']); ?>" required>
                                </div>
                            </div>
                        </div>

<div class="row">
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="tingkat" class="form-label">Tingkat <span class="text-danger">*</span></label>
                                    <select class="form-select" id="tingkat" name="tingkat" required>
                                        <option value="">Pilih Tingkat</option>
                                        <?php foreach ($tingkat_options as $tingkat): ?>
                                            <option value="<?php echo $tingkat; ?>" 
                                                    <?php echo ($prestasi['tingkat'] == $tingkat) ? 'selected' : ''; ?>>
                                                <?php echo $tingkat; ?>
                                            </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="peringkat" class="form-label">Peringkat <span class="text-danger">*</span></label>
                                    <select class="form-select" id="peringkat" name="peringkat" required>
                                        <option value="">Pilih Peringkat</option>
                                        <?php foreach ($peringkat_options as $peringkat): ?>
                                            <option value="<?php echo $peringkat; ?>" 
                                                    <?php echo ($prestasi['peringkat'] == $peringkat) ? 'selected' : ''; ?>>
                                                <?php echo $peringkat; ?>
                                            </option>
                                        <?php endforeach; ?>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="mb-3">
                                    <label for="tahun" class="form-label">Tahun <span class="text-danger">*</span></label>
                                    <select class="form-select" id="tahun" name="tahun" required>
                                        <option value="">Pilih Tahun</option>
                                        <?php 
                                        $current_year = date('Y');
                                        for ($year = $current_year; $year >= 2000; $year--): 
                                        ?>
                                            <option value="<?php echo $year; ?>" 
                                                    <?php echo ($prestasi['tahun'] == $year) ? 'selected' : ''; ?>>
                                                <?php echo $year; ?>
                                            </option>
                                        <?php endfor; ?>
                                    </select>
                                </div>
                            </div>
                        </div>

<div class="mb-3">
                            <label for="deskripsi" class="form-label">Deskripsi</label>
                            <textarea class="form-control" id="deskripsi" name="deskripsi" rows="4" 
                                      placeholder="Deskripsi detail tentang prestasi"><?php echo htmlspecialchars($prestasi['deskripsi']); ?></textarea>
                        </div>

<div class="mb-3">
                            <label for="gambar" class="form-label">Foto/Gambar</label>
                            
                            <?php if ($prestasi['gambar']): ?>
                                <div class="mb-2">
                                    <small class="text-muted">Gambar saat ini:</small><br>
                                    <img src="../uploads/prestasi/<?php echo htmlspecialchars($prestasi['gambar']); ?>" 
                                         alt="Current Image" class="img-thumbnail" style="max-width: 200px;">
                                </div>
                            <?php endif; ?>
                            
                            <input type="file" class="form-control" id="gambar" name="gambar" accept="image/*">
                            <div class="form-text">
                                Format yang diizinkan: JPG, JPEG, PNG, GIF. Maksimal 5MB.
                                <?php if ($prestasi['gambar']): ?>
                                    <br><strong>Kosongkan jika tidak ingin mengubah gambar.</strong>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="d-flex justify-content-between">
                            <a href="kelola_prestasi.php" class="btn btn-secondary">
                                <i class="fas fa-times"></i>
                                Batal
                            </a>
                            <button type="submit" class="btn btn-warning">
                                <i class="fas fa-save"></i>
                                Perbarui Prestasi
                            </button>
                        </div>
                    </form>
                </div>
            </div>
        </main>
    </div>
</div>

// Auto hide alerts after 5 seconds
setTimeout(function() {
    const alerts = document.querySelectorAll('.alert');
    alerts.forEach(function(alert) {
        const bsAlert = new bootstrap.Alert(alert);
        bsAlert.close();
    });
}, 5000);
</script>

.card:hover {
    box-shadow: 0 0.15rem 1.75rem 0 rgba(58, 59, 69, 0.15) !important;
}

.form-label {
    font-weight: 600;
    color: #5a5c69;
}

.form-control:focus, .form-select:focus {
    border-color: #f6c23e;
    box-shadow: 0 0 0 0.2rem rgba(246, 194, 62, 0.25);
}

.btn-warning {
    background-color: #f6c23e;
    border-color: #f6c23e;
}

.btn-warning:hover {
    background-color: #f4b619;
    border-color: #f4b619;
}

.text-danger {
    color: #e74a3b !important;
}

.img-thumbnail {
    border: 2px solid #dee2e6;
    border-radius: 0.5rem;
}
</style>

<?php include 'partials/footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: prestasi_edit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation