Open Tools for MySQL Administrators MySQL / General Guides
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 MySQL / Optimization
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 / Replication and Backup
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.
The Universal Web Form Processor PHP / Forms
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.
Phorm Manager PHP / Forms
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.
PHP With HTML Forms PHP / 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.