PHP ADOdb Tutorial

PHP ADOdb Step By Step Tutorial. a database class library.

What is PHP ADOdb?

A library for accessing various types of databases
ADOdb Written in PHP Language.
Use metatype system so can figure out eqivalent of different field types in different databases.
Idea from Microsoft's ADOdb
Official website at phplends

Why PHP ADOdb

Support various databases such as MySQL, Oracle, Microsoft SQL Server, Sybase, Sybase SQL Anywhere, Informix, PostgreSQL, FrontBase, Interbase (Firebird and Borland variants), Foxpro, Access, ADO and ODBC.
Not only focus in select statement, this library also support insert, update, and delete statement
Write one run anywhere
Portable sql

Where You can get it?

Class library, you can download at here
PHP ADODb documentation at here
Whenever you need PHP ADOdb?
Your PHP application support many databases.
You dont want to write every line code at every kind database

How to use PHP ADOdb?

ADOdb: Introduction
ADOdb: Connection Statement
ADOdb: Advance Select Statement
ADOdb: How to show tables
ADOdb: How to show fields
ADOdb: How to show databases
ADOdb: Caching of Recordset
ADOdb: Recordset to HTML
ADOdb: Multi Database Connection
ADOdb: Data Dictionary
ADOdb: Quick Export Data
ADOdb: Insert data style
ADOdb: Replace Data
ADOdb: Log Query
PHP ADOdb: Understanding Pivot Table For Reporting