What are some best practices for efficiently outputting an entire MySQL table in PHP?

When outputting an entire MySQL table in PHP, it is important to efficiently fetch and display the data to avoid performance issues. One way to achieve this is by using the fetchAll() method in conjunction with a loop to iterate through the results and output them in a table format. 

<?php
// Connect to MySQL database
$pdo = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password');

// Fetch all rows from the table
$stmt = $pdo->query('SELECT * FROM table_name');
$rows = $stmt->fetchAll();

// Output table header
echo '<table>';
echo '<tr><th>Column 1</th><th>Column 2</th><th>Column 3</th></tr>';

// Output table rows
foreach ($rows as $row) {
    echo '<tr>';
    echo '<td>' . $row['column1'] . '</td>';
    echo '<td>' . $row['column2'] . '</td>';
    echo '<td>' . $row['column3'] . '</td>';
    echo '</tr>';
}

echo '</table>';
?>

Keywords

MySQL PHP database optimization performance

Related Questions