Syllabus Schedule Project Labs Canvas Server Access phpMyAdmin Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Assignment 6 Assignment 7 Assignment 8 Assignment 9
Syllabus
Meeting Date Topic & Readings
1 1/8
Wed.
Lecture: Introduction to Course
Access the Yorktown server several days before assignment 1 is due. This will provide time to fix any network configuration problems. Allow a minimum of 48 hours for changes to the network configuration.
2 1/10
Fri.
Lecture: Server-side Scripting, Schematic
Reading: Nixon Ch. 1: Introduction to Dynamic Web Content
3 1/13
Mon.
University closed for snow.
4 1/15
Wed.
University closed for snow.
5 1/17
Fri
University closed for snow.
6 1/20
Mon.
Martin Luther King, Jr.
Martin Luther King
Martin Luther King Holiday
MLK An Extraordinary Life. (courtesy Seattle Times)
7 1/22
Wed.
Lecture: Getting Started with PHP, Working with Text and Numbers 
Reading: Nixon Ch. 3
Assignment 1 due at 1pm
8 1/24
Fri.
Lecture: Control Structures, Arrays
Reading: Nixon Ch. 4: Expressions and Flow Control, Ch. 6: Arrays to page 129 only
9 1/27
Mon
Lecture: Functions
Reading: Nixon Ch.5: PHP Functions to page 104.
Assignment 2 due (variables)
10 1/29
Wed.
Lecture: Working with Forms, Validation & Security
Reading: Nixon Ch. 11: Form Handling
11 1/31
Fri.
Lecture: Working with Forms
12 2/3
Mon.
Lecture:Validation & Security
Reading: Nixon Ch. 11: Form Handling
13 2/5
Wed.
Lecture: Working with Cookies and User Sessions
Reading: Nixon Ch. 12: Cookies, Sessions and Authentication
Assignment 3 due (control structures, functions)
14 2/7
Fri.
Lecture: Using Relational Databases
Reading: Nixon Ch. 8: Introduction to mySQL. Skip p. 167-176. We will be using phpMyAdmin rather than the command line interface.
15 2/10
Mon.
Lecture: Creating & reading database records
Reading: Nixon Ch. 10: Accessing MySQL using PHP, phpMyAdmin tutorial
16 2/12
Wed.
Lecture: Using SQL Statements to Query Data
Overview HW5
17 2/14
Fri.
Lecture: SQL continued , SQL Tester
Assignment 4 due (forms, cookies, session)
Assignment 5 due (reading, adding, updating and deleting database records)
18 2/17
Mon.
Honest Abe
Honest Abe
Presidents Day Holiday
19 2/19
Wed.
Lecture: Normalizing a Relational Database
Reading: Nixon Ch. 9: Mastering MySQL to page 222 only
Optional reading (for another normalization example): An Introduction to Database Normalization
Assignment 6 due
20 2/21
Fri.
Midterm
21 2/24
Mon.
Overview of assignment 7.

22 2/26
Wed.
Overview of project: shopping cart, checkout01.php and checkout02.php. Lecture: Review midterm results.  
Assignment 7 due (Bookstore: default, SearchBrowse, Product and About pages)
23 2/28
Fri.
Bookstore enhancement ideas and coding tips.
24 3/2
Mon.
Lecture: Overview of project: Checkout03.php and OrderHistory.php
Extra help lab Tuesday 3/3 from 4-6pm in PH 210 south.
25 3/4
Wed.
Project day: meet in PH 047 computer lab to work on bookstore project.
Assignment 8 due (Project - shopping cart, checkout01, checkout02)
26 3/6
Fri.
Designing for Mobile

27 3/9
Mon.
Project day: meet in PH 047computer lab to work on bookstore project.
Extra help lab Tuesday 3/10 from 4-6pm in PH 047.
28 3/11
Wed.
Project day -- no lecture. Professor Sandvig will have extra office hours. 
Office hours: 10:00 am - noon, 1:00 pm- 4:00 pm
Assignment 9 due at 4 pm.  (Checkout03.php, Order History)
29 3/13
Fri.
Lecture: Course Review,  What's next: PHP and ASP.NET, Final exam
  3/16
Mon.
Exam 10:30 am - 11:45 am.
Extra office hours 1-3 pm.
  3/17
Tu.
Projects due at 9 am.
Regular Expressions HTML Color Names Color Picker ASCII Character Codes Unicode Character Codes
Top