• View
• Edit
• History
• Print

Case Study: The functions of MySQL, PHP, JavaScripts and AJAX

Overview: In this tutorial, you will go through all the necessary steps in building a website which uses MySQL (database) to store information, PHP (server-side script) to retrieve and update information in database, and JavaScript (client-side script) to asynchronously send request to the PHP program. You will understand more about the functions of database, server-side scripts, and client-side scripts in building a website.

Activity 1:

• Install an Apache Web server that is powered with MySQL and PHP in your computer. Please use the previous tutorial material: Installing a Web Server if you forget how to do that.

Activity 2:

• Go through all the steps (Step 1 to Step 5d) in building the voting website as presented in Lecture 10 - Case Study: Functions of Database, Server-side and Client-side Scripts

Some interesting resources

• Favorite Rating with jQuery and Ajax
• Voting system with jQuery, Ajax and PHP

Submission

• You need to demonstrate your work to Steven in a tutorial session. Steven may ask you some questions to test your knowledge.