UW Computer Training

R545: Intermediate PHP and MySQL Programming

Description:
Learn concepts of relational database design, data normalization, security issues , and MySQL server administration. This hands-on course provides you with sample code and class projects.

In this class you will be creating a PHP Social networking Portal application. Through the development of this application we will go through various Intermediate PHP concepts including but not limited to:relational tables, form validation, functions, sessions and security hacks.

• Getting Started
• What version of php are we using?
• Make sure it works
• Install & configure MySQL
• Install & configure PHPMyAdmin
• Test the database connection
• Review of basic concepts
• Variables, Strings and Numbers
• Understaning forms w/ $_POST, $_GET arrays
• New versus the old
• History of PHP
• PHP 4 vs PHP 5
• What is an Object?
• The Database Schema
• Explaining the data types
• Data normalization
• What are we building and what tables do we need?
• User Registration
• Using UWNetID and Alternatives
• Check to see if user already exists
• Regular expressions for form validation
• Displaying error message using sessions
• Verifying user registration via email
• MySQL Date & Time Functions
• Resetting a users Password
• Setting user permissions
• Creating your profile
• Form elements & Validation
• Upload multiple photos
• Validate file type & Image size
• Adding more features
• Adding a friend
• Posting a picture comment
• Searching for Users
• Displaying results
• Administering Mysql
• Adding/Removing users
• User Permissions
• Local and Remote connections
• Resources
• Books
• Users groups
• Email lists

Prerequisite:
R535 Introduction to PHP or PHP programming experience; familiarity with Unix command line

Course Fee:
$420 staff, alumni and faculty, $210 students