Lab #5.1: Exploring Your CS X Server Account Environment


Purpose: In this lab, you should gain the basic skills to work with the CS X server machine and the MySQL server installed on it. Eventually, we would like to host your database projects and the web interfaces to your databases on the CS X server machine.


Things to do and report: Go over exercises 1~5 in the following and inform me of your progress in these exercises in your weekly progress report.


How to upload or download files to your account on the CS X server using FileZilla


The URLs of your web pages on CS X server


How to directly connect to the MySQL server on the CS X server through phpMyAdmin


How to use PuTTY to log into the CS X server and work with the server as a UNIX environment








Lab #5.2: Create your first PHP-MySQL applcation


Purpose: In this lab, you’ll (i) create 3 tables required in a very simple online-book store application in your own MySQL account on the OS X server and (ii) host your web interfaces and php script files on your own sites folder on the server to make the simple online bookstore running on the CS X server machine.


How to build very simple web interfaces to MySQL using HTML and PHP

Exercise 6: Play with these web pages 1 and 2 or 3 to see how you can

1.      insert a new book into the books table in a database through this insertion of new books web page, and

2.      search for books based on ISBN, Author, Title by querying the database through this online catalog query  or this alternative web page.


Exercise 7: Play with these web pages 1 and 2 or 3 to see how you can

1.      Upload this bookstore.sql script to the root folder of your OS X account

2.      Login into your own MySQL account on OS X server, use the test  database, and create three tables described in bookstore.sql by either manually typing in the SQL commands or just run the command: source bookstore.sql.

3.      Download and examine the related html and php scripts files used in Exercise 6 into your own computer..

4.      Modify the php scripts there to connect to your own MySQL account by using your own user name, password, and your own test database instead those in the php scripts.

5.      Upload the revised PHP script files and the original html files into your own sites folder.

6.      Access (from the Internet) those html pages you just upload to insert new book and to search for books based on ISBN, Author.



Useful online references: