Database abstraction in PHP

February 25th, 2007 by Leonid Mamchenkov

If you often interact with databases from your PHP scripts, consider using ezSQL. It is a database abstraction layer, somewhat similar to Perl’s Class::DBI.  Here is a quote from the web site:

It is one php file that you include at the top of your script. Then, instead of using standard php database functions listed in the php manual, you use a much smaller (and easier) set of ezSQL  functions.

It automatically caches query results and allows you to use easy to understand functions to manipulate and extract them without causing extra server overhead.

It has excellent debug functions making it lightning-fast to see what’s going on in your SQL code.

Most ezSQL functions can return results as Objects, Associative Arrays, or Numerical Arrays.

Posted in Technology, Programming, Databases, PHP, Perl, MySQL | No Comments »