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.88 TB

🔧 Quick Actions

✏️ Editing: kelola_berita.php

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

// Handle form submissions
if ($_POST) {
    if (isset($_POST['action'])) {
        $action = $_POST['action'];
        
        if ($action == 'add') {
            $judul = mysqli_real_escape_string($conn, $_POST['judul']);
            $isi = mysqli_real_escape_string($conn, $_POST['isi']);
            $tanggal = $_POST['tanggal'];
            
            // Handle file upload
            $gambar = null;
            if (isset($_FILES['gambar']) && $_FILES['gambar']['error'] == 0) {
                $upload_dir = '../uploads/berita/';
                if (!file_exists($upload_dir)) {
                    mkdir($upload_dir, 0777, true);
                }
                
                $file_extension = pathinfo($_FILES['gambar']['name'], PATHINFO_EXTENSION);
                $filename = 'berita_' . time() . '.' . $file_extension;
                $upload_path = $upload_dir . $filename;
                
                if (move_uploaded_file($_FILES['gambar']['tmp_name'], $upload_path)) {
                    $gambar = $filename;
                }
            }
            
            $query = "INSERT INTO berita (judul, isi, gambar, tanggal) VALUES (?, ?, ?, ?)";
            $stmt = $conn->prepare($query);
            $stmt->bind_param("ssss", $judul, $isi, $gambar, $tanggal);
            
            if ($stmt->execute()) {
                $message = "Berita berhasil ditambahkan!";
                $message_type = "success";
            } else {
                $message = "Error: " . $conn->error;
                $message_type = "danger";
            }
        }
        
        if ($action == 'edit') {
            $id = $_POST['id'];
            $judul = mysqli_real_escape_string($conn, $_POST['judul']);
            $isi = mysqli_real_escape_string($conn, $_POST['isi']);
            $tanggal = $_POST['tanggal'];
            
            // Handle file upload
            $gambar_update = "";
            if (isset($_FILES['gambar']) && $_FILES['gambar']['error'] == 0) {
                $upload_dir = '../uploads/berita/';
                if (!file_exists($upload_dir)) {
                    mkdir($upload_dir, 0777, true);
                }
                
                $file_extension = pathinfo($_FILES['gambar']['name'], PATHINFO_EXTENSION);
                $filename = 'berita_' . time() . '.' . $file_extension;
                $upload_path = $upload_dir . $filename;
                
                if (move_uploaded_file($_FILES['gambar']['tmp_name'], $upload_path)) {
                    $gambar_update = ", gambar = '$filename'";
                }
            }
            
            $query = "UPDATE berita SET judul = ?, isi = ?, tanggal = ? $gambar_update WHERE id = ?";
            $stmt = $conn->prepare($query);
            $stmt->bind_param("sssi", $judul, $isi, $tanggal, $id);
            
            if ($stmt->execute()) {
                $message = "Berita berhasil diperbarui!";
                $message_type = "success";
            } else {
                $message = "Error: " . $conn->error;
                $message_type = "danger";
            }
        }
        
        if ($action == 'delete') {
            $id = $_POST['id'];
            
            // Get image filename to delete
            $query = "SELECT gambar FROM berita WHERE id = ?";
            $stmt = $conn->prepare($query);
            $stmt->bind_param("i", $id);
            $stmt->execute();
            $result = $stmt->get_result();
            $row = $result->fetch_assoc();
            
            if ($row['gambar'] && file_exists('../uploads/berita/' . $row['gambar'])) {
                unlink('../uploads/berita/' . $row['gambar']);
            }
            
            $query = "DELETE FROM berita WHERE id = ?";
            $stmt = $conn->prepare($query);
            $stmt->bind_param("i", $id);
            
            if ($stmt->execute()) {
                $message = "Berita berhasil dihapus!";
                $message_type = "success";
            } else {
                $message = "Error: " . $conn->error;
                $message_type = "danger";
            }
        }
    }
}

// Get all berita with pagination
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$search = isset($_GET['search']) ? mysqli_real_escape_string($conn, $_GET['search']) : '';
$where_clause = $search ? "WHERE judul LIKE '%$search%' OR isi LIKE '%$search%'" : '';

// Count total records
$count_query = "SELECT COUNT(*) as total FROM berita $where_clause";
$count_result = $conn->query($count_query);
$total_records = $count_result->fetch_assoc()['total'];
$total_pages = ceil($total_records / $limit);

// Get berita data
$query = "SELECT * FROM berita $where_clause ORDER BY created_at DESC LIMIT $limit OFFSET $offset";
$berita_result = $conn->query($query);
?>

<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-newspaper text-primary"></i>
                    Kelola Berita
                </h1>
                <div class="btn-toolbar mb-2 mb-md-0">
                    <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#addBeritaModal">
                        <i class="fas fa-plus"></i>
                        Tambah Berita
                    </button>
                </div>
            </div>

<?php if (isset($message)): ?>
                <div class="alert alert-<?php echo $message_type; ?> alert-dismissible fade show" role="alert">
                    <?php echo $message; ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
            <?php endif; ?>

<div class="card mb-4">
                <div class="card-body">
                    <form method="GET" class="row g-3">
                        <div class="col-md-8">
                            <input type="text" class="form-control" name="search" placeholder="Cari berita..." value="<?php echo htmlspecialchars($search); ?>">
                        </div>
                        <div class="col-md-4">
                            <button type="submit" class="btn btn-outline-primary">
                                <i class="fas fa-search"></i>
                                Cari
                            </button>
                            <a href="kelola_berita.php" class="btn btn-outline-secondary">
                                <i class="fas fa-times"></i>
                                Reset
                            </a>
                        </div>
                    </form>
                </div>
            </div>

<div class="card shadow">
                <div class="card-header py-3">
                    <h6 class="m-0 font-weight-bold text-primary">Daftar Berita</h6>
                </div>
                <div class="card-body">
                    <?php if ($berita_result->num_rows > 0): ?>
                        <div class="table-responsive">
                            <table class="table table-bordered table-hover">
                                <thead class="table-light">
                                    <tr>
                                        <th>No</th>
                                        <th>Gambar</th>
                                        <th>Judul</th>
                                        <th>Tanggal</th>
                                        <th>Dibuat</th>
                                        <th>Aksi</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php 
                                    $no = $offset + 1;
                                    while ($row = $berita_result->fetch_assoc()): 
                                    ?>
                                        <tr>
                                            <td><?php echo $no++; ?></td>
                                            <td>
                                                <?php if ($row['gambar'] && file_exists('../uploads/berita/' . $row['gambar'])): ?>
                                                    <img src="../uploads/berita/<?php echo $row['gambar']; ?>" alt="Gambar" class="img-thumbnail" style="max-width: 60px; max-height: 60px;">
                                                <?php else: ?>
                                                    <div class="bg-light d-flex align-items-center justify-content-center" style="width: 60px; height: 60px;">
                                                        <i class="fas fa-image text-muted"></i>
                                                    </div>
                                                <?php endif; ?>
                                            </td>
                                            <td>
                                                <strong><?php echo htmlspecialchars($row['judul']); ?></strong>
                                                <br>
                                                <small class="text-muted">
                                                    <?php echo substr(strip_tags($row['isi']), 0, 100) . '...'; ?>
                                                </small>
                                            </td>
                                            <td><?php echo date('d M Y', strtotime($row['tanggal'])); ?></td>
                                            <td><?php echo date('d M Y H:i', strtotime($row['created_at'])); ?></td>
                                            <td>
                                                <button type="button" class="btn btn-sm btn-info" onclick="editBerita(<?php echo htmlspecialchars(json_encode($row)); ?>)">
                                                    <i class="fas fa-edit"></i>
                                                </button>
                                                <button type="button" class="btn btn-sm btn-danger" onclick="deleteBerita(<?php echo $row['id']; ?>, '<?php echo htmlspecialchars($row['judul']); ?>')">
                                                    <i class="fas fa-trash"></i>
                                                </button>
                                            </td>
                                        </tr>
                                    <?php endwhile; ?>
                                </tbody>
                            </table>
                        </div>

<?php if ($total_pages > 1): ?>
                            <nav aria-label="Page navigation">
                                <ul class="pagination justify-content-center">
                                    <li class="page-item <?php echo ($page <= 1) ? 'disabled' : ''; ?>">
                                        <a class="page-link" href="?page=<?php echo $page - 1; ?>&search=<?php echo urlencode($search); ?>">Previous</a>
                                    </li>
                                    
                                    <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                        <li class="page-item <?php echo ($page == $i) ? 'active' : ''; ?>">
                                            <a class="page-link" href="?page=<?php echo $i; ?>&search=<?php echo urlencode($search); ?>"><?php echo $i; ?></a>
                                        </li>
                                    <?php endfor; ?>
                                    
                                    <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                                        <a class="page-link" href="?page=<?php echo $page + 1; ?>&search=<?php echo urlencode($search); ?>">Next</a>
                                    </li>
                                </ul>
                            </nav>
                        <?php endif; ?>
                    <?php else: ?>
                        <div class="text-center py-4">
                            <i class="fas fa-newspaper fa-3x text-muted mb-3"></i>
                            <p class="text-muted">Belum ada berita yang ditambahkan</p>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </main>
    </div>
</div>

<div class="modal fade" id="addBeritaModal" tabindex="-1" aria-labelledby="addBeritaModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="addBeritaModalLabel">Tambah Berita</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" enctype="multipart/form-data">
                <div class="modal-body">
                    <input type="hidden" name="action" value="add">
                    
                    <div class="mb-3">
                        <label for="judul" class="form-label">Judul Berita *</label>
                        <input type="text" class="form-control" id="judul" name="judul" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="isi" class="form-label">Isi Berita *</label>
                        <textarea class="form-control" id="isi" name="isi" rows="5" required></textarea>
                    </div>
                    
                    <div class="mb-3">
                        <label for="tanggal" class="form-label">Tanggal *</label>
                        <input type="date" class="form-control" id="tanggal" name="tanggal" value="<?php echo date('Y-m-d'); ?>" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="gambar" class="form-label">Gambar</label>
                        <input type="file" class="form-control" id="gambar" name="gambar" accept="image/*">
                        <div class="form-text">Format: JPG, JPEG, PNG. Maksimal 2MB.</div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                    <button type="submit" class="btn btn-primary">Simpan</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="editBeritaModal" tabindex="-1" aria-labelledby="editBeritaModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editBeritaModalLabel">Edit Berita</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" enctype="multipart/form-data">
                <div class="modal-body">
                    <input type="hidden" name="action" value="edit">
                    <input type="hidden" name="id" id="edit_id">
                    
                    <div class="mb-3">
                        <label for="edit_judul" class="form-label">Judul Berita *</label>
                        <input type="text" class="form-control" id="edit_judul" name="judul" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_isi" class="form-label">Isi Berita *</label>
                        <textarea class="form-control" id="edit_isi" name="isi" rows="5" required></textarea>
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_tanggal" class="form-label">Tanggal *</label>
                        <input type="date" class="form-control" id="edit_tanggal" name="tanggal" required>
                    </div>
                    
                    <div class="mb-3">
                        <label for="edit_gambar" class="form-label">Gambar</label>
                        <input type="file" class="form-control" id="edit_gambar" name="gambar" accept="image/*">
                        <div class="form-text">Kosongkan jika tidak ingin mengubah gambar. Format: JPG, JPEG, PNG. Maksimal 2MB.</div>
                        <div id="current_image"></div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                    <button type="submit" class="btn btn-primary">Update</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="deleteBeritaModal" tabindex="-1" aria-labelledby="deleteBeritaModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="deleteBeritaModalLabel">Konfirmasi Hapus</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <p>Apakah Anda yakin ingin menghapus berita "<span id="delete_judul"></span>"?</p>
                <p class="text-danger"><small>Tindakan ini tidak dapat dibatalkan.</small></p>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Batal</button>
                <form method="POST" style="display: inline;">
                    <input type="hidden" name="action" value="delete">
                    <input type="hidden" name="id" id="delete_id">
                    <button type="submit" class="btn btn-danger">Hapus</button>
                </form>
            </div>
        </div>
    </div>
</div>

function deleteBerita(id, judul) {
    document.getElementById('delete_id').value = id;
    document.getElementById('delete_judul').textContent = judul;
    new bootstrap.Modal(document.getElementById('deleteBeritaModal')).show();
}
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: kelola_berita.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation