Database Abstraction Layer for PHP http://adodb.org/dokuwiki/ 2026-05-16T23:02:13+00:00 http://adodb.org/dokuwiki/ http://adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2016-03-15T13:27:48+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:basic_query&rev=1458048468&do=diff Establishing A Connection Start Of Lesson Key/Value Pairs A Basic Query The simplest way that ADOdb can retrieve data is through the getAll() method. This method reads the selected rows from the database into an array. Once retrieved, the data in the recordset is inserted into an array. $sql = "select * from employees"; $array = $db->getAll($sql); print_r($array); /* * Returns */ 0 => array('emp_no' => 1000, 'emp_name' => 'Joe Smith', 'hire_date' => '2014-01-12' … text/html 2016-03-15T16:31:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:establishing_connection&rev=1458059478&do=diff Start Of Lesson Start Of Lesson A Basic Query Establishing A Connection Before interacting with data, a connection needs to be first established to the database. The parameters required to connect to the database are the same as when using a direct PHP connection. For detailed information about connections, see text/html 2016-03-15T02:03:45+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:introduction&rev=1458007425&do=diff The Database Abstraction Layer This lesson shows the basic usage of the database abstraction layer Other Guides Reference Guide Include File Guide Writing Portable SQL Migrating MySQL applications to ADOdb Customizing Error Handling Stored Procedure Example Deprecated Functionality text/html 2021-02-21T12:45:42+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:key_value_pairs&rev=1613911542&do=diff A Basic Query Start Of Lesson Using The Execute Method Key/Value Pairs An Associative Array An often-used SQL construction is to read a table for a key/value pair. This can be used in creating Select Boxes, Radio groups etc. ADOdb contains a shortcut command getAssoc() to assist in the task. $sql = "select emp_no, emp_name from employees"; $array = $db->getAssoc($sql); print_r($array); /* * Returns */ array( 1000 =>'Joe Smith', 1001 =>'Fred Jones' 1002 => 'Arthur Dent' ); text/html 2016-03-20T15:48:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:record_insertion&rev=1458488918&do=diff Using Execute Start Of Lesson Inserting And Updating Records Inserting And Updating Records AutoExecute ADOdb provides a helper routine, autoExecute(). It simplifies the task of inserting and updating records by providing a structured, easy to understand methodology. Inserting A Record In order to insert a record, it is sufficient to know: text/html 2016-08-13T13:44:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:start_lesson&rev=1471095847&do=diff The Database Abstraction Layer Start Of Lesson Establishing A Connection 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: text/html 2020-01-02T11:03:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_abstraction:using_execute&rev=1577963026&do=diff Key/Value Pairs Start Of Lesson Inserting And Updating Records Using The Execute Method The command execute() provides complete control over the reading and writing of the data in the database. Reading Data When used to read the data, the executed command returns a Query Result (or RecordSet), which can be accessed and used to read the records individually.