[Summary view] [Print] [Text view]

   1  ADODB Library for PHP5
   2  ======================
   3  
   4  (c) 2000-2014 John Lim ([email protected])
   5  
   6  Released under both BSD and GNU Lesser GPL library license.
   7  This means you can use it in proprietary products.
   8  
   9  Home page: http://adodb.sourceforge.net/
  10  
  11  
  12  Introduction
  13  ============
  14  
  15  PHP's database access functions are not standardized. This creates a
  16  need for a database class library to hide the differences between the
  17  different databases (encapsulate the differences) so we can easily
  18  switch databases.
  19  
  20  The library currently supports MySQL, Interbase, Sybase, PostgreSQL, Oracle,
  21  Microsoft SQL server,  Foxpro ODBC, Access ODBC, Informix, DB2,
  22  Sybase SQL Anywhere, generic ODBC and Microsoft's ADO.
  23  
  24  We hope more people will contribute drivers to support other databases.
  25  
  26  
  27  Installation
  28  ============
  29  
  30  Unpack all the files into a directory accessible by your web server.
  31  
  32  To test, try modifying some of the tutorial examples.
  33  Make sure you customize the connection settings correctly.
  34  
  35  You can debug using:
  36  
  37  ``` php
  38  <?php
  39  include('adodb/adodb.inc.php');
  40  
  41  $db = ADONewConnection($driver); # eg. 'mysql' or 'oci8'
  42  $db->debug = true;
  43  $db->Connect($server, $user, $password, $database);
  44  $rs = $db->Execute('select * from some_small_table');
  45  print "<pre>";
  46  print_r($rs->GetRows());
  47  print "</pre>";
  48  ```
  49  
  50  
  51  Documentation and Examples
  52  ==========================
  53  
  54  Refer to the `docs` directory for library documentation and examples.
  55  
  56  - Main documentation: `docs-adodb.htm`.
  57    Query, update and insert records using a portable API.
  58  - Data dictionary docs: `docs-datadict.htm`.
  59    Describes how to create database tables and indexes in a portable manner.
  60  - Database performance monitoring docs: `docs-perf.htm`.
  61    Allows you to perform health checks, tune and monitor your database.
  62  - Database-backed session docs: `docs-session.htm`.
  63  
  64  There is also a tutorial `tute.htm` that contrasts ADOdb code with
  65  mysql code.
  66  
  67  
  68  Files
  69  =====
  70  
  71  - `adodb.inc.php` is the library's main file. You only need to include this file.
  72  - `adodb-*.inc.php` are the database specific driver code.
  73  - `adodb-session.php` is the PHP4 session handling code.
  74  - `test.php` contains a list of test commands to exercise the class library.
  75  - `testdatabases.inc.php` contains the list of databases to apply the tests on.
  76  - `Benchmark.php` is a simple benchmark to test the throughput of a SELECT
  77  statement for databases described in testdatabases.inc.php. The benchmark
  78  tables are created in test.php.
  79  
  80  
  81  Feature Requests and Bug Reports
  82  ================================
  83  
  84  Please report bugs, issues and feature requests on Github:
  85  
  86  https://github.com/ADOdb/ADOdb/issues
  87  
  88  You may also find legacy issues in
  89  
  90  - the old [ADOdb forums](http://phplens.com/lens/lensforum/topics.php?id=4) on phplens.com
  91  - the [SourceForge tickets section](http://sourceforge.net/p/adodb/_list/tickets)
  92  
  93  However, please note that they are not actively monitored and should
  94  only be used as reference.