Database Abstraction Layer for PHP https://www.adodb.org/dokuwiki/ 2026-05-16T22:32:17+00:00 https://www.adodb.org/dokuwiki/ https://www.adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2019-05-08T14:32:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:active_record&rev=1557325978&do=diff Fix this ADOdb Active Record Author Credit: John Lim Introduction ADOdb_Active_Record is an Object Relation Mapping (ORM) implementation using PHP. In an ORM system, the tables and rows of the database are abstracted into native PHP objects. This allows the programmer to focus more on manipulating the data and less on writing SQL queries. text/html 2016-02-28T16:24:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:adodb_stringmax&rev=1456676697&do=diff Maximum String Lengths From: ADOdb V5.21.0 The methods charMax() and textMax() return the maximum length of strings that can be inserted into metaType C and X fields. The following constants are defined to assist in their use: ---------- Constant text/html 2025-06-01T11:21:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:debug&rev=1748776884&do=diff Debug Mode Syntax $connection->debug = boolean|int; Description Enabling debug mode makes the driver return debugging information from both ADOdb and the PHP driver itself. The output includes the executed SQL statement with parameters, as well as error messages and backtrace information if there are problems. It is suitable for viewing in a browser (see text/html 2018-06-27T14:16:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:deprecated&rev=1530108984&do=diff Deprecated Functionality MySQL and Menus Connect to MySQL database agora, and generate a <select> menu from an SQL statement where the <option> captions are in the 1st column, and the value to send back to the server is in the 2nd column. include('adodb.inc.php'); # load code common to ADOdb $conn = &adoNewConnection('mysql'); # create a connection $conn->pConnect('localhost','userid','','agora');# connect to MySQL, agora db $sql = 'select CustomerName, CustomerID from customers'; $rs = $co… text/html 2018-06-27T14:18:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:error_handling&rev=1530109092&do=diff Error Handling In ADOdb Default Behaviour By default, errors in the execution of SQL statements are handled by the database driver that is being accessed by PHP. No errors are normally handled and it is necessary to query the last error code to see if there has been an error. This is done by use of the '@' PHP value, that causes errors in the statement to be ignored. text/html 2016-01-13T02:59:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:index&rev=1452653999&do=diff User Guide Pages in this namespace: * ADOdb & Oracle * ADOdb Active Record * Caching Result Sets * Debug Mode * Deprecated Functionality * Error Handling In ADOdb * Integer MetaTypes * Maximum String Lengths * Memcached Setup * Moving from MySQL to ADOdb * Stored Procedure Example * Tips on Writing Portable SQL Using ADOdb * Transaction Handling In ADOdb * User Guide text/html 2026-03-12T03:47:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:integer_metatypes&rev=1773287229&do=diff Integer MetaTypes Size Table Meta TypeTypeStorage SizeSigned RangeUnsigned RangeI1TINYINT1 byte-128 to 1270 to 255I2SMALLINT2 bytes-32,768 to 32,7670 to 65,535I4MEDIUMINT3 bytes-8,388,608 to 8,388,6070 to 16,777,215IINT / INTEGER4 bytes-2,147,483,648 to 2,147,483,647 text/html 2025-06-01T11:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:local_cache&rev=1748776885&do=diff Caching Result Sets Description System Requirements The directory where the queries are saved is controlled by the variable $ADODB_CACHE_DIR Default Cache Secs The parameter $cacheSecs sets the default value of the time in seconds that cached queries are saved. If not set then the value is 3600. It can be set via either a normal connection object or a DSN type connection configuration. text/html 2025-06-01T11:21:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:memcached&rev=1748776885&do=diff Memcached Setup Description This section describes connecting to an already configured Memcache server. Information about installation and configuration of Memcached servers can be found here. The Memcache Library There are 2 distinct PEAR modules for connecting to a text/html 2018-06-27T14:09:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:mysql_tutorial&rev=1530108543&do=diff Author Credit: John Lim Moving from MySQL to ADOdb You say eether and I say eyether, You say neether and I say nyther; Eether, eyether, neether, nyther - Let's call the whole thing off ! You like potato and I like po-tah-to, You like tomato and I like to-mah-to; text/html 2026-03-25T01:21:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:oracle_tutorial&rev=1774401694&do=diff This needs fixing ADOdb & Oracle Author Credit (c) 2004-2014 John Lim Description Using ADOdb with PHP and Oracle: an advanced tutorial Introduction Oracle is the most popular commercial database used with PHP. There are many ways of accessing Oracle databases in PHP. These include: text/html 2020-12-30T20:32:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:portable_sql&rev=1609360373&do=diff Tips on Writing Portable SQL Using ADOdb Author Credit: John Lim Introduction If you are writing an application that is used in multiple environments and operating systems, you need to plan to support multiple databases. This article is based on my experiences with multiple database systems, stretching from 4th Dimension in my Mac days, to the databases I currently use, which are: Oracle, FoxPro, Access, MS SQL Server and MySQL. Although most of the advice here applies to using SQL with Perl,… text/html 2026-03-24T16:52:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:stored_procedure&rev=1774371132&do=diff Stored Procedure Example Description This example shows the creation of a basic stored procedure and accessing it using ADOdb The Procedure This procedure uses the IBM DB2 SAMPLE database. It performs the following functions: * Accepts 2 input parameters, a 6 character keyword and 20 character name text/html 2020-08-26T08:09:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:transactions&rev=1598429374&do=diff Transaction Handling In ADOdb Overview There are 2 ways of overriding the default database transaction handling methods in ADOdb, Granular and Smart. Each way holds benefits but they cannot be mixed. Each method comprises a series of methods. * Granular transactions allow full control of individual commits text/html 2020-01-13T14:50:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:userguide:userguide_index&rev=1578927058&do=diff User Guide Index User Guide List Of Tutorials Basic Tasks Database Abstraction Using basic ADOdb commands to read data from and write back to the database ---------- Data Dictionary Basics How to obtain information about database fields, columns and tables ---------- Keys,Fields & Field Objects Understanding how to work with the most detailed level of data provided by ADOdb