News Feed
Sections




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

Johannes Schluter's Blog:
MySQLi Resultset Iterator
June 22, 2009 @ 11:12:11

Johannes Schluter has posted a look at a handy little script that shows an interface between the returned MySQLi results and an SPL iterator.

When using MySQLi's multi_query to send queries which return multiple result sets you have to use a rather unintuitive API which can certainly be improved. Recently I sat down and cooked up a small improvement for that, being an iterator fan I, of course, had to use an iterator for that and implemented the following class.

The class extends the standard Iterator and provides the interfaces to work through the results of the query in your choice of Iterator-supporting looping structure. Example code for the class and its usage are both included.

0 comments voice your opinion now!
iterator result mysqli


blog comments powered by Disqus

Similar Posts

Kevin Schroeder's Blog: You want to do WHAT with PHP? Chapter 5

Thilanka Kaushalya's Blog: How to use Mysql Transactions with PHP

Colin Viebrock\'s Blog: MySQLi in PHPAdsNew 2.0.7

Chris Jones' Blog: PHP OCI8 and Oracle 11g DRCP Connection Pooling in Pictures

DevShed: Iterators in the Simplest Sense - Traversing Data Structures in PHP 5


Community Events





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


tool interview community library language series framework release opinion composer symfony laravel introduction podcast version conference voicesoftheelephpant security artisanfiles list

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