Home

Welcome to the ezsql wiki!

Click any of the links in the sidebar to view the documentation, or else head to the documentation page

About ezsql

ezSQL is a library/widget that makes it very fast and easy for you to use database(s) within your PHP scripts, supporting ( MySQL / PostgreSQL / Microsoft SQL Server / SQLite3), and the PDO equivalents.

• 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 and methods.
• 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, Numerical Arrays or Json Encoded.
• 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.
• It is a small class and will not add very much overhead to your website.

Note: It is assumed that you are familiar with PHP, basic Database concepts and basic SQL constructs.