TbsSQL is a small wrapper class for working with SQL databases within PHP scripts. It has few methods and two properties and it’s only one file per database for installation. Its most interesting feature is that it can protect and format values before merging them into the SQL statement. It has a cache feature, a trace mode, a debug console, and it can return data as arrays, standard objects, specific class objects, or clone objects. It can also delete PHP connection variables after making the connection.
| Tags | php classes Software Development Libraries SQL Database wrapper API Internet Web Dynamic Content MySQL postgresql odbc |
|---|---|
| Licenses | LGPL |
| Implementation | PHP SQL |
Recent releases


Release Notes: This new version brings new features and a few bug fixes. Oracle databases are supported. The method ConfInfo() was added to display configuration information at any time. New constants include TBSSQL_1MINUTE, TBSSQL_DISABLED, and TBSSQL_ALWAYS.


Release Notes: This version has major new features: it has a cache feature for data, includes strict SQL identification, and auto-cleans cache files. It can return data as arrays, standard objects, specific class objects, or clone objects. It has an enhanced trace mode and a new debug console.


Release Notes: Dabatase support was added for the ODBC generic type. Both MS ODBC and UnixODBC are supported. The run mode can be set when the connection is open and when the class is instantiated. Support for error messages for SQL Server connections was improved.


Release Notes: There is a new set of jokers that supports the NULL values for SQL. The method $Db->Mode can now work with constants instead of direct values. There is also a bugfix for managing several connections on MySQL.


Release Notes: This release can retrieve a list of keys/values. It can delete PHP connection variables after making the connection. MySQLi is now supported.