tailieunhanh - PHP Application Development With ADODB (part 1)

A number of different abstraction layers are available for PHP, most notably the PEAR DBI, Metabase and PHPLib. The one I'm going to use in this article is named ADODB (Active Data Objects DataBase), and it's one of the most full−featured and efficient PHP abstraction libraries available today. Developed by John Lim, the library currently supports a wide variety of database systems, including MySQL, PostgreSQL, Oracle, Interbase, Microsoft SQL Server, Access, ODBC and others, and has been used in a number of well−known open−source PHP projects, including phpLens, PostNuke and Webodex | PART ONE By icarus This article copyright Melonfire 2000-2002. All rights reserved. PHP Application Development With ADODB part 1 Table of Contents Any Port In A A Little The Bookworm Anatomy Different Getting It Playing The Strange Hitting The Coming Soon To A Screen Near i Any Port In A Storm As a developer one of the most important things to consider when developing a Web application is portability. Given the rapid pace of change in the Web world it doesn t do to bind your code too tightly to a specific operating system RDBMS or programming language if you do you ll find yourself reinventing the wheel every time things change on you and they will - take my word for it . That s where this article comes in. Over the course of this two-part tutorial I m going to be showing you how to make your code a little more portable by using a database abstraction layer for all your RDBMS connectivity. This database abstraction layer allows you to easily switch between one RDBMS and another without requiring either a code rewrite or a long tortuous retest cycle. In the long run this will save you time save your customers money and maybe make your life a little simpler. Before we get started one caveat while portability is something you should strive for regardless of which language or platform you work on it s impossible to cover every single possibility in this I don t plan to. Instead I ll be restricting myself to my favourite Web programming language PHP and the ADODB database abstraction library also written in PHP. Similar libraries exist for most other programming languages and you should have no trouble adapting the techniques in this article to other platforms. Let s get started Any Port In A Storm Developer Shed