<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "pole_booking";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// Check if form submitted via POST method
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $diameter = $_POST['diameter'];  // Adjust according to your form field names
    $point = $_POST['point'];        // Adjust according to your form field names
    $pole_number = $_POST['poleNumber'];
    $requester_name = $_POST['requesterName'];
    $company = $_POST['company'];
    $date = $_POST['date'];
    $start_time = $_POST['startTime'];
    $end_time = $_POST['endTime'];

    // SQL query to insert data into database
    $sql = "INSERT INTO bookings (diameter, point, pole_number, requester_name, company, date, start_time, end_time) 
            VALUES ('$diameter', '$point', '$pole_number', '$requester_name', '$company', '$date', '$start_time', '$end_time')";

    if (mysqli_query($conn, $sql)) {
        // Redirect to the same page to prevent resubmission
        header("Location: " . $_SERVER['PHP_SELF']);
        exit();
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}

// Fetch all bookings data
$sql_select = "SELECT * FROM bookings";
$result = mysqli_query($conn, $sql_select);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>การจองเสาไฟฟ้า</title>
    <style>
        /* Your CSS styles */
    </style>
</head>
<body>
    <div class="container">
        <h2>ข้อมูลการจองเสาไฟฟ้า</h2>
        <?php
        if (mysqli_num_rows($result) > 0) {
            echo "<table>";
            echo "<tr><th>ID</th><th>Diameter</th><th>Point</th><th>Pole Number</th><th>Requester Name</th><th>Company</th><th>Date</th><th>Start Time</th><th>End Time</th></tr>";
            while($row = mysqli_fetch_assoc($result)) {
                echo "<tr>";
                echo "<td>".$row['id']."</td>";
                echo "<td>".$row['diameter']."</td>";
                echo "<td>".$row['point']."</td>";
                echo "<td>".$row['pole_number']."</td>";
                echo "<td>".$row['requester_name']."</td>";
                echo "<td>".$row['company']."</td>";
                echo "<td>".$row['date']."</td>";
                echo "<td>".$row['start_time']."</td>";
                echo "<td>".$row['end_time']."</td>";
                echo "</tr>";
            }
            echo "</table>";
        } else {
            echo "ไม่มีข้อมูลการจอง";
        }

        // Close connection
        mysqli_close($conn);
        ?>
        <br>
        <a href="index-admin.html">กลับหน้าแรก</a>
    </div>
</body>
</html>