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 4/3
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 4/5
Fri.
Lecture: Server-side Scripting, Schematic
Reading: Nixon Ch. 1: Introduction to Dynamic Web Content
3 4/8
Mon.
Lecture: Getting Started with PHP, Working with Text and Numbers 
Reading: Nixon Ch. 3: Introduction to PHP to page 52
4 4/10
Wed.
Working with Text and Numbers
Reading: Nixon Ch. 3: Introduction to PHP page 52 to end of chapter
Assignment 1 due (SSI)
5 4/12
Fri
Lecture: Control Structures, Arrays
Reading: Nixon Ch. 4: Expressions and Flow Control, Ch. 6: Arrays to page 129
6 4/15
Mon.
Lecture: Functions
Reading: Nixon Ch.5: PHP Functions to page 105
Assignment 2 due (variables)
7 4/17
Wed.
 Lecture: Working with Forms, Validation & Security
Reading: Nixon Ch. 11: Form Handling
  4/18
Th
Spring Career Fair 2019
Western IS Connection (WISC) 5:30-8pm. WWU Library Harry Potter Room
8 4/19
Fri.
Lecture: Validation & Security (continued)
9 4/22
Mon
Lecture: Working with Cookies and User Sessions
Reading: Nixon Ch. 12: Cookies, Sessions and Authentication
Assignment 3 due (control structures, functions)
10 4/24
Wed.
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.)
TAG: Tech Expo
11 4/26
Fri.
Lecture: Creating & reading database records
Reading: Nixon Ch. 10: Accessing MySQL using PHP, phpMyAdmin tutorial
12 4/29
Mon.
Lecture: Using SQL Statements to Query Data
Overview A05
Assignment 4 due (forms, cookies, session)
13 5/1
Wed.
Lecture: SQL continued , SQL Tester
14 5/3
Fri.
Assignment 6 overview SQLSyntaxTester
Site templates: TemplateSimple: Lion.php (source see handout),  ListCityZips.php (source, template)
15 5/6
Mon.
Lecture: Normalizing a Relational Database
Reading: Nixon Ch. 9: Mastering MySQL to page 222
Optional reading (for another normalization example): An Introduction to Database Normalization
Assignment 5 due (reading, adding, updating and deleting database records)
16 5/8
Wed.
Midterm
17 5/10
Fri.
Lecture: Review midterm results.  Overview of final project.
Invitation: MIS 314 students are invited to attend a talk In MIS 424 2-3pm about content management sytems and managing large-scale web sites. The guest speakers will be Max Bronsema, WWU's Director of Web Technologies, and Stephanie Mason, WWU Web Developer/Designer. This is a small group event so there will be good opportunites for Q&A. Please let Professor Sandvig know if you are planning to attend.
18 5/13
Mon.
Lecture: Overview of assignment 7: Bookstore home, search response & product pages
Assignment 6 due
19 5/15
Wed.
Lecture: Debugging & Error Handling
20 5/17
Fri.
Designing for Mobile
21 5/20
Mon.
Lecture: Overview of project: shopping cart, checkout01.php and checkout02.php.
Assignment 7 due (Bookstore: default, SearchBrowse, Product and About pages)
22 5/22
Wed.
Bookstore enhancement ideas and coding tips.
** Note: noon help lab will be held in PH 210 south (due to room schedule conflict) ***
23 5/24
Fri.
Project day: meet in PH 47 computer lab to work on bookstore project.
24 5/27
Mon.
Highslide JS
Memorial Day Holiday
Memorial Day Holiday
25 5/29
Wed.
Lecture: Overview of project: Checkout03.php and OrderHistory.php
Assignment 8 due (Project - shopping cart, checkout01, checkout02)
26 5/31
Fri.
Project day: meet in PH 47 computer lab to work on bookstore project.
 
27 6/3
Mon.
Designing for Search Engines
28 6/5
Wed.
Project day -- no lecture. Professor Sandvig will have extra office hours. 
Office hours: 10 am - noon, 1:00 pm- 4:00 pm
Assignment 9 due at 4 pm.  (Checkout03.php, Order History)
29 6/7
Fri.
Lecture: Course Review,  What's next: PHP and ASP.NET, Final exam
  6/10
Mon.
Extra office hours 10am to 1 pm.
  6/11
Tu.
Projects due at 9 am.
  6/13
Th.
Exam 10:30 - 11:45 am.
Regular Expressions HTML Color Names Color Picker ASCII Character Codes Unicode Character Codes
Top