PHP ezSQL Database Class

Overview

ezSQL is a class that makes it ridiculously easy to use mySQL, Oracle8, SQLite (PHP), within your PHP script. Includes lots of examples making it very easy to understand how to work with databases. ezSQL has excellent debug functions making it lightning-fast to see what’s going on in your SQL code. ezSQL can dramatically decrease development time and in most cases will streamline your code and make things run faster.

Features

• ezSQL is a widget that makes it ridiculously easy for you to use PHP-PDO, mySQL, Oracle8, InterBase/FireBird, PostgreSQL, SQLite (PHP), SQLite (C++) or MS-SQL database(s) within your PHP/C++ scripts (more db’s coming soon)
• 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
• It can dramatically decrease development time and in most cases will streamline your code and make things run faster as well as making it very easy to debug and optimise your database queries.
• Works with Smarty templating language
• It is a small class and will not add very much overhead to your website.

Download

Download ezSQL completely Free from the download link at the top of this page, also check out EZ Results Paging Class ezSQL’s sister class that makes result paging a snip.
Important Note!
For Inerbase/Firebase, PostgreSQL, SQLite (C++), MS-SQL database(s) download version 1.26. Or, even better, help port ezSQL to version two.