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

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: aksi_luluskan_santri.php

<?php
session_start();
include 'koneksi.php';

if(!isset($_SESSION['status']) || $_SESSION['status'] != "login"){
	header("location:login.php?pesan=belum_login");
	exit;
}

$id = $_GET['id'];

// 1. Ambil data santri yang akan diluluskan
$stmt_select = $koneksi->prepare("SELECT nama, alamat FROM santri_aktif WHERE id = ?");
$stmt_select->bind_param("i", $id);
$stmt_select->execute();
$result = $stmt_select->get_result();
$santri = $result->fetch_assoc();

if ($santri) {
    $nama = $santri['nama'];
    $alamat = $santri['alamat'];
    $tahun_lulus = date('Y'); // Ambil tahun sekarang

// 2. Masukkan data ke tabel alumni, TERMASUK ID ASLI SANTRI
    $stmt_insert = $koneksi->prepare("INSERT INTO alumni (id, nama, alamat, tahun_mutakhorijin) VALUES (?, ?, ?, ?)");
    $stmt_insert->bind_param("issi", $id, $nama, $alamat, $tahun_lulus);
    
    if ($stmt_insert->execute()) {
        // 3. Jika berhasil, hapus data dari tabel santri_aktif
        $stmt_delete = $koneksi->prepare("DELETE FROM santri_aktif WHERE id = ?");
        $stmt_delete->bind_param("i", $id);
        $stmt_delete->execute();

header("location:admin.php?page=santri&pesan=lulus_sukses"); // Pesan bisa disesuaikan
    } else {
        header("location:admin.php?page=santri&pesan=lulus_gagal");
    }
} else {
    header("location:admin.php?page=santri&pesan=lulus_gagal");
}

$koneksi->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: aksi_luluskan_santri.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation