| 36 |
kaklik |
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>
|