Schedule
Week |
Date |
Topics |
Readings and tasks due |
1 |
1/16/18 |
Course Introduction, Software used in this class Chapter 1 – Introduction to web development with PHP • The architecture of a web application • The product discount application
Activities: · http://misdemo.temple.edu/shafer/unixtut · HTML exercise · Exercises 1.1, 1.2 |
Software
installations (per video tutorial sent out),
Lynda – HTML Essential Training (see above)
Lynda – HTML Essential Training, with James Williamson (Sections 3 & 5)
Murach – pages 4 – 21 |
2 |
1/23/18 |
Chapter 1 – Introduction to web development with PHP
Application Chapter 2 – How to code a PHP application
Activities:
|
Lynda – HTML Essential Training, with James Williamson (Sections 6 & 7)
Murach – Pages 22 – 41 Murach – Pages 46 – 57
Murach – Pages 58 – 71
Challenge 1 |
3 |
*1/30/18 |
QUIZ 1 – HTML
Chapter 2 – How to code a PHP application
Activities:
|
Challenge 2.1 |
4 |
2/6/18 |
Virtual Class – Via Pre-Recorded Webex
Chapter 2 – How to code a PHP application • Loops and Counters Chapter 2 – How to code a PHP application • How to use PHP documentation
Activities: • Exercise 2.3,2.4 • Review challenge solutions 2.2,2.3 • Review for Exam 1 |
Murach – Pages 72
– 91
Challenges 2.2 and 2.3 |
5 |
2/13/18 |
Exam 1
Review HTML Quiz Chapter 3 – Introduction to relational databases and MySQL • An introduction to relational databases • The SQL statements for data manipulation • An introduction to MySQL • How to use phpMyAdmin
|
Murach – Pages 96
– 123 |
6 |
2/20/18 |
Activities:
• Exercise 3.1 • MySQL Exercise 1 • MySQL Exercise 882 – (KickStarter) • Updating your MySQL password, Export/Import your Work (Self-Guided Tutorials under Exercises)
|
Lynda – MySQL
Essential Training with Bill Weinman, Chapter 2 |
7 | 2/27/18 | Quiz 2 – MySQL
Review Exam 1 |
|
8 | 3/6/18 | Spring Break – No Class! | |
9 | 3/13/18 | Chapter 4 – How to use PHP with a MySQL database
• Intro to PDO • Using PDO with INSERT, UPDATE and DELETE • Using PDO with SELECT statements
Activities: • PDO Exercise 1 & 2 (Lecture Companion) · PDO Exercise 3
|
Murach – Pages
126 – 137Murach – Pages 138 – 156
|
10 |
**3/20/18 |
Chapter 5 – How to use the MVC pattern
• Introduction to functions
Chapter 6 – How to test and debug a PHP application • An introduction to testing and debugging • How to debug with xDebug and NetBeans
Activities: • PDO Exercise 4 (suggestion box with functions) (Lecture Companion) • Review challenge solution 4.1
|
Murach – Pages
160 – 179
Murach – Pages 192 – 202 Challenge 4.1
|
11 | 3/27/18 | Activities:
|
Challenge 4.2 |
12 |
4/3/18 |
Exam 2
Chapter 5 – How to use the MVC pattern • MVC concepts |
Murach – Pages 180 – 188 |
13 |
4/10/18 |
Virtual Class – Via Pre-Recorded Webex
Chapter 7 – How to work with form data
Chapter 7 – How to work with form data
Activities:
|
Challenge 5.1
Murach – Pages 210 – 223
Murach – Pages 224 – 230
|
14 |
4/17/18 |
Chapter 12 – How to work with cookies and sessions • How to work with cookies • How to work with sessions
Activities:
• Exercise 12.1,12.2 • Review challenge solution 7 & 12 • Review for final exam
|
Murach – Pages
326 – 339
Murach – Pages 350 – 365
Challenge 7 Challenge 12 |
15 | 4/24/18 | Exam 3 |
* Monday 1/29/2017 – Last day to add or drop a course
** Wednesday 3/21/2017 – Last day to withdraw from a course