Login   Register  
PHP Classes
elePHPant
Icontem

Class: TbsSQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Skrol29  >  TbsSQL  >  Download .tar.gz .zip  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: TbsSQL
Support forum Support forum
Base name: tbssql
Description: easy and powerfull tool for working with SQL
Related classes: , , ,
Version: 3.1
PHP version: 4.0.6
License: GNU Lesser General Public License (LGPL)
All time users: 466 users
All time rank: 4662
Week users: 0 users
Week rank: 2664
Picture of Skrol29
Author: Skrol29 <e-mail contact>
Packages: 6 Browse this author's classes Browse this author's classes
Country: France France - PHP jobs in France
Age: ???
All time rank: 19512 in France France
Week rank: 190 Up11 in France France Up


  Detailed description  
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.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes

  Freshmeat project   Rate classes User ratings   Applications   Files Files  

  Freshmeat project  
TbsSQL
Project record: tbssql
Popularity score: 36.19
Vitality score: 4.4

  User ratings  
There are not enough user ratings to display for this class.

  Applications that use this class  
Link Description
Inline manual Inline manual
TBS Forum get support for TbsSQL
Add link image If you know an application of this package, send a message to the author to add a link here.
  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)

Download all files: tbssql.tar.gz tbssql.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.