One Hat Cyber Team

Your IP : 216.73.216.186

Server IP : 88.222.243.226

Server : Linux in-mum-web1837.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64

Server Software : LiteSpeed

PHP Version : 8.2.28

Buat File | Buat Folder

View File Name : reviews-page.php

<?php
// Database connection
include 'admin/connection.inc.php';

// Fetch all reviews from the reviews table
$sql = "SELECT id, user_name, product_name, rating, review_content, review_date, status FROM reviews";
$result = $conn->query($sql);
?>

<h3>Reviews</h3>
<table class="table">
    <thead>
        <tr>
            <th>ID</th>
            <th>User Name</th>
            <th>Product Name</th>
            <th>Rating</th>
            <th>Review Content</th>
            <th>Review Date</th>
            <th>Status</th>
        </tr>
    </thead>
    <tbody>
        <?php
        // Check if there are any reviews
        if ($result->num_rows > 0) {
            // Loop through each row and display the review data
            while ($row = $result->fetch_assoc()) {
                echo "<tr>
                    <td>" . $row['id'] . "</td>
                    <td>" . $row['user_name'] . "</td>
                    <td>" . $row['product_name'] . "</td>
                    <td>" . $row['rating'] . " ⭐</td>
                    <td>" . $row['review_content'] . "</td>
                    <td>" . $row['review_date'] . "</td>
                    <td>" . ucfirst($row['status']) . "</td>
                </tr>";
            }
        } else {
            echo "<tr><td colspan='7'>No reviews found</td></tr>";
        }
        ?>
    </tbody>
</table>

<?php
// Close the connection
$conn->close();
?>