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.

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.

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.

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.

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.