Advanced PHP Database Integration

Advanced PHP Database Integration

Students taking this PHP course should already have basic PHP and MySQL skills. They will build upon those skills to learn to build database-driven websites from PHP and MySQL.

3 Months Access / 32 Course Hrs
  • Details
  • Syllabus
  • Requirements


PHP has been a popular server-side web technology for almost two decades—longer than any other commonly used programming language for building database-driven websites. Although PHP can be used with any of the popular databases (e.g., SQL Server, Oracle, PostgreSQL), it is most commonly paired with MySQL. The MySQL training portion of the course covers the MySQL-PHP connection. Learning to use PHP and MySQL together positions you well for jobs maintaining the millions upon millions of websites built on these technologies. You will also be able to build websites from scratch, though you will need to know other technologies, such as HTML and CSS.


  1. Working with Databases
    1. Objects
    2. Attributes / Properties
    3. Behaviors / Methods
    4. Classes vs. Objects
    5. Connecting to a Database with PDO
    6. Introducing the Poetree Database
    7. phpMyAdmin
    8. Querying Records with PHP
    9. Queries Returning Multiple Rows
    10. Adding Pagination
    11. Sorting
    12. Anticipating Foul Play
    13. Filtering
  2. Exception Handling
    1. Uncaught Exceptions
    2. Throwing Your Own Exceptions
    3. Catching Exceptions
    4. Exceptions
    5. Division Form
    6. PDOExceptions
    7. Logging Errors
    8. The dbConnect() Function
    9. When Queries Fail to Execute
    10. Preparing for the Catching Errors Exercise
    11. Catching Errors in the PHP Poetry Website
  3. Sending Email with PHP
    1. mail()
    2. Setting Up PHPMailer
    3. Mail Server
    4. Including a Mail Configuration File
    5. Sending Email with PHPMailer
    6. PHPMailer Methods and Properties
    7. Creating a Contact Form
  4. Authentication with PHP and SQL
    1. The Registration Process
    2. Passwords and Pass Phrases
    3. Registration with Tokens
    4. Creating a Registration Form
    5. Sessions
    6. Cookies
    7. Logging In and Out
    8. $_REQUEST Variables
    9. Resetting the Pass Phrase Introduction
  5. LAB: Inserting, Updating, and Deleting Poems
    1. Submitting a New Poem
    2. Showing All User's Poems in on the Poems Page
    3. Editing an Existing Poem
    4. Deleting a Poem



  • Basic PHP skills
  • Basic SQL with MySQL skills
  • HTML
  • CSS is useful


Hardware Requirements:

  • This course can be taken on either a PC or Mac. Chromebooks are not compatible.

Software Requirements:

  • PC: Windows 8 or later.
  • Mac: macOS 10.10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Acrobat Reader
  • Software must be installed and fully operational before the course begins. Setup instructions can be found here.


  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Self-Guided Course Code: T14526