ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:userguide:learn_abstraction:start_lesson

Introduction

ADOdb is a Database Abstraction Layer that allows the writing of database independent SQL statements. It does this by placing a layer of generic statement execution code between the programmer and the PHP database-specific access commands. This allows the writing of portable SQL code that can access multiple databases. For example the following database specific statements:

MySQL         mysqli_execute
Oracle        oci_execute
SQL Server    mssql_execute

can all be replaced by a single ADOdb replacement execute(). In addition, ADOdb provides a number of shortcut commands to commonly used SQL syntax.

ADOdb is not a replacement for the PHP database driver, which must be installed and correctly configured. If it is not, ADOdb will immediately issue an error message Driver Not Installed when a connection is attempted. The best way to debug the problems is to bypass ADOdb completely and work on establishing a connection with the database directly through the PHP level driver. Once the connection is established that way, ADOdb should work correctly. There are many reasons why the driver cannot connect. The best place to obtain help is on sites like StackOverflow and database manufacturers forums

v5/userguide/learn_abstraction/start_lesson.txt · Last modified: 2016/08/13 15:44 by mnewnham