PHP501

Technical Requirements

Operating System Options

• Windows XP Service Pack 2
• Windows Vista
• Windows 7
• Mac OS X

XAMPP or MAMP

Instead of installing a Web Server, Applications Server, and Database separately, you can install one of the following all-in-one packages:

• XAMPP (Apache, PHP, MySQL on Windows)
  • Download
• MAMP (Apache, PHP, MySQL on Macintosh)
  • Download

Installing XAMPP

XAMPP is a free distribution that makes it easy to install Apache Web Server, PHP, PEAR, and MySQL. Before installing XAMPP, you should turn off any other web servers you have running on your machine. NOTE: If you are having trouble installing XAMPP go to this link to view Instructions for Linux, Windows, MAC and Solaris.

1. Go to http://www.apachefriends.org/en/xampp.html and choose XAMPP for Windows, Linux, or Mac OS X (depending on your own operating system) and download the Installer file for XAMPP (not XAMPP Lite).
2. After downloading the program, simply run it. XAMPP needs to be installed into a top-level folder (e.g., the C drive).
3. You can start it by running XAMPP_Start.exe in the XAMPP folder (e.g., C:\XAMPP). This will start Apache Web Server, PHP and MySQL.
4. To test the install, navigate to http://localhost. You should see the XAMPP home page.

Installing XAMPP on 64-bit OS

1. For instructions on installing XAMPP on a 64-bit Windows OS, see Getting XAMPP to work on Windows 7 (64-bit).

Setting the MySQL Password

1. The PHP files use "pwdpwd" for the MySQL root password, while the default password is NO password.
2. Change the password by navigating to http://localhost/security and entering pwdpwd under the MYSQL SECTION: "ROOT" PASSWORD heading and submitting the form.

Installing Northwind Database using XAMPP

NOTE: you should download the class files below before following these instructions, as it contains the Northwinds Database file(s).

1. To install the Northwind database used in class, click on the "phpMyAdmin" link on the left navigation bar of the XAMPP home page. That should take you to http://localhost/phpmyadmin.
2. On that page, click on the Import link under the Localhost heading.
3. Browse to the Northwind-MySQL.sql file in your class files.
4. Click the Go button on the bottom right of the page.
5. You should get a Success message and Northwind should be added to the Database dropdown menu on the upper left of the page.

Any Text or HTML Editor

If you don't already have something to use for Plain Text editing or Web authoring, please choose one of the options listed below.

Windows

• Crimson Editor - Download (recommended)
• Notepad is fine for class and is usually included with Windows.
• Adobe Dreamweaver - Download

Mac OS X

• TextEdit is fine for class and is usually included with Mac OS X.
  • Please ensure you choose Format > Make Plain Text from the TextEdit toolbar.
• TextWrangler - Download
• Adobe Dreamweaver - Download

Class Files

1. Download the class files.
2. After downloading the class files, create a directory on your hard drive named "Webucator" that can be found easily.
   1. On Windows it is recommended the new folder have a path of C:\Webucator.*
   2. On Mac OS X a good location for the new folder may be in your Documents directory.
3. Extract the files to the folder you just created.

FAQ

• XAMPP for Windows FAQ