Setup Instructions for
PHP and MySQL Training

  1. If you haven't already, download the class files listed at the bottom of this page.
  2. Create a folder in the root of your C drive called "Webucator" and extract the class files zip file to that folder.
  3. Make sure that you have installed the editor you plan to use in class.
    1. See the course outline for your class to determine which editors you can use.
    2. If this is for a private onsite class make sure that each computer has the editor installed.
    3. If you are using a trial version of the editor, be aware that some products require a unique trial key on each computer.

Installing XAMPP

Note, before installing XAMPP, you should turn off any other web servers you have running on your machine.

  1. XAMPP is a free distribution that makes it easy to install Apache Web Server, PHP, PEAR, and MySQL.
  2. 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).
  3. After downloading the program, simply run it. XAMPP needs to be installed into a top-level folder (e.g., the C drive).
  4. After installing XAMPP, you must move the Webucator folder to the C:\xampp\htdocs folder
  5. 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.
  6. To test the install, navigate to http://localhost. You should see the XAMPP home page.
  7. To see if you have the class files in the right place, navigate to http://localhost/Webucator/ClassFiles/Setup/ReadMe.html. You should see this file.

Northwind

  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 Setup directory (the same folder you found this file in).
  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.

Outline available at http://www.webucator.com/WebDev/PHP501.cfm

Class files available at http://www.webucator.com/ClassFiles/PHP501.zip

Technical requirements listed at http://www.webucator.com/WebDev/PHP501.cfm#TechReqs.