4 <title>ADODB Manual</title>
5 <meta charset="UTF-8" />
6 <style type="text/css">
8 body,td {font-family:Arial,Helvetica,sans-serif;font-size:11pt}
13 <body bgcolor="#FFFFFF">
15 <h3>ADOdb Library for PHP</h3>
17 <p>ADOdb is a suite of database libraries that allow you to connect to multiple
18 databases in a portable manner. Download from <a
19 href="http://php.weblogs.com/adodb">http://php.weblogs.com/adodb</a>.</p>
21 <li>The ADOdb documentation has moved to <a href="http://phplens.com/lens/adodb/docs-adodb.htm">docs-adodb.htm</a>.
22 This allows you to query, update and insert records using a portable API.
24 <li>The ADOdb data dictionary docs are at <a href="http://phplens.com/lens/adodb/docs-datadict.htm">docs-datadict.htm</a>.
25 This allows you to create database tables and indexes in a portable manner.
27 <li>The ADOdb database performance monitoring docs are at <a href="http://phplens.com/lens/adodb/docs-perf.htm">docs-perf.htm</a>.
28 This allows you to perform health checks, tune and monitor your database.
30 <li>The ADOdb database-backed session docs are at <a href="http://phplens.com/lens/adodb/docs-session.htm">docs-session.htm</a>.
32 <li>The ADOdb Date Time Library documentation to support dates outside the 32-bit range, at <a
33 href="http://php.weblogs.com/adodb_date_time_library">adodb_date_time_library</a>.
38 Make sure you are running PHP4.0.4 or later. Unpack all the files into a directory accessible by your webserver.
40 To test, try modifying some of the tutorial examples. Make sure you customize the connection settings correctly. You
44 include('adodb/adodb.inc.php');
46 $db = <b>ADONewConnection</b>($driver); # eg. 'mysql' or 'oci8'
48 $db-><b>Connect</b>($server, $user, $password, $database);
49 $rs = $db-><b>Execute</b>('select * from some_small_table');
51 print_r($rs-><b>GetRows</b>());
55 <h3>How are people using ADOdb</h3>
56 Here are some examples of how people are using ADOdb (for a much longer list,
57 visit <a href="http://php.weblogs.com/adodb-cool-applications">http://php.weblogs.com/adodb-cool-applications</a>):
59 <li><strong>PhpLens</strong> is a commercial data grid component that allows
60 both cool Web designers and serious unshaved programmers to develop and
61 maintain databases on the Web easily. Developed by the author of ADOdb.
63 <li><strong>PHAkt</strong>: PHP Extension for DreamWeaver Ultradev allows
64 you to script PHP in the popular Web page editor. Database handling provided
67 <li><strong>Analysis Console for Intrusion Databases (ACID)</strong>: PHP-based
68 analysis engine to search and process a database of security incidents
69 generated by security-related software such as IDSes and firewalls (e.g.
70 Snort, ipchains). By Roman Danyliw.
72 <li><strong>PostNuke</strong> is a very popular free content management system
73 and weblog system. It offers full CSS support, HTML 4.01 transitional
74 compliance throughout, an advanced blocks system, and is fully multi-lingual
77 <li><strong> EasyPublish CMS</strong> is another free content management system
78 for managing information and integrated modules on your internet, intranet-
79 and extranet-sites. From Norway.
81 <li><strong>NOLA</strong> is a full featured accounting, inventory, and job
82 tracking application. It is licensed under the GPL, and developed by Noguska.