www.onlamp.com Tutorials

Open Tools for MySQL Administrators
The MySQL distribution provides several tools for database developers and administrators, but they don't always work everywhere. Fortunately, the worldwide MySQL community has produced plenty of useful tools.

How to Optimize Rank Data in MySQL
Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means. How careful denormalization and query construction can lower your database load and simplify your code.

Advanced MySQL Replication Techniques
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.

Basic Installation of PHP on a Unix System
Learn how to compile and install PHP on a Unix system.

Creating Dynamic Next / Previous Buttons with PHP and MySQL
In this tutorial we are going to learn how to Creating Dynamic Next / Previous Buttons with PHP and MySQL.

PHP With HTML Forms
This 2-page tutorial shows how to work HTML forms in PHP. Topics covered: Drop menu builder, Radio buttons, Check boxes, Error processing, and more.

Phorm Manager
In this part four of a series on HTML form handling with PHP, it explains how to create a powerful PHP form handler, called Phorm Manager.

The Universal Web Form Processor
This article describes how to create a generic form processor in PHP. Discussion involves form elements, hidden fields, and more. Also covers the installation process of NuSphere MySQL, an integrated multi-platform distribution of Apache, Perl, PHP, and MySQL.