Acquiring PHP MySQL

PHP and MySQL are already packaged in Linux and Mac OS X OSs. However, most PHP developer are actually using Windows when developing PHP applications. This is also true to myself. I have Mandrake Linux 10 but I'll just use it for testing purposes of my finished scripts. One reason is that Windows render an amazing web presence unlike any other OS's browsers. So this page will only cover the WAMP ( Windows, Apache, MySQL, PHP ). You will learn how to install Apache, PHP, and MySQL under Windows platform.

This tutorial is intended for absolute beginners and graphical-mode guys so I will use a ready-to-install package that contain those three things to start developing data-driven websites. In this case, I will use XAMMP. You can find more package here Hotscripts.com. If you prefer to install them one by one, you can download it here:

Apache: Apache.org
PHP: Php.net
MySQL: Mysql.com

A detailed info on how to install them is already outlined in their respective websites.

Now, let's go back to XAMMP. Please follow the steps below.
1. First you must download the installer here: Apachefriends.org
2. Double-click on the installer icon and choose your desired language and choose the drive where you want to install. In my case I install it in C:Inetpub.
3. Once finished installation, go to C:Inetpubxammpapache and click on the install_apache_service.bat file. This will automatically Apache as a Service so you don't have to start it manually everytime you restart your computer.
4. Go to C:Inetpubxammpmysqland click on the install_mysql_service.bat file. Same with what we do to Apache, this will install MySQL as a Service.
5. Try typing in your browser this line: http://localhost/ and if you see the XAMMP logo it means that all are correctly setup and you're ready to make a dynamic websites now.

XAMMP's default document root directory is in /htdocs. In this case, it is located in C:Inetpubxammphtdocs. You can put all your PHP files created here.

And that's all. Hope this will give you a good start. If you have any questions, please feel free to contact me.

MySQL Join Tutorial
What are joins and how do you make them?
Alternating Rows: Mysql
The first thing we need to do is connect to the database. I always put my db connection in a universal file, that way I can just change the variables once if I need to; but for the sake of the tutorial, im putting it in this file.
PHP Navigation and Connecting to a MySQL Database
PHP Navigation and Connecting to a MySQL Database
Alternating Row Colors
Theres two different ways this can be done. The first is by getting results from a mysql query, the second is going through the values of an array. Ill go over both. First the full files (ill break it up into two files, one using mysql, and one using an array)
Basic Website Promotion for the Novice
Many website owners & smaller internet businesses simply cannot afford to hire a specialized web marketing / promotion firm to properly market their site for them. This is not the end of the world for them - there are other possibilities...
Top 3 Free Web Hosting Services
Nowadays, there are many free webhosting services available on the Internet. Sometimes it can be difficult to choose which one is best for you. First of all, you need to bear in mind free wehosting usually have some limitations such as not allowed email accounts, no mysql databases, no perl etc.
Alternating Rows: Arrays
The first thing we do here is echo out the html, again I wont go over this because theres really nothing to explain, except the css. We have two css classes, one for each of the alternating rows.
PHP User Stats
In this tutorial I am going to teach you how to make a User Stats menu in PHP and MySQL which displays: Unique hits, Unique hits today, Total hits, Total hits today. If you dont have MySQL you can get one for free here.
MySQL Tables
Create, insert, update, delete, count and select rows in a database.
Configure a virtual directory using WAMP
Simple guide on how to configure a root folder for a PHP web site using WAMP server.