SCHEDULE
The instructor reserves the right to change the specifics of this class (weekly topics of instruction, assignments, assignment details, etc.) as required for the betterment of the class. Changes will be announced in a timely manner during the instruction periods.

WEEK ONE - Intro

• Introductions
• Syllabus, book, online or web resources
• Expectations of the course
• Account Access - Setup usernames and passwords
• Log in to accounts, upload files (FTP or SSH), discuss server environment
• explain how PHP works, simple exercise demonstating PHP - displaying the current date
• explain how server side includes work, docroot, constants, simple exercise using server side includes
• Assignment One Due following week

WEEK TWO - PHP Presentation

• Review
• Check Assignment One
• PHP Form Processing
• Forms and Variables
• Sending e-mail with PHP

WEEK THREE - Flat File Commenting System

• Review
• Check assignment Two
• forms to flat file
• flat file to web

WEEK FOUR - SQL Presentation

• Review
• Check Assignment Three
• Introduction to MySQL
• Usernames and passwords
• SSH and MySQL
• Databases basics - Structured Query Language
• Create a table
• Inserting and Querying

WEEK FOUR and FIVE - PHP and MySQL Integration

• Review
• Check Assignment Four
• Using the registration database we will create a form that will insert records into the database
• PHP MySQL functions - mysql_connect, mysql_select_db, mysql_query
• Write PHP script that will read rows of information
• MySQL functions - mysql_fetch_row
• phpMyAdmin -- managing database/tables in web interface

WEEK SIX - HTTP Authorization

• Review
• Check Assignment Five
• Using Password files and encryption
• Using PHP and MySQL for authorization

WEEK SEVEN - Voting System -- MIDTERM EXAM REVIEW

• Review
• Check Assignment Six

WEEK EIGHT - MIDTERM EXAM and Check Assignment 7

WEEK NINE - PHP/MySQL STUDENT PRESENTATIONS and Concepts

• Group One
• Group Two
• Group Three

WEEK TEN

• Group Four
• Group Five
• Group Six

WEEK ELEVEN

• Group Seven
• Group Eight
• Group Nine

WEEK TWELVE, THIRTEEN and FOURTEEN - Assignment 7 - Student "YOUR CHOICE" Projects - questions and answers

• Web Management Projects - PHP/MySQL - Search, project stuff
• To be determined by students - so start thinking of questions

WEEK FIFTEEN - Final Exam and Student Presentations (assignment 7)

Last Updated 01/06/08

Send questions and comments to
pedersen@dixie.edu