This is a base class for implementing an SQL database access abstraction.
It provides an easy way to deal with databases. it will escape your values by using smart question marks parameters in conditions strings, return most of result in php array instead of resource result set (but you still can access the resource if you really want it) and will assist you in most common databases operation such as establishing database connections, opening a database, quoting a string value, executing a query, retrieving query results as an array, listing the database tables, get the keys of a table, optimizing a table, retrieving the last error that occurred, etc..
It also permit to work on multiple databases and to get unique instances of database connection in a simple way "db::getInstance()"
It also include a class dbProfiler to help you profiling your queries. |