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
  Info   View files View files (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2005-12-25 (8 years ago) RSS 2.0 feedNot enough user ratingsTotal: 766 All time: 4,044 This week: 1,735Up
Version License Categories  
dbinterface 1.0GNU Lesser General Publ...XML, Databases
Description Author  

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');

Picture of Alejandro Vidal Quiroga
Name: Alejandro Vidal Quiroga <contact>
Classes: 1 package by
Country: Argentina Argentina
Age: 34
All time rank: 243730 in Argentina Argentina
Week rank: 1812 Up21 in Argentina Argentina Up

  Files folder image Files  
File Role Description
Plain text file dbi.inc.php Class Main FIle

 Version Control Unique User Downloads Download Rankings  
 0%Total:766All time:4,044
 This week:0This week:1,735Up