<?php
// Koneksi ke database
$servername = "localhost"; // Ganti dengan hostname Anda (biasanya localhost)
$username = "root"; // Ganti dengan username database Anda
$password = "mypassword"; // Ganti dengan password database Anda
$dbname = "my_database"; // Ganti dengan nama database Anda

// Buat koneksi
$conn = new mysqli($servername, $username, $password, $dbname);

// Periksa koneksi
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}

// Ambil data dari database
$sql = "SELECT * FROM form_data";
$result = $conn->query($sql);

// Mulai menampilkan data
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Laporan Data Form</title>
    <style>
        table {
            width: 100%;
            border-collapse: collapse;
        }
        table, th, td {
            border: 1px solid black;
        }
        th, td {
            padding: 8px;
            text-align: left;
        }
        th {
            background-color: #f2f2f2;
        }
    </style>
</head>
<body>

<h1>Laporan Data Form</h1>

<table>
    <tr>
        <th>ID</th>
        <th>Pilih Opsi</th>
        <th>Tanggal</th>
        <th>Nama File</th>
    </tr>

    <?php
    // Cek apakah ada hasil
    if ($result->num_rows > 0) {
        // Menampilkan data setiap baris
        while ($row = $result->fetch_assoc()) {
            echo "<tr>";
            echo "<td>" . $row['id'] . "</td>";
            echo "<td>" . $row['dropdown'] . "</td>";
            echo "<td>" . $row['date'] . "</td>";
            echo "<td>" . $row['file_name'] . "</td>";
            echo "</tr>";
        }
    } else {
        echo "<tr><td colspan='4'>Tidak ada data ditemukan.</td></tr>";
    }
    ?>
</table>

</body>
</html>

<?php
// Tutup koneksi
$conn->close();
?>