This is my first php program!

196
|
Chapter 8: Databases
Storing the row
The
fetchInto( )
method also gets the next row, but stores it into the array variable
passed as a parameter:
$success = $result->fetchInto(
array
, [
mode
]);
Like
fetchRow( )
,
fetchInto( )
returns
NULL
if there is no more data, or
DB_ERROR
if an
error occurs.
The idiom to process all results looks like this with
fetchInto( )
:
while ($success = $result->fetchInto($row)) {
if (DB::isError($success)) {
die($success->getMessage( ));
}
// do something with the row
}
Inside a row array
Just what are these rows that are being returned? By default, they’re indexed arrays,
where the positions in the array correspond to the order of the columns in the
returned result. For example:
$row = $result->fetchRow( );
if (DB::isError($row)) {
die($row->getMessage( ));
}
var_dump($row);
array(3) {
[0]=>
string(5) "Dr No"
[1]=>
string(4) "1962"
[2]=>
string(12) "Sean Connery"
}
You can pass a
mode
parameter to
fetchRow( )
or
fetchInto( )
to control the format of
the row array. The default behavior, shown previously, is specified with
DB_
FETCHMODE_ORDERED
.
The fetch mode
DB_FETCHMODE_ASSOC
creates an array whose keys are the column
names and whose values are the values from those columns:
$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
if (DB::isError($row)) {
die($row->getMessage( ));
}
var_dump($row);
array(3) {
["title"]=>
string(5) "Dr No"
["year"]=>
,ch08.16110 Page 196 Wednesday, March 13, 2002 11:44 AM

---

This is the Title of the Book, eMatter Edition
Copyright © 2002 O’Reilly & Associates, Inc. All rights reserved.