Installation Instructions

Your first task in this course is to configure your laptop and/or desktop with appropriate software. Follow the first 16 steps of these instructions. Completing these instructions will allow you to run both php5 and MySQL 4.1 with the Apache web server.

Instruction Notes

I installed the software on my laptop on August 1, 2006. My laptop runs Microsoft Windows XP Professional Version 2002 Service Pack 2. Here are a few observations I made regarding the steps above.

Step 1 - Download Apache

The current MSI installer package was apache_2.2.3-win32-x86-no_ssl.msi

Step 2 - Make sure IIS (Internet Information Server) is disabled

Step 3 - Install Apache

When I installed apache, I generally took the default values. On my laptop, the default network domain is coe.montana.edu, the default server name is galway.coe.montana.edu, I changed the admin e-mail to paxton@cs.montana.edu, and I selected the radio button entitled for all users, on port 80, as a service.
On my laptop, apache was installed to c:\Program Files\Apache Software Foundation\Apache2.2
I had to unblock apache to allow it to run.
When I went to http://localhost, I received the message It Works instead of the screen snapshot that appears in the instructions.

Step 4 - Download PHP5

The current php version (under the Windows Binaries section) was php_5.14_zip_package. As of 12.10.2006 the current version is 5.16.

Step 5 - Install PHP5

Step 6 - Configure PHP5 to work with Apache

I decided to make c:/webs my working directory instead of c:/webs/test. webs is short for web services.
In order to get apache to run properly with php5, I had to comment out the line Deny from all (in the httpd file) by adding a # sign to the start of the line. This line appeared within a <Directory /> XML environment, shortly after the word restrictive.
In step 6, the DirectoryIndex occurred within an <IfModule dir_module> XML tag environment. Thus, it looked a little different than the instructions.

Step 7 - Test PHP5

Step 8 - Test SQLite

In the php.ini file, I uncommented the line extension = php_sqlite.dll.
Above the preceding line, I added the line extension=php_pdo.dll.

Step 9 - Download SQLiteManager

The current version of SQLiteManager was 1.2.0

Step 10 - Set up SQLiteManager

Reminder: access SQLiteManager at http://localhost/sqliteManager
To be able to add a new person, you must change both the FirstName and LastName types from numeric to varchar. When you look at the structure of the table, the first action button (a pencil with three dots below it) allows this modification to be made.

Step 11 - Password protect SQLiteManager

There are no instructions in this section. Skip it.

Step 12 - Download MySQL 4.1

The version that I downloaded of MySQL was Windows Essentials (x86) 4.1.21

Step 13 - Install MySQL 4.1

In step 15, select best support for multilingualism (it is not the default).
In step 16, I took the default service name of MySQL.
In step 17, I used admin as the root password.

Step 14 - Create a Database Table using MySQL

Step 15 - Set up PHP to work with MySQL 4.1

I copied the file php_mysqli.dll from php.ext. This copying is unnecessary if you reference it with the line extension = ext/php_mysqli.dll.
The file libmysqli.dll was not present and not needed.