HOMEWORK
CLASS NOTES
  PDF Notes
   Homewok Guidelines
   Administrivia
   Binary Numbers
   Introduction to Server Side Scripting
   Project Specifications
   Introduction to Data Bases
  Lab Exercises
   Lab 1 - Functions
   Lab 2 - Arrays
   Lab 3 - Strings and Dates
   Lab 4 - Forms
   Lab 5 - Cookies
   Lab 6 - Files Warm-up
   Lab 6 - Files
   Lab 7 - MySQL
   Lab 8 - Create a New Table
   Lab 9 - Adding Records to a Table
   Lab 10 - Validation & redirection
  Powerpoint Slides
   Introduction
 MAIL TO LIST

HOME

Neal Christensen                            x3266    christen@msmc.edu 
Fall 2008                  Office Hours: MTWT 4:00 - 5:00
Class Time: MW 5:15-6:40             Study Group: TBD

Course Description/Scope:

An Introduction to Server Side Scripting. A suitable programming language will be used to demonstrate the use of server side scripting for creating dynamic web pages, accessing server resources, and using server-resident files and data bases

Credits: 3

Pre-requisites

CIT190, or permission of the Division.

Required and Recommended texts:

Meloni, Julie , Sams Teach Yourself PHP, MySQL and Apache All in One, Sam's Publishing, 2005

Course Outcomes:

I. Context
The student will be able to explain the relationship between Web Pages, Scripts, Browsers, Web Serversand Data Bases

II. PHP
 A. The student will understand thestructure and syntax of PHP program statements and scripts.
 B. The student will be able write PHP scripts to access user-supplied variables from HTML forms and URLs.
 C. The student will be able write PHP scripts to access server files and server data bases.
 D. the student will be able to write PHP scripts which use server supplied resources such as environment variables and Date/Time data
 
III. MySQL
 A. The student will be able to define what is meant by flat-file data bases, relational data bases, and SQL
 B. The student will be able to create MySQL data bases
 C. The student will be able to write command-line SQL queries
 D. The student will be able to write PHP scripts using MySQL functions and statements to access MySQL data bases

Procedure to attain objectives/Teaching & Learning Strategies:

Classroom lectures and laboratory exercises. The faculty's web site will be used extensively to provide course information, homework assignments, and appointment signup. The learning environment will provide access to a Web Server with PHP and MySQL support.. Homework and project(s) will be assigned. There will be two major exams consisting of both written and on-line components.

Course requirements, weights, penalties for late submissions and absences:

Homework: 25%; Projects: 20%; Exams:50%; Labs: 5%

Homework will be php scripts uploaded to the courses web site set up for the course. A the list server will be set up for the course. It is required that you have e-mail and web access in order to have access to all course materials. Labs will be graded based on whether you completed the tasks specified for each lab.

There is no explicit penalty for excessive absenteeism. Absence will reap its own reward.

Grading scale:

  B+: 84-86 C+: 74-76 D+: 64-66  
A: 93-100 B: 80-83 C: 70-73 D: 60-63 F: 0-59
A-: 87-92 B-: 77-79 C-: 67-69    

Attendance Policy:

Attendance will be taken daily. In accordance with the registrar's rules, three consecutive unexplained absences will be reported to the Registrar.

Bibliography and Required Readings:

There will be class handouts in addition to the required text.

Topical Outline and Course Calendar:

WEEK
TOPIC
TEXT REF.
1
Introduction; PHP Basics (Variables & Operators) Class Notes; Ch. 5
2
PHP Flow Control Ch 6
3
Functions - lab 1 Ch 7
4
Arrays - lab 2 Ch 8
5
Strings, Dates & Times - lab 3 Ch 10
6
Review, Exam 1  
7
Forms Ch 11
8
Cookies & Files - lab 4 Ch 12, 13
9
 Files - Lab 6 Ch `13
10
Data Bases, SQL Class Notes; Ch 16, 18
11
PHP MySQL Functions - Lab 7 Ch 18
12
 MySQL labs 8, 9  
13
 Review; Exam 2  
14
 Lab 10; Project Lab  
15
 Project Lab