Login   Register  
PHP Classes
elePHPant
Icontem

DBInterface: SQL Database abstraction layer

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Alejandro Vidal Quiroga
Name: Alejandro Vidal Quiroga <contact>
Classes: 1 package by
Country: Argentina Argentina
Age: 34
All time rank: 242730 in Argentina Argentina
Week rank: 1790 Up22 in Argentina Argentina Up


  Detailed description   Download Download .zip .tar.gz  
This class can be used a SQL database abstraction layer.

It provides a single interface to access several types of SQL databases from the same class. Currently it supports MySQL, PostgreSQL, Interbase and Microsoft SQL server.

It can establish connections to the database server, execute SQL queries, retrieve query results, begin and end transactions, build and execute common types of SQL queries from a list of parameters, generate XML from query results, etc..

The values are retrived from global variables, you only must enter the name. If you want enter the entire format you can do it.

Notice: the field and the global variable must have the same name.

Example:

// In your config file
$CFG_SQL_db = 'dbname';
$CFG_SQL_usuario = 'user';
$CFG_SQL_clave = 'password';
$CFG_SQL_server = 'localhost';
$CFG_SQL_tipo = 'mysql';


// Mysql Code
$dbi = DBI::select('table','field1,field2',"field1 = '$value'");
while($record = $dbi->fetch_object() )
{
echo "Field1: $record->field1";
}

// PostgreSQL
$dbi = DBI::select('table','field1,field2',"field1 = '$value'");
while($record = $dbi->fetch_object() )
{
echo "Field1: $record->field1";
}

// XML Dump
$dbi = new DBI();
echo $dbi->XMLDump('select * from table', 'Records');


// Upload Images
// View Code
<input type="file" name="picture"/>


// Application code (the table has a field named picture with blob type)
dbi::insert('table','picture::blob');

  Classes of Alejandro Vidal Quiroga  >  DBInterface  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: DBInterface
Base name: dbinterface
Description: SQL Database abstraction layer
Version: -
PHP version: -
License: GNU Lesser General Public License (LGPL)
All time users: 766 users
All time rank: 4021
Week users: 0 users
Week rank: 1735 Equal
 
  Groups   Rate classes User ratings   Applications   Files Files  

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


  User ratings  
Not enough user ratings

  Applications that use this package  
No pages of applications that use this class were specified.
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
Plain text file dbi.inc.php Class Main FIle

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