Montgomery College 2019-2020 Catalog 
    
    Mar 28, 2024  
Montgomery College 2019-2020 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

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




Add to Favorites (opens a new window)