ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
<- v5:userguide:learn_abstraction:introduction|The Database Abstraction Layer ^ v5:userguide:learn_abstraction:introduction|Start Of Lesson ^ v5:userguide:learn_abstraction:establishing_connection|Establishing A Connection ->
~~NOTOC~~
====== 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 [[v5:reference:connection:execute|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