MP9005: Web Development - Using PHP with MySQL > PHP and MySQL

This course provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information. 

Topics:
Modifying the template
Connecting to MySQL and selecting the database
Executing simple queries
Retrieving query results
Ensuring secure SQL
Counting returned records
Updating records with PHP

Objectives:
Describe how arguments and PHP functions relate to the database
Differentiate between simple and complex functions depending on execution results
Understand the importance of associative and indexed arrays.
Modify specific scripts to allow for secure data transmission
Update database records using PHP scripts

Duration:
2 Hours