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