What are the best practices for collecting query results in an array and displaying them in a table format using PHP and HTML?

When collecting query results in an array and displaying them in a table format using PHP and HTML, it is important to properly iterate through the array and generate the table rows dynamically. This can be achieved by using a foreach loop to loop through the query results array and outputting the data within HTML table row tags.

&lt;?php
// Assuming $queryResults is the array containing the query results

echo &#039;&lt;table&gt;&#039;;
echo &#039;&lt;tr&gt;&lt;th&gt;Column 1&lt;/th&gt;&lt;th&gt;Column 2&lt;/th&gt;&lt;th&gt;Column 3&lt;/th&gt;&lt;/tr&gt;&#039;;

foreach ($queryResults as $result) {
    echo &#039;&lt;tr&gt;&#039;;
    echo &#039;&lt;td&gt;&#039; . $result[&#039;column1&#039;] . &#039;&lt;/td&gt;&#039;;
    echo &#039;&lt;td&gt;&#039; . $result[&#039;column2&#039;] . &#039;&lt;/td&gt;&#039;;
    echo &#039;&lt;td&gt;&#039; . $result[&#039;column3&#039;] . &#039;&lt;/td&gt;&#039;;
    echo &#039;&lt;/tr&gt;&#039;;
}

echo &#039;&lt;/table&gt;&#039;;
?&gt;

Keywords

PHP HTML query results array table format

What are the best practices for collecting query results in an array and displaying them in a table format using PHP and HTML?

Keywords

Related Questions