PHP & MySQL

WEB-212

PHP and MySQL students combine two of the most popular tools on the web to create dynamic websites. Students plan and implement full stack database solutions, focusing on the back end technologies. Students create databases in MySQL and combine Structured Query Language with PHP to store and retrieve information on a web database while interacting with the user through an HTML interface.
WEB 105 and PRG 105 with a grade of C or higher.
Students will:

1. Manage web based database systems

2. Create database tables

3. Send and retrieve data to and from a web database

4. Control the database using the Structured Query Language

5. Address web security issues

6. Create dynamic web pages

7. Create web applications

I. Modern Web Applications

A. PHP

B. Local server

C. Remote server

D. PHP vs HTML

II. PHP Syntax

A. Web forms

B. Text

C. Arrays

III. MySQL

A. Installation

B. Talking to the database with SQL

IV. Dynamic Web Pages

A. Connecting PHP to MySQL

B. Regular Expressions

C. Generating Dynamic Web Pages

V. Web Applications

A. Handling Errors

B. Handling Images

C. Binary Objects

D. Managing Users

VI. Security

A. Authentication and Authorization

B. Cookies

C. Sessions