[903] | 1 | <html>
|
---|
| 2 | <head>
|
---|
| 3 | <title>ADODB Manual</title>
|
---|
| 4 | <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
|
---|
| 5 | <XSTYLE
|
---|
| 6 | body,td {font-family:Arial,Helvetica,sans-serif;font-size:11pt}
|
---|
| 7 | pre {font-size:9pt}
|
---|
| 8 | .toplink {font-size:8pt}
|
---|
| 9 | />
|
---|
| 10 | </head>
|
---|
| 11 | <body bgcolor="#FFFFFF">
|
---|
| 12 |
|
---|
| 13 | <h3>ADOdb Library for PHP</h3>
|
---|
| 14 | <p>ADOdb is a suite of database libraries that allow you to connect to multiple
|
---|
| 15 | databases in a portable manner. Download from <a href=http://adodb.sourceforge.net/>http://adodb.sourceforge.net/</a>.
|
---|
| 16 | <ul><li>The ADOdb documentation has moved to <a href=docs-adodb.htm>docs-adodb.htm</a>
|
---|
| 17 | This allows you to query, update and insert records using a portable API.
|
---|
| 18 | <p><li>The ADOdb data dictionary docs are at <a href=docs-datadict.htm>docs-datadict.htm</a>.
|
---|
| 19 | This allows you to create database tables and indexes in a portable manner.
|
---|
| 20 | <p><li>The ADOdb database performance monitoring docs are at <a href=docs-perf.htm>docs-perf.htm</a>.
|
---|
| 21 | This allows you to perform health checks, tune and monitor your database.
|
---|
| 22 | <p><li>The ADOdb database-backed session docs are at <a href=docs-session.htm>docs-session.htm</a>.
|
---|
| 23 | </ul>
|
---|
| 24 | <p>
|
---|
| 25 | <h3>Installation</h3>
|
---|
| 26 | Make sure you are running PHP4.0.4 or later. Unpack all the files into a directory accessible by your webserver.
|
---|
| 27 | <p>
|
---|
| 28 | To test, try modifying some of the tutorial examples. Make sure you customize the connection settings correctly. You can debug using:
|
---|
| 29 | <pre>
|
---|
| 30 | <?php
|
---|
| 31 | include('adodb/adodb.inc.php');
|
---|
| 32 |
|
---|
| 33 | $db = <b>ADONewConnection</b>($driver); # eg. 'mysql' or 'oci8'
|
---|
| 34 | $db->debug = true;
|
---|
| 35 | $db-><b>Connect</b>($server, $user, $password, $database);
|
---|
| 36 | $rs = $db-><b>Execute</b>('select * from some_small_table');
|
---|
| 37 | print "<pre>";
|
---|
| 38 | print_r($rs-><b>GetRows</b>());
|
---|
| 39 | print "</pre>";
|
---|
| 40 | ?>
|
---|
| 41 | </pre>
|
---|
| 42 | <h3>How are people using ADOdb</h3>
|
---|
| 43 | Here are some examples of how people are using ADOdb:
|
---|
| 44 | <ul>
|
---|
| 45 | <li> <strong>PhpLens</strong> is a commercial data grid component that allows
|
---|
| 46 | both cool Web designers and serious unshaved programmers to develop and
|
---|
| 47 | maintain databases on the Web easily. Developed by the author of ADOdb.
|
---|
| 48 | </li>
|
---|
| 49 | <li> <strong>PHAkt</strong>: PHP Extension for DreamWeaver Ultradev allows
|
---|
| 50 | you to script PHP in the popular Web page editor. Database handling provided
|
---|
| 51 | by ADOdb. </li>
|
---|
| 52 | <li> <strong>Analysis Console for Intrusion Databases (ACID)</strong>: PHP-based
|
---|
| 53 | analysis engine to search and process a database of security incidents
|
---|
| 54 | generated by security-related software such as IDSes and firewalls (e.g.
|
---|
| 55 | Snort, ipchains). By Roman Danyliw. </li>
|
---|
| 56 | <li> <strong>PostNuke</strong> is a very popular free content management system
|
---|
| 57 | and weblog system. It offers full CSS support, HTML 4.01 transitional
|
---|
| 58 | compliance throughout, an advanced blocks system, and is fully multi-lingual
|
---|
| 59 | enabled. </li>
|
---|
| 60 | <li><strong> EasyPublish CMS</strong> is another free content management system
|
---|
| 61 | for managing information and integrated modules on your internet, intranet-
|
---|
| 62 | and extranet-sites. From Norway. </li>
|
---|
| 63 | <li> <strong>NOLA</strong> is a full featured accounting, inventory, and job
|
---|
| 64 | tracking application. It is licensed under the GPL, and developed by Noguska.
|
---|
| 65 | </li>
|
---|
| 66 | </ul>
|
---|
| 67 | </body>
|
---|
| 68 | </html>
|
---|