This tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts.
In writing this document, I will assume that you already have:
a basic understanding of Unix commands, HTML, and SQL
an understanding of administering your Unix box
a working Unix box on which you will install the software
the necessary software packages to compile software
you don't already have MySQL, Apache, or PHP installed
This guide is written to be as OS neutral as possible. Please make changes as necessary for your setup.
Getting MySQL
First let's grab MySQL, you will find it at http://www.mysql.com. The latest version as of this writing is 3.22.22. From their download page, you will find precompiled binaries for the following operating systems:
Linux
Irix 6.3
SunOS 4.1.4
Solaris (Sparc) 2.5.1 and 2.6
Getting Apache
Next thing to get is the Apache source distribution. You will find it at their homepage http://www.apache.org, the latest version as of this writing is 1.3.6.
Getting PHP
Finally, get the PHP source distribution from their homepage http://www.php.net. The latest version as of this writing is 3.0.7.
Other Packages
There are many other things you can compile PHP. Doing this is beyond the scope of this document, you can always add support for these things later. We will keep things simple to get through this guide.