The TbsSQL trumps are:- simple to use, easy to install (only one class), few methods an properties
- placeholders for merging values in one shot
- return data as array, standard objects, specific class objects or clone objects
- a simple cache feature with strict SQL identification (unlike ezSQL)
- a trace mode, and a debug console
- recognized by the TinyButStrong template engine
TbsSQL is available for the following databases:
- MySQL
- MySQLi
- SQL-Server (via Ms ODBC or UnixODBC)
- PostgreSQL (version 7.2 or higher)
- ODBC Generic (
available since TbsSQL version 2.6)
- Oracle (
available since TbsSQL version 3.1)
示例:
$id = 29; $name = "boby"; $Db->Execute('UPDATE table1 SET name=@2@ WHERE (id=%1%)', $id, $name);
项目主页:http://www.open-open.com/lib/view/home/1357823136792