Login   Register  
PHP Classes
elePHPant
Icontem

TbsSQL: easy and powerfull tool for working with SQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-10-11 (4 years ago) RSS 2.0 feedNot enough user ratingsTotal: 490 All time: 5,368 This week: 1,379Up
Version License PHP version Categories  
tbssql 3.1GNU Lesser General Publ...4.0.6Databases
Description Author  

TbsSQL is a very simple tool for your PHP applications that makes fast and easy to works with SQL.

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
- Oracle

The examples below:

// Retrieve a single value
$Db->GetVal('SELECT * FROM table1 WHERE (id=%1%) AND (type=%2%)', $id, $type);

// Retrieve a single row
$Db->GetRow('SELECT * FROM table1 WHERE (id=%1%) AND (type=%2%)', $id, $type);

// Retrieve all rows
$Db->GetRows('SELECT * FROM table1 WHERE (id=%1%) AND (type=%2%)', $id, $type);

// Retrieve a list of keys/values
$Db->GetList('SELECT id,name FROM table1 WHERE (id>%1%) AND (type=%2%)', $id, $type);

// Execute statements
$Db->Execute('UPDATE table1 SET type=%2% WHERE id=%1%', $id, $type);
$n = $Db->AffectedRows()
$x = $Db->LastRowId()

See the manual to get more information about other features and supported jokers for other types of item values.

Picture of Skrol29
Name: Skrol29 <contact>
Classes: 6 packages by
Country: France France
Age: ???
All time rank: 19914 in France France
Week rank: 83 Up6 in France France Up

  Files folder image Files  
File Role Description
Accessible without login Plain text file tbssql_demo.php Example Demo that display some info about your db
Accessible without login HTML file tbssql_help.html Doc. Help file
Accessible without login Plain text file tbssql_mysql.php Class Class for MySQL databases
Accessible without login Plain text file tbssql_mysqli.php Class Class for MySQLi databases
Accessible without login Plain text file tbssql_odbc.php Class Class for ODBC generic databases
Accessible without login Plain text file tbssql_oracle.php Class Class for Oracle databases
Accessible without login Plain text file tbssql_postgresql.php Class Class for PostgreSql databases
Accessible without login Plain text file tbssql_sqlserver_odbc.php Class Class for Microsoft SQL Server databases (via Odbc)

 Version Control Unique User Downloads Download Rankings  
 0%Total:490All time:5,368
 This week:0This week:1,379Up