Schedule

Week

Date

Topics

1

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

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

• 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

Murach – Pages 22

– 41

Murach – Pages 46

– 57

Murach – Pages 58

– 71

Challenge 1

3

*2/1/17

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

•    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

– 91

Challenges 2.2 and 2.3

5

2/15/17

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

– 123

6

2/22/17

•    Exercise 3.1

•    MySQL Exercise 1

•    MySQL Exercise 2 – (KickStarter)

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

Essential Training with Bill Weinman, Chapter 2

Review Exam 1

•    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

126 – 137Murach – Pages

138 – 156

9

3/15/17

Spring Break – No Class!

10

**3/22/17

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

160 – 179

Murach – Pages 192 – 202

Challenge 4.1

• Review Challenge Solution 4.2
• Review for Exam 2

Challenge 4.2

12

4/5/17

Chapter 5 – How to use the MVC pattern

•     MVC concepts

13

4/12/17

• 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

326 – 339

Murach – Pages

350 – 365

Challenge 7

Challenge 12