Additional Methods for Using SQLite with PHP 5
(Page 1 of 5 )
Welcome to the concluding part of the series “Using SQLite with PHP 5.” As you’ll possibly know, PHP 5 comes equipped with a fully-featured RDBMS called SQLite that definitely can make your life as a PHP developer much easier. It's particularly helpful if you want to get rid of MySQL at least for a time while maintaining the data layer of your application completely isolated from the business logic.
Over the course of the second tutorial, I explained several methods that come packaged with the SQLite library and perform different tasks, such as counting the number of rows and fields contained within a specific result set, fetching one row at a time, working with unbuffered queries, and so forth.
If you’ve read the two previous articles that belong to this series (as I suppose you have), then I’m sure that you realize the great capabilities offered by SQLite. It's especially useful in those cases where you need to work with a decent RDBMS but don't need to appeal directly to the features offered by the popular MySQL server.
Well, at this point you may be thinking that you’ve learned everything about the cool methods included with SQLite, since the material that I provided you during the previous articles has certainly been abundant.
However, if you think that way, I’m afraid that you’re wrong. SQLite has some other methods that can be useful for performing all sort of clever tasks, including the definition of custom functions, finding the IDs of inserted rows, the creation of memory-based databases, and so on.
As you can see, the list of additional features offered by SQLite is really impressive. Therefore, in this last article of the series, I’ll be taking an in-depth look at them. This will complete our analysis of this excellent RDBMS integrated with PHP 5.
Are you ready to go over the last miles of this learning journey? Fine, let’s get started!
Next: Using the seek() and lastInsertRowid() methods >>
More PHP Articles
More By Alejandro Gervasio
