Apache Today [Your Apache News Source]
Your Daily Source for Apache News and Information  
Breaking News Preferences Contribute Triggers Link Us Search About
To internet.com

Apache HTTPD Links
Apache-Related Projects
Apache Module Registry
The Apache FAQ
Apache XML Project
The Apache Software Foundation
Apache-Perl Integration Project
The Jakarta Project
The Java Apache Project
Apache Project
PHP Server Side Scripting


Internet News
Internet Investing
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ISP Resources
ASP Resources
Wireless Internet
Internet Resources
Internet Lists
Career Resources

Search internet.com
Advertising Info
Corporate Info
PHP Tutorial: Using ADODB to port your MySQL code
Dec 17, 2000, 15 :14 UTC (0 Talkback[s]) (1224 reads) (Other stories by John Lim)

"PHP is all about creating dynamic web-sites with the least fuss and the most fun. To create these websites we need to use databases to retrieve login information, to splash dynamic news onto the web page and store forum postings. So let's say we were using the popular MySQL database for this. Your company has done such a fantastic job that the Web site is more popular than your wildest dreams. You find that MySQL cannot scale to handle the workload; time to switch databases."

"Unfortunately in PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(); when you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that the parameters you use for the different connect functions are different also.. One database says po-tato, the other database says pota-to. Oh-oh."

"A database wrapper library such as ADODB comes in handy when you need to ensure portability. It provides you with a common API to communicate with any supported database so you don't have to call things off."

Complete Story

Related Stories:
AbriaSoft Releases Abria SQL Standard 2.1 With SSL-Ready Secure Apache Server, Red Hat 7.0 And ODBC Support(Dec 04, 2000)
Connecting to MySQL with PHP(Dec 02, 2000)
PHPBuilder: Open Source Databases: As The Tables Turn(Nov 23, 2000)
OSFAQ: How to create a database driven website (PHP/MYSQL)(Nov 05, 2000)
Why and How I Installed PHP4, MySQL, and Apache on Windows 98(Sep 27, 2000)
PHPBuilder: MySQL and PostgreSQL Compared(Jul 07, 2000)
dotcomma: Efficient SQL in PHP(Jun 11, 2000)
DevShed: The Soothingly Seamless Setup of Apache, SSL, MySQL, and PHP(Jun 09, 2000)
PHP 4.0 -- Dynamic Content for the World Wide Web Warrior(May 25, 2000)

  Current Newswire:
Chromium announces speed enhancement for Apache web servers

Transoft launches web application adapter

Covalent Technologies To Optimize Covalent SSL for Intel's Itanium Processor Platform

Entercept Security Technologies broadens webserver protection to include Apache

Apache 2.0.16 released as beta

InstantXML turns Java apps into web services

SECURITY: HP introduces software and services to promote secure e-commerce, including Apache support

UnixReview.com: Linux/Unix System Monitoring in the Palm of Your Hand

Covalent Technologies Releases Apache Enterprise Products

Apache Week issue 241 (6th April 2001)

No talkbacks posted.
Enter your comments below.
Your Name: Your Email Address:

Subject: CC: [will also send this talkback to an E-Mail address]

See our talkback-policy for or guidelines on talkback content.

About Triggers Newsletters Media Kit Security Triggers Login

Privacy Policy
All times are recorded in UTC.
Linux is a trademark of Linus Torvalds.
Powered by Linux 2.2.12, Apache 1.3.9. and PHP 3.14
© Copyright 2000, internet.com Corp. All Rights Reserved.Legal Notices.