Class: DBInterface
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Classes of Alejandro Vidal Quiroga | > | DBInterface | > | Download .tar.gz .zip | > |  Support forum |
> |  Blog |
> |   Latest changes |
||
|
| |||||||||||||||||||||||||||||||||||||||||||
| Detailed description | ||
| 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'); |
| Groups | ||
 |
XML | XML parsing and generation | View top rated classes |
|
Databases | Database management, accessing and searching | View top rated classes |
 User ratings |
Applications |  Files |
||||
No application links were specified for this class.
 If you know an application of this package, send a message to the author to add a link here.
|
|||||||||||||||
For more information send a message to :
info at phpclasses dot org.
info at phpclasses dot org.
| Copyright (c) Icontem 1999-2012 | PHP Classes | - PHP Class Scripts |
| PHP Book Reviews | - Reviews of books and other products |