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.

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 a tutorial on how to create a web database application using PHP and MySQL on Mac OS X or Linux platforms. The example used is a database to manage web site links. The same ideas used in this tutorial can be expanded to most web applications like phone directories, personalization, survey polls, etc... All are based on inserting, displaying and managing data in a database.

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

This tutorial will show you how to display data from a database and allow the user to sort it.

ODBC is one of Microsoft's earliest technologies for connecting to databases. This article describes how to setup and use ODBC from a PHP perspective. Also discusses ODBC extension bugs, database wrapper libraries, Microsoft's ADO (which is Microsoft's recommended API for 4GL programmers) and DSN-less connections.

This tutorial explains how to use several basic MySQL database functions in PHP. Main topics include: Connecting to a mySQL database using PHP, SHOW available tables, Using telnet to CREATE tables, How to INSERT, QUERY, UPDATE, and DELETE rows in a table, How to ALTER a table, Commenting Your mySQL Tables, and Creating mySQL tables.

A quick tutorial explaining how to alternate table row colors using PHP and MySQL.

Learn how to add a row to a mySQL database using a PHP form.

PHP provides built in functions to access just about every database that exists, including Oracle. This 8-page tutorial illustrates how to use these built in functions to communicate with an Oracle database.