PHP Classes
Icontem

Class: TbsSQL


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of Skrol29  >  TbsSQL  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description   Freshmeat project  
  Rate classes User ratings   Applications   Files Files  

  • Supplied by:

    Picture of Skrol29
    Name: Skrol29 <e-mail contact>
    Published packages: 3
    Country: France France - PHP jobs in France
    Home page: http://www.skrol29.com/
    Age: ???
    All time rank: 189
    Week rank: 233

    Browse this author's classes

  • Groups:

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

  • Detailed description:

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

    -> You have only one file to install for each Database type.
    -> You can escape values to prevent from SQL injection and merges them in the SQL statement in one shot.
    -> Thus there is no more complicated builds for your SQL statements.
    -> It can aslo deleted PHP connection variables after making the connection.

    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.

  • Freshmeat project:

    Project record: tbssql
    Popularity score: 53.33 (0.09%)
    Popularity rank: 37,637 (PHP Classes: 288)
    Vitality score: 1.14 (0.00%)
    Rating: Not yet rated Please rate this class in Freshmeat

  • User ratings:

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

  • Applications that use this class:

    Link Description
    TBS Forum a forum application
    Add link image If you know an application of this package, send a message to the author to add a link here.

  • 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
    Plain text file tbssql_mysqli.php Class Class for MySQLi 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.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products