Looping directly over a SELECT query

…A really nice feature of PDO, is that you can loop…directly over a select query, without needing to store the result first.…I've got open pdo_loop.php, which you can find in…the Chapter 02 > 02_03 folder, of the exercise files.…The code on line three, includes the database…connection we created in the previous movie, and…the HTML contains a table, that'll be used to display the results of a select query.…

So, let's create that query, we'll create it…on the line after including the database connection.…We'll save it as SQL.…And, it will be select, name, meaning,…gender, from names, and then we'll have a little order…clause to it, so order by name.…And instead of submitting this query to the database and storing the result,…we can get direct access to each row, in a for each loop.…

So let's create that for each loop.…We need to go down into the HTML part of the…page, create a new line between the two rows on line 29.…Needs to be a php block.…And in there we'll have a for reach loop.…We use the data base connection.…