ITP 304

Final Project due Wednesday, 05/01 by 11:59pm.

General Info

Instructor: Zune Nguyen (zune@usc.edu)
Lectures: Tuesdays, 2pm - 3:50pm
Labs: Asynchronous
Syllabus: 31837.pdf
Grader:
Sara Alvarado (saraalva@usc.edu)

Resources

Server Info

General

PHP

Some Data Sources

Extras

cURL & APIs

Course Outline

Week Lecture Lab Assignment
15
04/23 		Web Frameworks, Laravel
Lecture Files:
14
04/16 		cURL
Lecture Files:
13
04/09
File Upload, AJAX
Lecture Files:
Lab 12: Single-Page DVD Search (Extra-Credit)
due Friday, 04/12 by 11:59pm.
12
04/02 		Membership System, Mail
Lecture Files:
Lab 11: Contact Page w/ Email Confirmation
due Friday, 04/05 by 11:59pm. 		Assignment 10: Final Project Database
due Monday, 04/15 by 11:59pm.
11
03/26 		Sessions, Cookies
Lecture Files:
Lab 10: Dashboard w/ Sessions
due Friday, 03/29 by 11:59pm. 		Assignment 9: Final Project Front-End Pages
due Monday, 04/01 by 11:59pm.
10
03/19
Exam
9
03/05 		Include, Require, Constants, Pagination
Lecture Files:
Lab 9: Football Schedule Pagination (Extra-Credit)
due Friday, 03/08 by 11:59pm. 		Final Project
due Wednesday, 05/01 by 11:59pm.
Assignment 8: Final Project Proposal
due Monday, 03/25 by 11:59pm.
8
02/27 		CRUD Part 2
Sample Midterm Questions
Lecture Files:
Lab 8: Football Schedule Update, Delete Pages
due Friday, 03/01 by 11:59pm. 		Assignment 7: DVD Update, Delete Pages
due Monday, 03/04 by 11:59pm.
7
02/20 		CRUD Part 1
Lecture Files:
Lab 7: Football Schedule Insert Pages
due Friday, 02/23 by 11:59pm. 		Assignment 6: DVD Insert, Detail Pages
due Monday, 02/26 by 11:59pm.
6
02/13 		PHP MySQLi
Lecture Files:
Lab 6: Football Schedule Search Pages
due Friday, 02/16 by 11:59pm. 		Assignment 5: DVD Search Pages
due Tuesday, 02/20 by 11:59pm.
5
02/06 		Intro to PHP
Lecture Files:
Lab 5: PHP Page
due Friday, 02/09 by 11:59pm. 		Assignment 4: PHP Form Output
due Monday, 02/12 by 11:59pm.
4
01/30 		Data Manipulation in SQL
Lecture Files:
Lab 4: MAMP, SQL Statements
due Friday, 02/02 by 11:59pm. 		Assignment 3: Full SQL Statements
due Monday, 02/05 by 11:59pm.
3
01/23 		Intro to SQL, Retrieving Data from DB
Lecture Files:
Lab 3: Song DB SELECT SQL Statements
due Friday, 01/26 by 11:59pm. 		Assignment 2: Football & DVD DB SELECT SQL Statements
due Monday, 01/29 by 11:59pm.
2
01/16 		Database Basics, Designing Databases Lab 2: Simple Film Database Design
due Friday, 01/19 by 11:59pm. 		Assignment 1: Football Schedule Database Design
due Monday, 01/22 by 11:59pm.
1
01/09 		Course Overview, Content Workflow Lab 1: cPanel Setup, Student Page
due Friday, 01/19 by 11:59pm.

Student Pages