News Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Procurios Blog:
Syntactic Sugar for MySQLi Results using SPL Iterators
May 15, 2009 @ 11:14:31

From the Procurios blog there's a recent post looking at a method letting you use a foreach on the results from a MySQLi request - SPL Iterators.

Ever wondered why you can't use foreach() on MySQLi Results, and instead have to write less convenient while() loops with fetch_row? Actually, you can use foreach() on MySQLi Results. All it takes is some SPL Iterator magic.

The code examples show how to create an Iterator interface (with rewind, current, key, next and valid methods) to create a ResultIterator class for moving back and forth between the values in the result. This allows you to define the new Iterator object and use the foreach structure like you would a normal result set.

They also show how to bypass this whole problem by using a IteratorAggregate in an extension of the MySQLi interface.

0 comments voice your opinion now!
resultset mysqli spl tutorial iterator


DevShed:
Handling Result Sets and More with PDO Objects in PHP 5
June 04, 2007 @ 13:47:00

DevShed continues their series looking at using PDO objects in PHP with part two, a look at handling the result sets in your PHP5 code.

All in all, at this point you hopefully learned how to use some basic methods included with this PHP extension, but logically you may want to learn a few additional ones, so you can have a more polished picture of the overall functionality of the library in question. [...] I'm going to show you how to use the PDO extension to handle different database result sets in all sort of clever ways, in addition to performing some common tasks, like counting rows and columns as well.

He starts with an example of the best place to start - fetching the results set from the database backend. In these simple examples, use the prepare, execute and fetch functions to get the results. Taking it one step further, they move into the use of the fetchAll function to grab columns and rows in the results as well.

0 comments voice your opinion now!
php5 pdo resultset tutorial php5 pdo resultset tutorial



Community Events





Don't see your event here?
Let us know!


community install zendserver update library laravel release opinion podcast language symfony tips introduction interview framework deployment list series package api

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework