Building Dynamic Websites with PHP and MySQL
Pluralsight
Course Summary
In this course you will learn how to create dynamic, data driven websites using the LAMP stack.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction- 10m 56s
—Introduction 9m 11s
—Demonstration 1m 44sBuilding the LAMP Stack- 23m 29s
—Introduction 2m 58s
—Installation 17m 4s
—Alternatives 3m 27sAccessing Form Data with PHP- 26m 51sThe Lending Library's Database- 22m 4sAccessing a Database from PHP- 27m 32sDoing More with the Database- 34m 15sMaintaining State in Web Applications- 38m 47sGranting Privileges in MySQL- 20m 18sPutting it all Together- 42m 10sStaying Safe- 48m 28sGoing Further- 5m 29s