This is my first php program!

Advanced Database Techniques
|
199
The
executeMultiple( )
method takes a two-dimensional array of values to insert:
$responses = $db->executeMultiple(
compiled
,
values
);
The
values
array must be numerically indexed from 0 and have values that are arrays
of values to insert. The compiled query is executed once for every entry in
values
,
and the query responses are collected in
$responses
.
A better way to write the movie-insertions code is:
$movies = array(array('Dr No', 1962),
array('Goldfinger', 1965),
array('Thunderball', 1965));
$compiled = $q->prepare('INSERT INTO movies (title,year) VALUES (?,?)');
$db->insertMultiple($compiled, $movies);
Shortcuts
PEAR DB provides a number of methods that perform a query and fetch the results
in one step:
getOne( )
,
getRow( )
,
getCol( )
,
getAssoc( )
, and
getAll( )
. All of these
methods permit placeholders.
The
getOne( )
method fetches the first column of the first row of data returned by an
SQL query:
$value = $db->getOne(
SQL
[,
values
]);
For example:
$when = $db->getOne("SELECT avg(year) FROM movies");
if (DB::isError($when)) {
die($when->getMessage( ));
}
echo "The average James Bond movie was made in $when";
The average James Bond movie was made in 1977
The
getRow( )
method returns the first row of data returned by an SQL query:
$row = $db->getRow(
SQL
[,
values
]]);
This is useful if you know only one row will be returned. For example:
list($title, $actor) = $db->getRow(
"SELECT movies.title,actors.name FROM movies,actors
WHERE movies.year=1977 AND movies.actor=actors.id");
echo "($title, starring $actor)";