Home arrow PHP arrow Using Unbuffered Queries and More with SQLite with PHP 5

Using Unbuffered Queries and More with SQLite with PHP 5

Are you one of those PHP developers looking for a tight and powerful RDBMS, other than MySQL, in order to build your next database-driven website? Then hopefully your search is finished. Welcome to the second installment of the series ďUsing SQLite with PHP 5.Ē Comprised of three articles, this series walks you through the implementation of the most important methods that come bundled with SQLite and shows you how to use them with numerous practical examples.

  1. Using Unbuffered Queries and More with SQLite with PHP 5
  2. Working with unbuffered queries
  3. Counting rows and fields of database tables
  4. Analyzing more row-processing methods
By: Alejandro Gervasio
Rating: starstarstarstarstar / 2
December 11, 2006

print this article



As the patient reader that I think you are, youíll remember that over the first article I covered some of the most relevant methods included with SQLite. Many of them were focused on creating databases and tables, as well as running queries and fetching rows from a given result set. As you learned previously, SQLite is really easy to work with, as it boasts a fully-featured RDBMS system. This system is based primarily on the file system to create the corresponding database structure, although memory-based databases are also supported.

In addition to the handy features that you learned in the first article of the series, SQLite comes packaged with many more methods that can be truly helpful for working with unbuffered queries, counting and seeking rows, and finding insertion IDs. Even though the SQLite library has been integrated into a small package along with the PHP 5 distribution, Iím sure that youíve already realized its remarkable capabilities.

Taking into account the group of characteristics that I mentioned a few lines above, in this second tutorial of the series, Iíll be taking a look at some of them. This will give you a clearer idea of how to use them as part of your existing and -- why not? -- future PHP applications.

Indeed, the subject looks interesting, therefore letís no waste more time in preliminaries and continue discovering more handy methods included with SQLite. Letís get going!

>>> More PHP Articles          >>> More By Alejandro Gervasio

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: