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/Estu/admin

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: view-testimoni.php

<?php
require_once '../config/db.php';

// Inisialisasi variabel
$success_message = $error_message = '';

// 1) Pagination setup dulu, sebelum output apa pun
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$records_per_page = 10;
$offset = ($page - 1) * $records_per_page;

// 2) Tangani toggle & redirect
if (isset($_GET['toggle'], $_GET['value'])) {
    $id  = (int) $_GET['toggle'];
    $new = (int) $_GET['value'];

$stmt = $conn->prepare("UPDATE testimoni SET is_visible = ? WHERE id = ?");
    $stmt->bind_param("ii", $new, $id);
    $stmt->execute();

header("Location: view-testimoni.php?page={$page}");
    exit;
}

// 3) Hitung pagination
$count_query  = "SELECT COUNT(*) as total FROM testimoni";
$count_result = $conn->query($count_query);
$total_rows   = $count_result->fetch_assoc()['total'];
$total_pages  = ceil($total_rows / $records_per_page);

// 4) Ambil data
$query  = "SELECT * FROM testimoni ORDER BY tanggal DESC LIMIT $offset, $records_per_page";
$result = $conn->query($query);
?>
<?php include '../admin/includes/header-admin.php'; ?>

<div class="container-fluid">
    <h1 class="mt-4 mb-4">Lihat Testimoni</h1>
    
    <?php if (!empty($success_message)): ?>
        <div class="alert alert-success"><?php echo $success_message; ?></div>
    <?php endif; ?>
    
    <?php if (!empty($error_message)): ?>
        <div class="alert alert-danger"><?php echo $error_message; ?></div>
    <?php endif; ?>
    
    <div class="card mb-4">
        <div class="card-header">
            <i class="fas fa-comments mr-1"></i>
            Daftar Testimoni Pengunjung
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                <div class="table-responsive">
                    <table class="table table-bordered table-hover">
                        <thead>
                            <tr>
                                <th width="5%">ID</th>
                                <th width="15%">Nama</th>
                                <th width="50%">Komentar</th>
                                <th width="15%">Tanggal</th>
                                <th width="15%">Aksi</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php while ($row = 
                             $result->fetch_assoc()): 
                             $visible = (int)$row['is_visible'];
                             $btnText = $visible ? 'Sembunyikan' : 'Tampilkan';
                             $btnClass = $visible ? 'btn-warning' : 'btn-success';?>
                                
                                <tr>
                                    <td><?php echo $row['id']; ?></td>
                                    <td><?php echo htmlspecialchars($row['nama']); ?></td>
                                    <td><?php echo htmlspecialchars($row['komentar']); ?></td>
                                    <td><?php echo date('d/m/Y H:i', strtotime($row['tanggal'])); ?></td>
                                    <td>
                                        <button class="btn btn-sm btn-danger" onclick="if (confirmDelete()) window.location.href = 'view-testimoni.php?delete=<?php echo $row['id']; ?>';">
                                           <i class="fas fa-trash"></i> Hapus
                                        </button>

</td>
                                    <td>
                                        <button class="btn btn-sm <?php echo $btnClass; ?>"
                                        onclick="if(confirm('Yakin ingin <?php echo strtolower($btnText); ?> testimoni ini?')) 
                                         window.location.href='view-testimoni.php?toggle=<?php echo $row['id']; ?>&value=<?php echo $visible ? 0 : 1; ?>&page=<?php echo $page; ?>';">
                                       <i class="fas fa-eye<?php echo $visible ? '-slash' : ''; ?>"></i> <?php echo $btnText; ?>
                                        </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="<?php echo ($page <= 1) ? '#' : '?page='.($page-1); ?>">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; ?>"><?php echo $i; ?></a>
                                </li>
                            <?php endfor; ?>
                            
                            <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                                <a class="page-link" href="<?php echo ($page >= $total_pages) ? '#' : '?page='.($page+1); ?>">Next</a>
                            </li>
                        </ul>
                    </nav>
                <?php endif; ?>
                
            <?php else: ?>
                <div class="alert alert-info">Belum ada testimoni dari pengunjung.</div>
            <?php endif; ?>
        </div>
    </div>
</div>

<?php include '../admin/includes/footer-admin.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-testimoni.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation