PHP / MySQL Lesson Plan

February 17, 2020

Updated: March 23, 2020

Table Of Contents

• Some Quick Guide Lines
• PHP PDO, Prepared Statements, And Security
• A Simple Example
• Accessing Results And Outputting HTML
• Doing Joins In PHP
• Data Output Strategies
• Handling Errors
• More Error Handling
• Setting Up A Simple Configuration
• Creating A Full Database Class
• Using A Database Class To Insert Data
• Adding XSS Security Into Our Database Class
• Model / View / Controller aka MVC
• Expanding Our MVC Example
• Validating User Input
• Inserting A Form Into Multiple Tables
• Updating Your Records
• Strategies For Deleting Records
• More Database Security
• CSRF Application Security
• Creating A Log In System - Part 1
• Creating A Log In System - Part 2
• Creating A Log In System - Part 3
• Creating A Log In System - Part 4
• Creating A Forgot Password System Part 1