Common steps for displaying database table.

PHP MySQL database table to HTML table

<?php
require('/var/www/html/.../header.php');

        $active = 'yes';
        $query = "SELECT * FROM calendars WHERE active = ?";
        $stmt = $db->prepare($query);
        $stmt->bind_param('s', $active);
        $stmt->execute();
        $result = $stmt->get_result();
        
        echo '<table>';
        while ($row = $result->fetch_row()) {
            echo '<tr>';
            foreach($row as $columnValue){
                echo '<td><p>'.$columnValue.'</p></td>';
            }
            echo '</tr>';
        }
        echo '</table>';

        $result->close();
        $stmt->close();

require('/var/www/html/.../footer.php');
?>