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

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: proses_update_dashboard.php

<?php
require_once 'koneksi.php';

// 1. Ambil dan sanitasi input
$deskripsi = mysqli_real_escape_string($conn, $_POST['deskripsi']);

// 2. Cek apakah dashboard sudah ada
$dashboard_result = mysqli_query($conn, "SELECT id FROM dashboard LIMIT 1");
if (!$dashboard_result) {
    die("Error: " . mysqli_error($conn));
}

// 3. Update atau buat dashboard baru
if (mysqli_num_rows($dashboard_result) > 0) {
    $row = mysqli_fetch_assoc($dashboard_result);
    $dashboard_id = $row['id'];
    mysqli_query($conn, "UPDATE dashboard SET deskripsi='$deskripsi' WHERE id=$dashboard_id");
} else {
    mysqli_query($conn, "INSERT INTO dashboard (deskripsi) VALUES ('$deskripsi')");
    $dashboard_id = mysqli_insert_id($conn);
}

// 4. Proses gambar baru (jika ada)
if (!empty($_FILES['gambar']['name'][0])) {
    
    // 4a. Hapus semua gambar lama terkait dashboard ini
    $old_images = mysqli_query($conn, "SELECT nama_file FROM dashboard_gambar WHERE dashboard_id=$dashboard_id");
    while ($old_img = mysqli_fetch_assoc($old_images)) {
        $file_path = 'uploads/' . $old_img['nama_file'];
        if (file_exists($file_path)) {
            unlink($file_path); // Hapus file fisik
        }
    }
    
    // 4b. Hapus record database gambar lama
    mysqli_query($conn, "DELETE FROM dashboard_gambar WHERE dashboard_id=$dashboard_id");
    
    // 4c. Upload gambar baru
    $allowed_ext = ['jpg', 'jpeg', 'png', 'gif', 'webp'];
    $max_size = 5 * 1024 * 1024; // 5MB
    
    foreach ($_FILES['gambar']['tmp_name'] as $key => $tmp_name) {
        // Skip jika error
        if ($_FILES['gambar']['error'][$key] !== UPLOAD_ERR_OK) continue;
        
        // Validasi file
        $file_name = $_FILES['gambar']['name'][$key];
        $file_size = $_FILES['gambar']['size'][$key];
        $ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
        
        if (!in_array($ext, $allowed_ext)) continue;
        if ($file_size > $max_size) continue;
        
        // Generate nama unik
        $new_name = uniqid('dash_') . '.' . $ext;
        $destination = 'uploads/' . $new_name;
        
        // Pindahkan file dan simpan ke database
        if (move_uploaded_file($tmp_name, $destination)) {
            mysqli_query($conn, 
                "INSERT INTO dashboard_gambar (dashboard_id, nama_file) 
                 VALUES ($dashboard_id, '$new_name')"
            );
        }
    }
}

mysqli_close($conn);
header("Location: dashboard_admin.php?update=success");
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: proses_update_dashboard.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation