TECH 282 - Web Application Development Using PHP and MySQL

An introduction to the creation and maintenance of data- driven Web sites using PHP and MySQL. Create a MySQL database and maintain the database dynamically using the programming language PHP. PREREQUISITE(S): CMSC 140 or TECH 278 or consent of department. Three hours lecture/discussion each week. Formerly CMAP 282.

3 semester hours

Course Outcomes:
Upon course completion, a student will be able to:

Use MySQL to create, update and delete tables from a database.
Create related tables and define keys.
Create both inner and outer joins of two or more tables.
Use PHP to create a data driven website.
Use PHP to read a file and add records to the database.
Create a form on a webpage and use PHP to check the validity of the form.
Use the data from the form to update the MySQL database.
Use PHP to retrieve data from the MySQL database and display in various formats including tables.
Create a “member only” website using ID and password in a Myself database and check the validity of the user input using PHP.
Understand the basic program constructs such as if/else, switch, loops, arrays and functions and be able to use them in the PHP script.
Use built-in features of PHP such as data and string manipulation.
Test and debug PHP scripts while working with live data.
Alter the content of a web page dynamically using the combination of data from the MySQL database and PHP methods such as the type of browser the user has, the date, and time.

View Schedule of Classes