Assignment One - Server Side Includes, DocRoot, Constants, and Date
In this assignment the student will create an interface for the class. The interface should be designed for all of the VT4000 assignments. Students should use includes and other concepts presented in class as part of the interface. Organization structure, functionality (that it works properly), and artistic implementation will be the most significant parts of the grade. Additionally, the student will write a basic PHP script to display the current date.
Assignment Two - Web Capture Using Forms
In this assignment the student will create an HTML form with the following field elements: Name, Address, City, State, Country, Phone, Email, Products, Comments (see index.php in week two notes). Next the student will make a script to echo the form results both to a web page as well as e-mail the results of the form to their own personal e-mail address.
Assignment Three - Flat File Commenting System
In this assignment the student will create a commenting system using html forms and PHP that process comment data to a flat file on the server. The form process will also include a view capability utilizing data from the flat file environment.
Assignment Four - MySQL Basics (Tables and Relational Databases)
In this assignment the students will explore MySQL database tables. Specifically the student will create four database tables. One of the tables, a registration database table will have the following 10 (ten) elements: firstName, lastName, address, city, state, zip, phone, email, age, sex. Insert a number of (say 10) sample records into the database table.
Next the student will create three tables that will be used in a relational database situation. These database tables will be created with the purpose of having specific relationships to other tables, meaning data will be provided through relationshipes between tables and data within those tables. MySQL queries will provide information from multiple tables. The student will need to create a single form to populate the database tables (see notes for week 4)
The first four tables will be created from the MySQL prompt. An additional part of this assignment for students is to install and learn to use phpMyAdmin, a MySQL database/web management tool. Students will use this tool to create databases, tables, manage and edit records, etc.
Assignment Five - PHP MySQL Database Integration
In this assignment the student will learn how to manage databases using PHP and Web Interfaces. Specifically, the student will create MySQL table(s) and manage those tables through PHP scipts via a web browser. The MySQL database table should have an HTML/PHP submit page, view page, and edit capability (delete or change). The web based PHP/MySQL system should be visually pleasing as well as intiutive for users. Sample records should be input into the database tables so that deleting, adding, and editing can take place.
Additionally, students will need to capture data that will be inserted into multiple tables as well as manage data/table/etc. via the web using add, edit, and delete functions.
Assignment Six - Security, Authorization, and Passwords
In this assignment the student will use PHP and MySQL to password protect the web management and administration pages from Assignment Four. An administrator username and password should be chosen by the student.
Assignment Seven - Voting
In this assignment the student will create a voting system using php and mysql. Examples and code provided in class and the student will alter the existing system as assigned by the instructor.
Midterm
The midterm will be given week 8 (or so) of the semester.
STUDENT PRESENTATION
Student Presentation - The student will research and present a topic (such as a function, concept, etc.) relevant to this course and approved by the instructor. The student will be given about 20 minutes to instruct the class on the chosen subject. Plan on presenting between week 8 and week 11 of the semester.
Assignment Eight - Dynamic Web Delivery - Web Management System -- Your Choice
In this assignment the student will create an integrated PHP/MySQL system. This system will showcase the key concepts and elements of the course. This assignment will be presented to the class. The assignment must be pre-approved by the instructor.
Final Exam
The final exam will be taken week 15 of the semester.
Send questions and comments to
pedersen@dixie.edu
