Perl 101 (Part 5) - Sub-Zero Code CGI and Perl / General Development
This Part 5 of the Perl 101 series introduces you to subroutines and teaches you how to structure your code for maximum reusability. Also included: return values, my() and local() constructs, and a marriage proposal.
MySQL User Account Management MySQL / General Guides
The MySQL access control system enables you to create MySQL accounts and define what each account can do. Several types of privileges can be assigned to an account. They should be granted according to how the account is to be used.
Optimizing for Query Speed MySQL / Optimization
Optimzing your queries can help them run more efficiently, which can save a significant amount of time. This article covers index optimization and index usage and discusses general principles that are useful for optimizing queries to run more efficiently.
MySQL Table Joins PHP / Databases
One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command.
Creating a Mailing List Manager with PHP PHP / Emailing
This tutorial will guide you through building a complete mail list administration solution, capable of handling multiple lists. Suitable for small-medium sized lists (less than 500 names), flat files are used to store information for later retrieval. Many file access commands will be used and explained, and we'll cover how to send mail from a PHP script.