The use of abstraction layers is a controversial topic among PHP users. There are reasons why people use them, and likewise why they don’t. In this article I will be going through the advantages and disadvantages of using the ADODB database abstraction layer.

Learn the three main basic data types used in MySQL and how to utilize them to build a more effective dynamic web site. Lots of web developers use MySQL but not all of them harness the power of these features.

This tutorial teaches you how to number rows and give them alternate colours!

This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.

This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query.

All scripts contained within the 'rankin' original project folder are intended to offer the PHP/MySQL 'novice' access to a series of scripts which can be used as an instructional aid and a set of templates in order to get a good head start on developing web applications that maintain database records (list, insert, modify & delete records). Developed with 'top-down' methodolgy (not object oriented) in order to keep the scripts as easy as possible to follow the logic. E-mail gleonard@ticino.com for a free zip file of the entire project and request the 'rankin project'. If you would like to see a demo goto http://www.gleonardonline .com/rankin .

This tutorial might seem pretty simple and obvious for many advanced webmasters, but some beginners might have some problems. And since I remember I was a bit stuck on this years ago too, why not make things clear for anyone? When do we need to do this? Everytime we install a forum or a CMS that requires an empty database being already created for the install process.

A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.

Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN.

Do you get stressed out by mysql or other database queries? Do you use multiple databases and wish there was just one way to handle all of your queries? ADOdb is a system that executes queries to any type of database the same way, so you only have to know how to do it their way. This tutorial walks you through installing ADOdb on your web server, and configuring it to work with a mysql server.