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/absensi-ra

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: siswa.php

<?php
require_once 'config.php';
checkLogin();
$conn = getConnection();

// Proses tambah siswa
if (isset($_POST['tambah'])) {
    $nis = clean($_POST['nis']);
    $nama = clean($_POST['nama']);
    $kelas = clean($_POST['kelas']);
    
    $stmt = $conn->prepare("INSERT INTO siswa (nis, nama, kelas) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $nis, $nama, $kelas);
    
    if ($stmt->execute()) {
        $success = "Siswa berhasil ditambahkan!";
    } else {
        $error = "Gagal menambahkan siswa. NIS mungkin sudah ada.";
    }
}

// Proses update siswa
if (isset($_POST['update'])) {
    $id = $_POST['id'];
    $nis = clean($_POST['nis']);
    $nama = clean($_POST['nama']);
    $kelas = clean($_POST['kelas']);
    
    $stmt = $conn->prepare("UPDATE siswa SET nis = ?, nama = ?, kelas = ? WHERE id = ?");
    $stmt->bind_param("sssi", $nis, $nama, $kelas, $id);
    
    if ($stmt->execute()) {
        echo "<script>alert('Data siswa berhasil diperbarui!'); window.location.href='siswa.php';</script>";
        exit();
    } else {
        $error = "Gagal memperbarui data siswa.";
    }
}

// Proses hapus siswa
if (isset($_GET['hapus'])) {
    $id = $_GET['hapus'];
    $stmt = $conn->prepare("DELETE FROM siswa WHERE id = ?");
    $stmt->bind_param("i", $id);
    
    if ($stmt->execute()) {
        $success = "Siswa berhasil dihapus!";
    } else {
        $error = "Gagal menghapus siswa.";
    }
}

// Ambil data edit jika ada parameter edit
$data_edit = null;
if (isset($_GET['edit'])) {
    $id = $_GET['edit'];
    $stmt = $conn->prepare("SELECT * FROM siswa WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $data_edit = $stmt->get_result()->fetch_assoc();
}

// Ambil semua siswa
$siswa_list = $conn->query("SELECT * FROM siswa ORDER BY kelas ASC, nis ASC");
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Data Siswa</title>
    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@400;600;700;800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            font-family: 'Nunito', sans-serif;
            background: #f0f8ff; /* AliceBlue */
            min-height: 100vh;
            padding: 20px;
            color: #444;
        }
        .circles {
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            overflow: hidden;
            z-index: -1;
        }
        .circles li {
            position: absolute;
            display: block;
            list-style: none;
            width: 20px;
            height: 20px;
            background: rgba(255, 192, 203, 0.5); /* Light Pink */
            animation: bubble-animate 25s linear infinite;
            bottom: -150px;
            border-radius: 50%;
        }
        .circles li:nth-child(1) { left: 25%; width: 80px; height: 80px; animation-delay: 0s; background: rgba(173, 216, 230, 0.5); }
        .circles li:nth-child(2) { left: 10%; width: 20px; height: 20px; animation-delay: 2s; animation-duration: 12s; background: rgba(255, 255, 153, 0.5); }
        .circles li:nth-child(3) { left: 70%; width: 20px; height: 20px; animation-delay: 4s; }
        .circles li:nth-child(4) { left: 40%; width: 60px; height: 60px; animation-delay: 0s; animation-duration: 18s; background: rgba(144, 238, 144, 0.5); }
        .circles li:nth-child(5) { left: 65%; width: 20px; height: 20px; animation-delay: 0s; }
        .circles li:nth-child(6) { left: 75%; width: 110px; height: 110px; animation-delay: 3s; background: rgba(255, 182, 193, 0.5); }
        .circles li:nth-child(7) { left: 35%; width: 150px; height: 150px; animation-delay: 7s; background: rgba(173, 216, 230, 0.5); }
        .circles li:nth-child(8) { left: 50%; width: 25px; height: 25px; animation-delay: 15s; animation-duration: 45s; }
        .circles li:nth-child(9) { left: 20%; width: 15px; height: 15px; animation-delay: 2s; animation-duration: 35s; background: rgba(255, 255, 153, 0.5); }
        .circles li:nth-child(10) { left: 85%; width: 150px; height: 150px; animation-delay: 0s; animation-duration: 11s; background: rgba(144, 238, 144, 0.5); }
        @keyframes bubble-animate {
            0% { transform: translateY(0) rotate(0deg); opacity: 1; }
            100% { transform: translateY(-1000px) rotate(360deg); opacity: 0; }
        }
        .container {
            max-width: 1200px;
            margin: 0 auto;
        }
        .header {
            background: #fff;
            padding: 25px;
            border-radius: 20px;
            box-shadow: 0 5px 20px rgba(0,0,0,0.05);
            margin-bottom: 30px;
            color: #333;
            position: relative;
            text-align: center;
            border: 2px dashed #ffd166;
        }
        .header h1 {
            color: #ef476f;
            margin-bottom: 10px;
            font-weight: 800;
        }
        .header p { color: #555; }
        .back-btn {
            position: absolute;
            top: 20px;
            left: 20px;
            width: 45px;
            height: 45px;
            display: flex;
            align-items: center;
            justify-content: center;
            background: #ffd166;
            color: white;
            text-decoration: none;
            border-radius: 50%;
            transition: all 0.3s ease;
            font-size: 20px;
            border: none;
        }
        .back-btn:hover { 
            background: #ef476f; 
            transform: scale(1.1) rotate(360deg);
        }
        .content {
            background: #fff;
            padding: 30px;
            border-radius: 20px;
            box-shadow: 0 5px 20px rgba(0,0,0,0.05);
            margin-bottom: 20px;
            color: #444;
        }
        .content h2 {
            color: #06d6a0;
            margin-bottom: 20px;
            font-weight: 700;
            border-bottom: 2px solid #f0f0f0;
            padding-bottom: 10px;
        }
        .alert {
            padding: 15px;
            margin-bottom: 20px;
            border-radius: 10px;
            font-weight: 600;
        }
        .alert-success { background: #e6fffa; color: #06d6a0; border: 1px solid #06d6a0; }
        .alert-error { background: #fff5f5; color: #ef476f; border: 1px solid #ef476f; }
        .form-group {
            margin-bottom: 15px;
        }
        .form-group label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
            color: #555;
        }
        .form-group input, .form-group select {
            width: 100%;
            padding: 12px;
            border: 2px solid #e0e0e0;
            border-radius: 10px;
            font-size: 16px;
            font-family: inherit;
            background: #f9f9f9;
            color: #333;
            transition: all 0.3s ease;
        }
        .form-group input:focus, .form-group select:focus {
            outline: none;
            border-color: #118ab2;
            background: #fff;
        }
        .form-group option {
            background: #fff;
            color: #333;
        }
        .btn {
            padding: 10px 25px;
            color: white;
            border: none;
            border-radius: 50px;
            cursor: pointer;
            font-size: 16px;
            font-weight: 700;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
            transition: all 0.3s ease;
            box-shadow: 0 4px 10px rgba(0,0,0,0.1);
        }
        .btn:hover {
            transform: translateY(-3px) scale(1.05);
            box-shadow: 0 6px 15px rgba(0,0,0,0.15);
        }
        .btn-primary { background: linear-gradient(to right, #118ab2, #06d6a0); }
        .btn-danger { background: linear-gradient(to right, #ef476f, #ff6b6b); }
        .btn-warning { background: linear-gradient(to right, #ffd166, #ff9f43); }
        .btn-success { background: linear-gradient(to right, #06d6a0, #80ed99); }
        .btn-small {
            width: 40px;
            height: 40px;
            padding: 0;
            display: inline-flex;
            align-items: center;
            justify-content: center;
            font-size: 16px;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
        }
        table th {
            padding: 15px;
            text-align: left;
            background-color: #f7f9fc;
            color: #118ab2;
            font-weight: 800;
            text-transform: uppercase;
            font-size: 12px;
            letter-spacing: 1px;
        }
        table td {
            padding: 15px;
            border-bottom: 1px solid #eee;
            vertical-align: middle;
            color: #555;
            font-weight: 600;
        }
        table th:first-child, table td:first-child { border-radius: 10px 0 0 10px; }
        table th:last-child, table td:last-child { border-radius: 0 10px 10px 0; }
        table tbody tr {
            transition: all 0.2s ease-in-out;
        }
        table tbody tr:hover {
            background-color: #fffbe6; /* Light yellow hover */
            transform: scale(1.02);
            box-shadow: 0 5px 15px rgba(0,0,0,0.08);
        }
        .qr-thumb {
            width: 50px;
            height: 50px;
            border-radius: 10px;
            object-fit: cover;
            border: 2px solid white;
            box-shadow: 0 2px 5px rgba(0,0,0,0.1);
            transition: transform 0.3s;
        }
        .qr-thumb:hover {
            transform: scale(3.5) translate(20px, -10px);
            z-index: 100;
            position: relative;
            box-shadow: 0 10px 20px rgba(0,0,0,0.15);
            cursor: zoom-in;
        }
        .form-inline {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 10px;
            align-items: end;
            background: #f7f9fc;
            padding: 20px;
            border-radius: 15px;
        }
        .action-buttons {
            display: flex;
            gap: 10px;
        }
        .table-responsive { overflow-x: auto; -webkit-overflow-scrolling: touch; }
        @media (max-width: 768px) {
            body { padding: 15px; }
            .header { padding: 20px 15px; }
            .header h1 { font-size: 20px; }
            .form-inline { grid-template-columns: 1fr; }
            .btn { width: 100%; justify-content: center; }
            .content { padding: 20px; }
            table th, table td { padding: 10px; font-size: 13px; }
        }
    </style>
</head>
<body>
    <ul class="circles">
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
        <li></li>
    </ul>
    <div class="container">
        <div class="header">
            <a href="index.php" class="back-btn" title="Kembali"><i class="fa-solid fa-arrow-left"></i></a>
            <h1><i class="fa-solid fa-user-graduate"></i> Data Siswa</h1>
            <p>Kelola data siswa dan generate QR code</p>
        </div>

<div class="content">
            <h2><?php echo $data_edit ? '<i class="fa-solid fa-pen-to-square"></i> Edit Data Siswa' : '<i class="fa-solid fa-user-plus"></i> Tambah Siswa Baru'; ?></h2>
            
            <?php if (isset($success)): ?>
                <div class="alert alert-success"><?php echo $success; ?></div>
            <?php endif; ?>
            
            <?php if (isset($error)): ?>
                <div class="alert alert-error"><?php echo $error; ?></div>
            <?php endif; ?>

<form method="POST" class="form-inline">
                <?php if ($data_edit): ?>
                    <input type="hidden" name="id" value="<?php echo $data_edit['id']; ?>">
                <?php endif; ?>
                
                <div class="form-group">
                    <label>NIS:</label>
                    <input type="text" name="nis" required value="<?php echo $data_edit ? $data_edit['nis'] : ''; ?>">
                </div>
                <div class="form-group">
                    <label>Nama Lengkap:</label>
                    <input type="text" name="nama" required value="<?php echo $data_edit ? $data_edit['nama'] : ''; ?>">
                </div>
                <div class="form-group">
                    <label>Kelas:</label>
                    <select name="kelas" required>
                        <option value="">-- Pilih Kelas --</option>
                        <?php 
                        $kelas_options = ['A', 'B'];
                        foreach ($kelas_options as $val) {
                            $selected = ($data_edit && $data_edit['kelas'] == $val) ? 'selected' : '';
                            echo "<option value=\"$val\" $selected>$val</option>";
                        }
                        ?>
                    </select>
                </div>
                <div class="form-group">
                    <?php if ($data_edit): ?>
                        <button type="submit" name="update" class="btn btn-success" style="width: auto;"><i class="fa-solid fa-save"></i> Simpan</button>
                        <a href="siswa.php" class="btn btn-danger"><i class="fa-solid fa-times"></i> Batal</a>
                    <?php else: ?>
                        <button type="submit" name="tambah" class="btn btn-primary"><i class="fa-solid fa-plus"></i> Tambah</button>
                    <?php endif; ?>
                </div>
            </form>
        </div>

<div class="content">
            <h2><i class="fa-solid fa-list"></i> Daftar Siswa</h2>
            <div class="table-responsive">
            <table>
                <thead>
                    <tr>
                        <th width="60">No</th>
                        <th>NIS</th>
                        <th>Nama</th>
                        <th>Kelas</th>
                        <th>QR Code</th>
                        <th>Aksi</th>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    $current_kelas = '';
                    $no = 0;
                    while($siswa = $siswa_list->fetch_assoc()): 
                        // Cek jika kelas berubah untuk membuat header kelompok baru
                        if ($current_kelas != $siswa['kelas']) {
                            $current_kelas = $siswa['kelas'];
                            $no = 1; // Reset nomor urut untuk kelas baru
                            echo "<tr><td colspan='6' style='background-color: #e7f3ff; color: #118ab2; font-weight: 800; text-align: center; padding: 10px;'>KELAS " . $siswa['kelas'] . "</td></tr>";
                        } else {
                            $no++;
                        }
                    ?>
                        <tr>
                            <td style="text-align: center;"><?php echo $no++; ?></td>
                            <td><?php echo $siswa['nis']; ?></td>
                            <td><?php echo $siswa['nama']; ?></td>
                            <td style="text-align: center;">
                                <span style="background: #e7f3ff; color: #118ab2; padding: 5px 15px; border-radius: 20px; font-weight: bold; font-size: 12px;">
                                    <?php echo $siswa['kelas']; ?>
                                </span>
                            </td>
                            <td>
                                <?php if ($siswa['qr_code']): ?>
                                    <div style="display: flex; align-items: center; gap: 10px;">
                                        <img src="<?php echo $siswa['qr_code']; ?>" class="qr-thumb" alt="QR">
                                        <span style="font-size: 12px; color: #28a745; font-weight: bold;"><i class="fa-solid fa-check-circle"></i> Ada</span>
                                    </div>
                                <?php else: ?>
                                    <span style="color: #dc3545; font-size: 12px; font-weight: bold;"><i class="fa-solid fa-times-circle"></i> Belum ada</span>
                                <?php endif; ?>
                            </td>
                            <td>
                                <div class="action-buttons">
                                    <a href="siswa.php?edit=<?php echo $siswa['id']; ?>" 
                                       class="btn btn-warning btn-small" title="Edit" style="background: linear-gradient(to right, #ffd166, #ff9f43); color: white; border: none;">
                                        <i class="fa-solid fa-pen"></i>
                                    </a>
                                    <a href="siswa.php?hapus=<?php echo $siswa['id']; ?>" 
                                       class="btn btn-danger btn-small" title="Hapus" style="background: linear-gradient(to right, #ef476f, #ff6b6b); color: white; border: none;"
                                       onclick="return confirm('Yakin hapus siswa ini? Data absensi terkait juga akan terhapus.')">
                                        <i class="fa-solid fa-trash"></i>
                                    </a>
                                </div>
                            </td>
                        </tr>
                    <?php endwhile; ?>
                </tbody>
            </table>
            </div>
        </div>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: siswa.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation