Course Objective:

This course will introduce the student to PHP programming. Topics include basic procedural programming concepts, interfacing with various data sources and MySQL databases, file manipulation, and integrating existing PHP code into a production web site.

Upon successful completion of this course the student will be able to create, design, and implement a database driven web site using the PHP programming language and a MySQL database. The student will have demonstrated proficiency in creating and setting up simple databases, interfacing with those databases using PHP and integrating third party PHP code into a production web site.

Course Credits:
Credit Type: lecture
Credits: 4

Textbooks and references:

PHP and MySQL Web Development, 3rd edition by Luke Welling & Laura Thomson. Published by Developer's Library/Sam's Publishing.

Course Prerequisites:

CCIS 1351 (Advanced HTML) and some programming experience.

Special Accommodations:

Any student who has any need for special accommodations in this course is encouraged to contact the instructor at the beginning of the course.

Supplies:

It is highly recommended that students have access to some type of portable storage media greater than 10 MB. Possible media types include: Zip Disks and USB data drives.

Course Requirements and Evaluation:

Grading:

Final grades for this course will be computed by adding the student's total points and dividing that sum by the total available points. Final grades will be determined as follows:

A = 90% or more

B = 80% - 89%

C = 70% - 79%

D = 60% - 69%

F = less than 60%

Point Distribution:

2 exams @ 100 pts 160 pts

1 final exam @ 200 pts 200 pts

12 homework assignments @ 30 pts 360 pts

Total Points: 720 pts

Exam Information:

All quizzes and exams are open book / open computer.

ALL MAKEUP EXAMS MUST BE ARRANGED IN ADVANCE AND MUST BE COMPLETED WITHIN ONE WEEK AFTER THE EXAM! ALL MAKEUP EXAMS MUST BE COMPLETED BEFORE THE LAST SCHEDULED CLASS SESSION.

Homework Information:

All homework must to be done on an individual basis. There are no team projects.

Studying together is strongly encouraged, however collaborating on homework or assignments is not.

Suggested reading will be made available during each session for the next class period.

ALL homework is due at the end of the following class period. Homework may be submitted online. The due date for homework submitted online is 11:59 pm (Central) on the day of the class period following the class period in which the assignment was given. Late homework will receive no credit.

Example:

Assignment is given on Monday 1/19/2007.

Homework is due in class by the end of class on 1/26/2007 or

online by 11:59pm (central) on 1/26/2007.

NO HOMEWORK WILL BE ACCEPTED AFTER THE LAST SCHEDULED CLASS.

Tentative Course Overview (subject to change)

• Week 1: Announcements and house keeping, Introduction to puTTY, Introduction to Secure FTP, XHTML and CSS Review. Web Design – separating content from presentation. Accessibility and Section 508.
  Homework: Assignment 1
  Reading:Chapter 1
  


• Week 2: History of PHP. What is PHP? What is Open Source? GPL and GNU. Installing Apache. Configuring Apache. Installing PHP. PHP configuration. Introduction to PHP.
  Homework: Assignment 2
Reading:Chapter 2


• Week 3: PHP commands. PHP variables, arrays, and associative arrays. Logical programming structures. Functions.
  Homework: Assignment 3
  Reading:Chapter 3
  
  
• Week 4: Super globals. Processing form data. Sessions. Include files.
  Homework: Assignment 4

Reading:Chapter 4

• Week 5: Reading and writing files using PHP. Uploading files to a web server. Overview of file permissions in Linux.
  Homework: Assignment 5
  
  
• Week 6: Review
  Exam: Exam 1


• Week 7: Overview of SQL commands. Insert, Update, Select, and Delete SQL commands. Using a MySQL database. Create MySQL Tables.
  Homework: Assignment 6


• Week 8: Using PHP to connect to a MySQL database. PHPs integrated MySQL functions. Querying MySQL and displaying results on a web page. Creating login scripts. Verifying credentials using MySQL and PHP
  Homework: Assignment 7
  


• Week 9: MySQL and SQL Review.
  Homework: Assignment 8
  
  
• Week 10: Sending Email notifications. Parsing XML. Reading RSS Newsfeeds. Debugging PHP Programs.
  Homework: Assignment 9


• Week 11: Review, Error Suppression.
  Homework: Assignment 10
  Exam: Exam 2


• Week 12: Regular Expressions. Integrating existing PHP scripts with a web site.
  Homework: Assignment 11


• Week 13: Special runtime configuration using ini_set() and other topics as requested.
  Homework: Assignment 12
  
  
• Week 14: Exam: FINAL EXAM – Have a great summer

Other Information:

Information regarding dropping or adding classes, academic misconduct, HTCs incomplete policy, and withdrawing from a course can be found in the student handbook. Free copies of the handbook are available at the Student Bookstore.
The last date to drop this spring semester course is May 1st, 2007

Classroom expectations:

Please set cellphones and pagers to "off" or "silent" and turn off any headsets during class hours.

Please feel free to ask questions during lectures. I am here to help you learn PHP, it is your responsibility to ask a question if you do not understand a topic. Remember, if you have a question, odds are 3 – 4 other people are wondering the same thing. Active participation will help you and other students.