Slides 2: Programming Exercise I

The following slides show the steps of building an electronic commerce system.

A. MySQL-driven Web Site Construction

Slide 2.a0: Programming Exercise I: A simple online bookstore using LAMP

Slide 2.a1: Programming exercise guidelines

Slide 2.a2: Hosting a database-driven website

Slide 2.a3: Exercise I: How to build Programming Exercise I

Slide 2.a4: Exercise I: Scrutinizing the exercise specifications

Slide 2.a5: Exercise I: Database design

Slide 2.a6: Exercise I: Database design (cont.)

Slide 2.a7: Exercise I: Database implementation (SQL)

Slide 2.a8: Exercise I: Database implementation (cont.)

Slide 2.a9: Exercise I: Web user interface construction [(X)HTML]

Slide 2.a10: Exercise I: Calling a PHP script with embedded SQL (PHP)

B. Essential Software and Tools

Slide 2.b1: Linux server sign-in

Slide 2.b2: Using Linux shell

Slide 2.b3: Basic Linux shell commands

Slide 2.b4: Linux file system

Slide 2.b5: Basic Emacs commands

Slide 2.b6: Writing HTML scripts

Slide 2.b7: Using PHP

Slide 2.b8: REQUEST_METHOD: POST

Slide 2.b9: REQUEST_METHOD: GET

Slide 2.b10: MySQL databases

Slide 2.b11: Using MySQL databases

Slide 2.b12: MySQL Workbench

Slide 2.b13: Using MySQL Workbench

An amnesiac walks into a bar.
He goes up to a beautiful blonde and says,
“So, do I come here often?”