PHP Classes

TbsSQL: easy and powerfull tool for working with SQL

Recommend this page to a friend!
  Info   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 494 All time: 5,856 This week: 794Up
Version License PHP version Categories
tbssql 3.1GNU Lesser Genera...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: 19213 in France France
Week rank: 91 Up5 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:494
This week:0
All time:5,856
This week:794Up