How to work with all the rows of a result set

      fetchAll() 
      // Returns an array for all of the rows in the result set.
      

      $query = "SELECT productCode, productName, listPrice
                FROM products
                WHERE categoryID = :category_id;"
      $statement = $db->prepare($query);
      $statement->bindValue(":category_id", $category_id);
      $statement->execute();
      $products = $statement->fetchAll();
      $statement->closeCursor();
      

      <!-- HTML code to begin a table goes here -->
      <?php foreach ($products as $product) { ?>
        <td><?php echo $product['productCode']; ?></td>
        <td><?php echo $product['productName']; ?></td>
        <td><?php echo $product['listPrice']; ?></td>
      </tr>
      <?php } ?>
      <!-- HTML code to end table goes here -->
      

Description

• When a PDOStatement object contains a result set, you can use the fetchAll() method to return an array that contains that result set. Then, you can use the closeCursor() method to close the connection to the database.
• To loop through the elements in an array, you can use a foreach statement to define a foreach loop that processes one element of the array each time through the loop.
• The second syntax for the foreach statement makes it easier to use the foreach statement with other control statements because it doesn’t require the use of braces.
• When you use the second syntax with other control statements, you code a colon after the clause that starts each control statement, and you end each control statement with an appropriate end statement. For example, you end an if statement with an endif statement.