ADODB Class - Database Wrapper Class

Do check out this award winning class ADODB. Its really easy to use and has many features which really help a lot in the development of an application. The best part is that you just have to specify which database system you want to use in the beginning. If you want to change the database server, just change it where you create a connection. It supports MySQL,MSSQL, Oracle etc.

It has an inbuilt pagination script to display your results in pages.

 

 

-----This is not a tutorial. Moved from [How-To's and Tutorials > Programming > PHP] to [Databases] -----szupie

Edited January 25, 2006 by miCRoSCoPiC^eaRthLinG (see edit history)

Frankly this post is quite useless. You haven't provided any reference material and links to such sites where members can read further on this topic. For those who have no inkling about ADO, wouldn't know that its a DB Wrapper class by MS used extensively in MS Developer Studio to connect to different breeds of RDBMS and lets you manipulate these DBs without any knowledge of SQL whatsoever.

 

When you make such a post, make sure you include links for further reference and also put in more material that helps members understand the topic better - to start with.

 

BTW, ADO stands for ActiveX Data Objects - but recently this abstraction layer aka wrapper has been adapted to other mainstream and scripting languages too (e.g. PHP, Python) - and this new adapted class has been named ADODB.

 

As of now, ADODB supports these databases (list might be incomplete):

Access

 

DB2

 

Firebird

 

Foxpro

 

FrontBase

 

Informix

 

Interbase

 

MS SQL

 

MySQL

 

Netezza

 

Oracle

 

PostgreSQL

 

SAP DB

 

SQLite

 

Sybase

 

Teradata

I use a DBI that one of my instructor's introduced me to. I use it for PostgresSQL and/or MySQL. It works fine, and is based (i think) on a standard cgi DBI. I have to admit, it's rather nice to have the consitency and ease of use thru all different database types. I'll give this one a look-over, thanks for the post but maybe a link or something next time.

Yeah these wrapper are pretty consistent and provide a very uniform way to connect to such a wide variety of databases.

Anyway, this ADODB can be grabbed off: http://adodb.org/dokuwiki/doku.php

Regards,
m^e

how to create an exec method in a base(a general database wrapper class) ?

 

pls do reply ASAP.

 

awaiting reply.

 

thank you.

 

 

 

 

 

 

 

 

 

 

 

 

 

Do check out this award winning class ADODB. Its really easy to use and has many features which really help a lot in the development of an application. The best part is that you just have to specify which database system you want to use in the beginning. If you want to change the database server, just change it where you create a connection. It supports MySQL,MSSQL, Oracle etc.

It has an inbuilt pagination script to display your results in pages.

-----This is not a tutorial. Moved from [How-To's and Tutorials > Programming > PHP] to [Databases] -----szupie