Setting up PHP & MySQL on your local computer
-
The Uniform Server is a package that allows you to run a server on any MS
Windows OS based computer. The Uniform Server will be used to test our
applications made with PHP and
MySQL.
http://www.uniformserver.com/index.php (download UniServer3_3.exe at:
-
In order to run the "Uniform Server" you need to
not be running another Web Server on your system.
To stop IIS on most Windows machines: Open the "Internet Information Services" control panel in
Settings
Control Panel
Administrative Tools (on most Windows Machines).
-
Then choose Default Web Site
Action and then click Stop to Stop IIS (if it is running on your
machine).
-
Unzip the Uniform Server package - anywhere,
browse to the Uniform Server folder and double click on "Server_Start.bat"
This should start the uniform server and take you to the "Uniform Server
Admin" window at: http://localhost/apanel/
-
Select
Run MySQL (above) to start MySQL running on your local machine - you should
get a message telling you the server is started:
-
Scroll down the left menu (below Run MySQL) and
choose
phpMyAdmin to add yourself as a user of MySQL
- Use the Host: localhost
- Use the username given for you to login to MySQL on Ouray (e.g. the same
username as the Ouray username with one exception If the Ouray username has a
hyphen '-' the hyphen is omitted).
- Use the password given for for student databases is (e.g. mysql followed
by student number).
- Give yourself complete privileges on the account so you can create
databases, tables, select & insert ...:
-
Given that the Universal Server has PHP and MySQL
built in - you can now use a PHP editor that does not have these: I
recommend PHP Designer (
http://www.mpsoftware.dk/phpdesigner.php ). It is free and does not
expire. When you are setting up PHP Designer you need to point it to the
folders you UnZipped the Universal Server to (Options
Editor Preferences
Debug):