MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Building Dynamic Websites with PHP and MySQL

Course Summary

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 lib

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Demonstration
    ● Building the LAMP Stack
        ◦ Introduction
        ◦ Installation
        ◦ Alternatives
    ● Accessing Form Data with PHP
        ◦ HTML forms
        ◦ Accessing Form Data with PHP
        ◦ Validating User Input
        ◦ Demonstration -- Input Validation
    ● The Lending Library's Database
        ◦ Designing the Database
        ◦ Creating and Populating the Database
        ◦ Querying and Updating the Database
    ● Accessing a Database from PHP
        ◦ Introducing PDO
        ◦ Connecting to the Database
        ◦ Book Search Demonstration
        ◦ Quoting and Input Validation
        ◦ mysqli
    ● Doing More with the Database
        ◦ Using Prepared Statements
        ◦ Non-queries and Summary Functions
        ◦ Creating and Using Stored Procedures and Functions
        ◦ Lesson Summary
    ● Maintaining State in Web Applications
        ◦ The Problem of Maintaining State
        ◦ PHP Sessions
        ◦ Using Hidden Fields
        ◦ Using Cookies
        ◦ Lesson Summary
    ● Granting Privileges in MySQL
        ◦ Introduction to the MySQL Privilege Model
        ◦ Creating Accounts and Granting Privileges
        ◦ Accounts for the Library Application
        ◦ Lesson Summary
    ● Putting it all Together
        ◦ Site page flow and Folder Layout
        ◦ Demonstration of the Public Site
        ◦ Public site code Walkthrough, Part 1
        ◦ Public site code Walkthrough, Part 2
        ◦ Demonstration of the Admin Site
        ◦ Admin site code Walkthrough, Part 1
        ◦ Admin site code Walkthrough, Part 2
    ● Staying Safe
        ◦ Introduction to Web Site Security
        ◦ Network Level Security
        ◦ SQL Injection Attack and Defence
        ◦ Database Backup Tools
        ◦ MySQL Log Files
        ◦ Using Binary Logs for Data Recovery
        ◦ Replication and Enterprise Backup Solutions
    ● Going Further
        ◦ Going Further


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top