Building Dynamic Websites with PHP and MySQL

In this course you will learn how to create dynamic, data driven websites using the LAMP stack.

In this course you will learn how to create dynamic, data driven websites using the LAMP stack. The course focuses on the integration of the LAMP components (especially MySQL and PHP) to create a complete working site. Throughout the course, a lending library that needs a web application to track its books and borrowers provides a scenario for discussion and demonstration. Attention is also paid to best practices for keeping the site secure. Students should have a basic prior knowledge of relational databases and SQL and of the PHP language (variables, operators, loops, branches, and simple string handling). Basic competence at the Linux command line (including the ability to edit text files) is also assumed. Students can follow along with all demos by pre-installing Centos 6 (or similar) into a virtual machine.

• Introduction 10mins
• Building the LAMP Stack 23mins
• Accessing Form Data with PHP 26mins
• The Lending Library's Database 22mins
• Accessing a Database from PHP 27mins
• Doing More with the Database 34mins
• Maintaining State in Web Applications 38mins
• Granting Privileges in MySQL 20mins
• Putting it all Together 42mins
• Staying Safe 48mins
• Going Further 5mins