What are potential pitfalls in generating a table with PHP to display bookings for multiple rooms in a hotel?

One potential pitfall in generating a table with PHP to display bookings for multiple rooms in a hotel is ensuring that the data is correctly organized and displayed in a clear and user-friendly manner. To solve this issue, you can use nested loops to iterate through the rooms and bookings, and populate the table accordingly. Additionally, make sure to include proper styling and formatting to enhance the readability of the table. 

<table>
    <tr>
        <th>Room Number</th>
        <th>Booking Date</th>
        <th>Guest Name</th>
    </tr>
    <?php
    // Sample data for demonstration purposes
    $bookings = [
        ['room_number' => 101, 'date' => '2022-01-15', 'guest_name' => 'John Doe'],
        ['room_number' => 102, 'date' => '2022-01-20', 'guest_name' => 'Jane Smith'],
        ['room_number' => 101, 'date' => '2022-01-25', 'guest_name' => 'Alice Johnson'],
    ];
    
    // Iterate through rooms and bookings to populate the table
    for ($i = 101; $i <= 105; $i++) {
        echo "<tr>";
        echo "<td>Room $i</td>";
        
        foreach ($bookings as $booking) {
            if ($booking['room_number'] == $i) {
                echo "<td>{$booking['date']}</td>";
                echo "<td>{$booking['guest_name']}</td>";
            }
        }
        
        echo "</tr>";
    }
    ?>
</table>

Keywords

SQL injection data validation HTML table foreach loop array manipulation

Related Questions