Prof Patrick J Wasson, MS

Schedule

 

Week

 

Date

 

Topics

Readings and tasks due
 

 

 

 

1

 1/18/17  

 

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://www.mis3501.xyz/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/25/17

Chapter 1 – Introduction to web development with PHP

  • How to edit and test a PHP application
  • How to use NetBeans to develop a PHP

Application

Chapter 2 – How to code a PHP application

  • Basic PHP skills
  • How to get data from a request

 

 

 

Activities:

  • Review Solution to Challenge 1
  • CSS exercise
  • Exercise 2.1
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

 

 

 

 

 

*2/1/17

QUIZ 1 – HTML

 

Chapter 2 – How to code a PHP application

  • Conditional Statements

 

Activities:

  • Exercise 2.2
  • Review challenge solutions 2.1

 

 

 

 

Challenge 2.1

 

 

 

 

4

 

 

 

 

2/8/17

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/15/17

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/22/17

Activities:

•    Exercise 3.1

•    MySQL Exercise 1

•    MySQL Exercise 2 – (KickStarter)

•    Updating your MySQL password, Export/Import your Work (Self-Guided Tutorials under Exercises)

 

Lynda – MySQL

Essential Training with Bill Weinman, Chapter 2

7 3/1/17 Quiz 2 – MySQL

 

 

Review Exam 1

8 3/8/17 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

·         Review Challenge Solutions 4.1

Murach – Pages

126 – 137Murach – Pages

138 – 156

 

 

 

 

 

 

 

 

 

9

 

 

 

 

 

3/15/17

 

Spring Break – No Class!

 

 

 

 

10

 

 

 

 

**3/22/17

Chapter 5 – How to use the MVC pattern to organize

your code

•     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/29/17 Activities:

  • Review Challenge Solution 4.2
  • Review for Exam 2
 Murach – Pages 180 – 188

Challenge 4.2

 

 

 

12

 

 

 

4/5/17

Exam 2

 

Chapter 5 – How to use the MVC pattern

•     MVC concepts

Activities:

  • Begin challenge 5.1 together in class
 

 

 

 

 

 

13

 

 

 

 

4/12/17

Chapter 7 – How to work with form data

  • Radio Buttons
  • Check boxes
  • Special characters

Chapter 7 – How to work with form data

  • Selection lists
  • text areas

 

Activities:

  • Review Challenge 5.1 solution
  • Exercise 7.1
  • Exercise 7.2

 

 

 

 

 

 

Challenge 5.1

 

Murach – Pages 210 – 223

 

Murach – Pages 224 – 230

 

 

 

 

 

 

 

 

14

 

 

 

 

 

4/19/17

 

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/26/17 Exam 3

* Monday 1/30/2017 – Last day to add or drop a course
** Wednesday 3/22/2017 – Last day to withdraw from a course