Development Index Page
336COURSE
- Midterm Study Guide
- Student Web Site List
- Web Development (CIT 336) Syllabus - Spring 2012
- Web Development (CIT 336) Web Site Criteria
- Web Site Evaluation List
- Web Site Evaluation Page
ASSIGNMENTS
- Data Case
- Data Retrieval Case
- Data Validation and Protection case
- Database Planning and Construction case
- Delete Data Case
- Site Hosting
- Syllabus Quiz
- Update Data Case
- View and Controller Case
BASICS
MEDIA
- 02 May - PHP Intro. Conclusion
- 04 May - Views and Controllers: Passing Parameters
- 07 May - Review of View and Controller Case Processes
- 09 May - Implementing Sessions
- 11 May - PHP Cookies
- 14 May - Arrays
- 16 May - Client Side Validation
- 18 April - Intro. to the M-V-C model
- 18 May - JQuery Validation library and rules
- 20 April - Q&A, Review of Basics, Request / Response Model
- 23 April - Database Table importing and Data Types
- 25 April - Reverse Engineering a web form to design a database table
- 27 April - Review of the Database Design case and grading policy change
- 30 April - PHP Introduction
- Views and Controllers: Passing Parameters
MYSQL
PHP
- DELETE Query — MySQLi Prepared Statement
- IF, IF-ELSE and ELSEIF Control Structures
- INSERT Query — Mysqli Prepared Statement
- Manually Adjusting Time Zone in a Date Function
- MySQLi and MySQL Database Connections
- PHP and MySqli Transactions with Prepared Statements
- PHP Arrays
- PHP Cookies
- PHP Sessions
- PHP Variables
- Prepared Statements (Using Mysqli) - Introduction
- SELECT Query (Distinct, Multiple Records) — Prepared Statement
- SELECT Query (Filtered, Single Record) — Mysqli Prepared Statement
- SELECT Query (multiple rows) — Mysqli Prepared Statement
- UPDATE Query — MySQLi Prepared Statement
RESOURCES
- AJAX RefCard
- Introduction to PHP (PDF)
- MySQL RefCard
- PHP RefCard
- Web Development Bookmarks
- World Database