Portland Community College | Portland, Oregon

Course Number:
CAS 225
Course Title:
PHP and MySQL for Designers
Credit Hours:
Lecture Hours:
Lecture/Lab Hours:
Lab Hours:
Special Fee:

Course Description

Develops skills for finding, utilizing and modifying PHP and MySQL resources on the Internet. Explores ways to personalize web sites for visitors with a variety of dynamic server-based techniques such as processing forms, displaying text or images from a database, implementing a shopping cart or a discussion board, tracking visitors, and password-protecting a web site. Includes how to install PHP and MySQL. Prerequisites: CAS 213 or instructor permission. Audit available.

Addendum to Course Description

This class is an elective for the CAS Web Site Development Certificate and the CAS Web Site Development and Design AAS Degree.

Intended Outcomes for the course

Upon successful completion students should be able to:

1. Find, utilize and modify PHP and MySQL resources on the Internet.
2. Upload, test, and deploy web pages containing PHP and MySQL.

Outcome Assessment Strategies

- Project(s) incorporating concepts learned in the class
- May include objective tests or scored assignments

Course Content (Themes, Concepts, Issues and Skills)

Server-side programming concepts
Introduction to Apache, PHP and MySQL
PHP syntax
Passing variables
Conditional processing
Introduction to arrays
Form processing and validation
Error handling and debugging
Cookies and sessions
Sending email
Handling file uploads
Database security issues
Introduction to MySQL and basic database concepts
Introduction to SQL retrieval queries
Introduction to object-oriented, 3-tier architecture