Web Development with PHP and MySQL

CIS 86

Mission College

Fall 2015

Instructor: Mark Brautigam

Lessons

Every week there will be several activities:
  • A series of short online lectures that you can view at your convenience.
  • A multiple-choice quiz that you will take on Angel.
  • Short programming exercises that you will upload to your account on the PHP server.
  • Discovery projects that will eventually form your final group project.
  • A lab session on Thursday evenings in GC 202.
  • Homework is due on Wednesday nights.

Schedule

NOTE: This is a quick resource for you. In case of a discrepancy, the class syllabus takes precedence.

WeekChapterTopicsAssignmentsLectureLabDue
1 –

Orientation

What PHP is all about. Setting up a web server with PHP and MySQL support.

Install WAMP or MAMP

Install an FTP client

Install an SSH (Telnet) client

Install a text editor

Class Survey – Angel (due ASAP)

Personal Introduction – Angel (due ASAP)

Obtain the textbook (due ASAP)

 Aug. 31 Sept. 3 Sept. 10
2 A/B

HTML Review

Setting up a personal web server.

Read Appendix A and B

Set up personal web site on the PHP server

Get your team Assignments

 Sept. 8
(Tues.)		 Sept. 10 Sept. 17
3 1

Getting Started with PHP

PHP scripts and PHP code blocks. Variables, Constants, and Data Types. Expressions and operators.

Quiz

Exercises 1-1, 1-3, 1-4

Disc. Projects 1-1, 1-2, 1-3, 1-4

 Sept. 14 Sept. 17 Sept. 24
4 2

Functions and control structures

Functions and variable scope. If statements. Switch statements. For loops. While loops.

Quiz

Exercises 2-1, 2-3, 2-5

Disc. Projects 2-1, 2-2, 2-3, and 2-4 or 2-5

 Sept. 21 Sept. 24 Oct. 1
5 3

Strings

Regular Expressions.

Quiz

Exercises 3-2, 3-3

Disc. Projects 3-1 (second part), 3-4

 Sept. 28 Oct. 1 Oct. 8
6 4

Forms

User input. Web forms. Validating forms. Handling errors. Web page templates. Dynamic content.

Quiz

Exercises 4-2, 4-4

Disc. Projects 4-1, 4-2, 4-3, 4-4, 4-5

 Oct. 5 Oct. 8 Oct. 15
7 –

Project Review

Make sure your team Zodiac project on the PHP server is up to date

 Oct. 12 Oct. 15 Oct. 22
8 –

Midterm Exam

Midterm Exam – Multiple Choice – Angel

Midterm Exam – Hands On – Upload to PHP server

 Oct. 19 Oct. 22 Oct. 29
9 5

Files

Files and directories. File permissions. Uploading files.

Quiz

Exercises 5-1, 5-2

Disc. Projects 5-2, 5-5

 Oct. 26 Oct. 29 Nov. 5
10 6

Arrays

Quiz

Exercise 6-1

Disc. Projects 6-2, 6-3

 Nov. 2 Nov. 5 Nov. 12
11 7

Databases and MySQL

MySQL from the command line.

Quiz

Exercises 7-1, 7-2

Disc. Projects 7-1, 7-5

 Nov. 9 Nov. 12 Nov. 19
12 8

PHP and MySQL

Working with MySQL from PHP.

Quiz

Exercises 8-1, 8-2

Disc. Project 8-5

 Nov. 16 Nov. 19 Dec. 3
13 –

Thanksgiving

Get caught up to date if you are behind

 Nov. 23 – –
14 9

State

State Information. Hidden form fields. Query strings. Cookies. Sessions.

Quiz

Exercises 9-1, 9-2

Disc. Project 9-1

 Nov. 30 Dec. 3 Dec. 10
15 10

Object Oriented PHP

No Quiz

No exercises or projects for this chapter

Final Team Project Due

 Dec. 7 Dec. 10 Dec. 17
16 –

Final Exam

Final Exam – Multiple Choice – Angel

Final Exam – Hands On – Upload to PHP server

 Dec. 14 Dec. 17 Dec. 17-19