Getting It All - PHP

You can replace the Execute() method with the GetAll() method, which returns the complete resultset as a two-dimensional array of field-value pairs. This array can then be processed with a simple "foreach" or "for" loop. Consider the following example, which demonstrates:

<?php
// uncomment this to see plaintext output in your browser
// header("Content-Type: text/plain");
// include the ADODB library
include("adodb.inc.php");
// create an object instance
// configure library for a MySQL connection
$db = NewADOConnection("mysql");
// open connection to database
$db->Connect("localhost", "john", "doe", "db278") or die("Unable to
connect!");
// execute query
$query = "SELECT * FROM library";
$result = $db->GetAll($query) or die("Error in query: $query. " .
$db->ErrorMsg());
// clean up
$db->Close();
// uncomment the following line to see the returned array.
// print_r($result);
// iterate through resultset
// print column data in format TITLE - AUTHOR
foreach ($result as $row)
{
echo $row[1] . " - " . $row[2] . "\n";
}
// get and print number of rows in resultset
echo "\n[" . sizeof($result) . " rows returned]\n";
?>

In this case, the GetAll() method creates a two-dimensional array of result data, which looks something like this.

Array
(
[0] => Array
(
[0] => 14
[id] => 14
[1] => Mystic River
[title] => Mystic River
[2] => Dennis Lehane
[author] => Dennis Lehane
)
[1] => Array
(
[0] => 15
[id] => 15
[1] => For Kicks
[title] => For Kicks
[2] => Dick Francis
[author] => Dick Francis
)
[2] => Array
(
[0] => 16
[id] => 16
[1] => XML and PHP
[title] => XML and PHP
[2] => Vikram Vaswani
[author] => Vikram Vaswani
)
... and so on ...
)

This array can then be iterated over by a "foreach" loop, and the required values accessed as regular array elements. The size of the array is equivalent to the total number of rows in the resultset.

This method provides a useful alternative to the Execute() method, especially in situations when you would prefer to have the entire recordset available at once, rather than one row at a time.

>>> More PHP Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus