News Feed
Sections




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

Lukas Smith's Blog:
MDB2 example
December 28, 2005 @ 06:35:15

Lukas Smith has an example of how to use his MDB2 package in one of his latest blog posts.

I just wanted to show case some of the new features in MDB2. I especially wanted to demo some PHP5 specific features. The following example just creates a table with an autoincrementing primary key column 'id', inserts some values, fetches the last inserted id and finally, after selecting those values and outputs them using an iterator, drops the table again...

The example should work with MySQL and PostgreSQL, but not with SQLite (due to a limitation in the SQLite API). The MDB2 library makes interfacing with the database nice and clean, using functions like prepare(), execute() and query() to do the hard work for you.

0 comments voice your opinion now!
mdb2 example create table insert fetch mdb2 example create table insert fetch


blog comments powered by Disqus

Similar Posts

MySQL Performance Blog: Integers in PHP, running with scissors, and portability

Ant Phillips' Blog: PHP/Groovy Bridge

Cal Evans: The PHP CachingIterator

Phil Sturgeon: Why PHP DateTime Rocks

Terry Chay's Blog: Clever HTTP


Community Events





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


interview introduction release laravel unittest podcast language developer wordpress api framework library install application series configure list community code symfony

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