This is my first php program!

Advanced Database Techniques
|
197
string(4) "1962"
["name"]=>
string(12) "Sean Connery"
}
The
DB_FETCHMODE_OBJECT
mode turns the row into an object, with a property for each
column in the result row:
$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
if (DB::isError($row)) {
die($row->getMessage( ));
}
var_dump($row);
object(stdClass)(3) {
["title"]=>
string(5) "Dr No"
["year"]=>
string(4) "1962"
["name"]=>
string(12) "Sean Connery"
}
To access data in the object, use the
$object->property
notation:
echo "{$row->title} was made in {$row->year}";
Dr No was made in 1962
Finishing the result
A query result object typically holds all the rows returned by the query. This may
consume a lot of memory. To return the memory consumed by the result of a query
to the operating system, use the
free( )
method:
$result->free( );
This is not strictly necessary, as
free( )
is automatically called on all queries when
the PHP script ends.
Disconnecting
To force PHP to disconnect from the database, use the
disconnect( )
method on the
database object:
$db->disconnect( );
This is not strictly necessary, however, as all database connections are disconnected
when the PHP script ends.
Advanced Database Techniques
PEAR DB goes beyond the database primitives shown earlier; it provides several
shortcut functions for fetching result rows, as well as a unique row ID system and
separate prepare/execute steps that can improve the performance of repeated queries.
,ch08.16110 Page 197 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.