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
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.
Click here for the Fall 2020 Class Schedule
Click here for the Extended Winter 2021 Class Schedule
Click here for the Winter 2021 Class Schedule
Add to Favorites (opens a new window)