This tutorial explains how to program Next / Previous buttons with a dynamic, reusable class using PHP and MySQL or PostGreSQL.

This free, dW-exclusive tutorial shows you how to use two open source, cross-platform tools for creating a dynamic Web site: PHP and MySQL. When we are finished, you will learn how dynamic sites work and how they serve the content, and you will be ready to serve your own dynamic content from your site. After a quick registration, you can begin the tutorial. The tutorial should take you about 1 hour to complete. You can take it online, or download a PDF or zip file of the tutorial.

This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.

A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.

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.

So you've written a great application with PHP and it is up and running smooth. Then, your boss calls and tells you that your company won't be using MySQL anymore. You're moving to Oracle. Your application is dead in the water. You should have used database abstraction.

The usage of databases in larger web-based applications is essential. By using basic object-orientated techniques we can minimize the fuss of connecting and interacting with a database. We can also reuse this code in other applications: a huge benefit of 'OO' programming.

This is a database driven pagination tutorial. Pagination refers to when return results are broken up into pages. For example when say a search returns 100 results but 10 results per page is desired and links to the other pages with 10 more results are generated. This is used to avoid scrolling nightmares. A classic example is the google search. This tutorial assumes basic knowledge of php scripting and mysql databases.

Structures_DataGrid and DB_DataObject are two PEAR components, which can be connected together, to easily display the data contained in a SQL table, and let the user sort and page through it. With minimal typing, this tutorial shows you how you can bypass the usual steps of parsing GET parameters, performing SQL requests, and generating HTML content.

One of the most important factors in dynamic web page development is database definition. If your tables are not set up properly, it can cause you a lot of headaches down the road when you have to perform miraculous SQL calls in your PHP code in order to extract the data you want. By understanding data relationships and the normalization of data, you will be better prepared to begin developing your application in PHP. This 6-page article describes the data relationships and the normalization of data using a simple example.