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

Free Space:

9.89 TB

🔧 Quick Actions

✏️ Editing: export_excel.php

<?php
// File export_excel.php
// Sertakan koneksi database
require_once '../../config/config.php';
require_once '../../config/database.php';
require_once '../../config/functions.php';

// Kondisi pencarian jika ada
$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$where = '';
if (!empty($search)) {
    $where = "WHERE nama_lengkap LIKE '%$search%' OR nisn LIKE '%$search%' OR asal_sekolah LIKE '%$search%'";
}

// Query untuk mengambil data
$query = "SELECT * FROM pendaftaran $where ORDER BY created_at DESC";
$result = mysqli_query($conn, $query);

// Set header untuk file Excel dengan format CSV untuk menghindari masalah keamanan
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="Data_Pendaftaran_Siswa_' . date('d-m-Y') . '.xls"');
header('Pragma: no-cache');
header('Expires: 0');
header('Cache-Control: max-age=0');

// Output file Excel
echo '
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Data Pendaftaran Siswa</title>
    <style>
        table {
            border-collapse: collapse;
            width: 100%;
        }
        th, td {
            border: 1px solid #000;
            padding: 5px;
        }
        th {
            background-color: #f2f2f2;
            font-weight: bold;
        }
    </style>
</head>
<body>
    <h2>Data Pendaftaran Siswa</h2>
    <p>Tanggal Export: ' . date('d/m/Y ') . '</p>
    
    <table>
        <thead>
            <tr>
                <th>No</th>
                <th>Nama Lengkap</th>
                <th>NISN</th>
                <th>Jurusan</th>
                <th>Asal Sekolah</th>
                <th>Status</th>
                <th>Jenis Kelamin</th>
                <th>Tanggal Lahir</th>
                <th>Email</th>
                <th>nomor_hp</th>
                <th>Tanggal Daftar</th>
            </tr>
        </thead>
        <tbody>';

// Tampilkan data
$no = 1;
while ($row = mysqli_fetch_assoc($result)) {
    // Tangani kolom yang mungkin tidak ada
    $nomor_hp = isset($row['nomor_hp']) ? htmlspecialchars($row['nomor_hp']) : '-';
    $jenis_kelamin = isset($row['jenis_kelamin']) ? htmlspecialchars($row['jenis_kelamin']) : '-';
    $tanggal_lahir = isset($row['tanggal_lahir']) ? date('d-m-Y', strtotime($row['tanggal_lahir'])) : '-';
    $email = isset($row['email']) ? htmlspecialchars($row['email']) : '-';
    
    echo '
        <tr>
            <td>' . $no++ . '</td>
            <td>' . htmlspecialchars($row['nama_lengkap']) . '</td>
            <td style="mso-number-format:\'@\';">' . htmlspecialchars($row['nisn']) . '</td>
            <td>' . htmlspecialchars($row['jurusan']) . '</td>
            <td>' . htmlspecialchars($row['asal_sekolah']) . '</td>
            <td>' . ucfirst($row['status']) . '</td>
            <td>' . $jenis_kelamin . '</td>
            <td>' . $tanggal_lahir . '</td>
            <td>' . $email . '</td>
            <td>' . $nomor_hp . '</td>
            <td>' . date('d-m-Y', strtotime($row['created_at'])) . '</td>
        </tr>';
}

echo '
        </tbody>
    </table>
</body>
</html>';

// Keluar dari skrip
exit();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_excel.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation