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.

SHARE
3 Months / 32 Course Hrs
Open Enrollment
Offered in partnership with your preferred school

ed2go

Change School
Learning method

Advanced PHP Database Integration

Enroll Now

Course code: T14526

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.

What you will learn

  • Learn to manipulate and manage database data with PHP
  • Learn to authenticate users with PHP
  • Learn to manage sessions with PHP
  • Learn to send email with PHP
  • Understand how MySQL works with PHP

How you will benefit

  • With PHP and MySQL skills, you will be able to create everything from intranets for companies needing to manage internal data to large database-driven websites
  • PHP has been around longer than any other commonly used server-side programming language, and there are millions of websites that still use it today. Knowing PHP opens up opportunities for you to maintain and build upon those websites
  • Organizations store data in databases and MySQL is the most popular open source database Knowing how to query those databases opens up opportunities for you to build reports for such organizations

How the course is taught

  • Self-Guided, online course
  • 3 Months access
  • 32 course hours
  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
Self-Study

Prerequisites:

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

Requirements:

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.

Other:

  • 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.

Your course begins immediately after you enroll.​

You have 3 months of access to the course. After enrolling, you can learn and complete the course at your own pace, within the allotted access period. You will have the opportunity to interact with other students in the online discussion area.

There is no time limit to complete each lesson, other than completing all lessons within the allotted access period. Discussion areas for each lesson are open for the entire duration of the course.

Because this course is self-guided, no extensions will be granted after the start of your enrollment.

Introduction to MySQL for PHP DevelopersFundamentalsIntroduction to PHPFundamentals
Fundamentals
Introduction to MySQL for PHP Developers
Fundamentals
Introduction to PHP