How to work with the first row of a result set

fetch() 
// Returns an array for the next row in the result set. This array
// is indexed by both a string index for the column name and a numeric 
// index for the column position. If no array is available, this 
// method returns a FALSE value. 

closeCursor()
// Closes the cursor and frees the connection to the server so 
// other SQL statements may be issued.

$query = "SELECT productCode, productName, listPrice 
FROM products 
WHERE productID = :product_id";
$statement = $db->prepare($query);
$statement->bindValue(':product_id', $product_id);
$statement->execute();
$product = $statement->fetch();
$statement->closeCursor();

$product_code = $product['productCode'];
$product_name = $product['productName'];
$product_list_price = $product['listPrice'];

$product_code = $product[0];
$product_name = $product[1];
$product_list_price = $product[2];

Description

• An array can store one or more elements.You can use the fetch() method of a PDOStatement object to get an array for the first row (or next row) of a result set. Then, you can use column names or numeric indexes to access the data that’s stored in that row.
• To refer to the elements in an array, you use an index. If you use numeric indexes, 0 refers to the first element, 1 to the second element, and so on.
• You can use the fetch() method of a PDOStatement object to get an array for the first row (or next row) of a result set. Then, you can use column names or numeric indexes to access the data that’s stored in that row.
• Arrays were covered in chapter 11.