|
|
|
http://php.weblogs.com/adodb
PHP's database access functions are not standardised. This creates a need for a database
class library to hide the differences between the different databases (encapsulate the
differences) so we can easily switch databases.
Requires PHP4. Based on the best ideas of PEAR, phpdb and Microsoft's ADO.
MySQL Usage:
include('adodb.inc.php'); include('tohtml.inc.php');
ADOLoadCode('mysql');
$conn = &ADONewConnection();
$conn->PConnect('localhost','userid','password','database');
$rs = $conn->Execute('select * from table');
rs2html($rs); /* recordset to html table */
Oracle Usage:
include('adodb.inc.php'); include('tohtml.inc.php');
ADOLoadCode('oracle');
$conn = &ADONewConnection();
$conn->PConnect('','scott','tiger');
$rs = $conn->Execute('select * from table');
rs2html($rs); /* recordset to html table */
Interbase Usage:
include('adodb.inc.php'); include('tohtml.inc.php');
ADOLoadCode('ibase');
$conn = &ADONewConnection();
$conn->PConnect('c:\ibase\employee.gdb','sysdba','masterkey');
$rs = $conn->Execute('select * from table');
rs2html($rs); /* recordset to html table */
|
|
| This is a class with functions that are taken from simple SQL statements.
I made it to have an easier connection between PHP3 and DBase files.
Categories : General SQL, PHP, PHP Classes, Databases | | | Dynamic WHERE CLAUSE depending on number of FORM FIELDS
Categories : ODBC, General SQL, PHP, Complete Programs, Databases | | | Recordset Class like ADO Recordset (plus DataBase Splitting feature) using ODBC functions
Categories : PHP Classes, ODBC, Databases, PHP | | | Writing Portable MySQL Code in PHP: Porting to Oracle, Microsoft SQL
Server, Sybase, Interbase, PostgreSQL and other databases using ADODB
class library.
Categories : MySQL, PHP, PHP Classes, ODBC, General SQL | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Powerful php/mysql Pagination for up to 6 URL Params
Categories : PHP, PHP Classes, Databases, MySQL, Navigation | | | The Ajax Tree view class fetches data from a db for the requested parent category id. The data is then stored in an array and converted into JSON (Javascript Object Notation) format. This format is then used by JavaScript for populating tree view.
Categories : PHP, PHP Classes, Java Script, AJAX, Databases | | | Password reminder
Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | MySQL Class to ease Database connectivity
Categories : MySQL, PHP Classes, Databases, PHP | | | A set of functions sitting on top of the abstraction layer that makes it a little easier to do SQL stuff. Documentation is within
Categories : Databases, ODBC, Complete Programs, PHP | | | Is there some possibility to link a database to an htaccess file, so that instead of having a passwd file you would have a database with DES-crypted password and username fields?
Categories : Authentication, PHP, General SQL, Databases | | | usercounter class
Categories : PHP, PHP Classes, Databases, MySQL, Environment Variables | | | MySQL Handler
Categories : PHP, Databases, MySQL, Classes and Objects, PHP Classes | | | PostGreSQL and MySQL 2 in 1 db Manager
Categories : PHP, PHP Classes, Databases, PostgreSQL, MySQL | | | Logs hits to any page which includes it. Automatically utilises page access information left behind by PHP/FI2.0.
Categories : Databases, PHP, mSQL, Databases | |
| | | | John Lim wrote :1232
The download url has changed to http://adodb.sourceforge.net/
| |
|
|
|
