Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

PHP: Object-Oriented Programming with Databases

via LinkedIn Learning

Overview

Learn how to efficiently interact with databases using object-oriented PHP code.

Syllabus

Introduction
  • Welcome
  • How to use the exercise files
  • What you need to know
1. Overview and Project Setup
  • Project overview
  • Create a project database
  • Create a database table
  • Project files
2. The Database Connection
  • Database credentials
  • Connect to the database
  • MySQLi methods and properties
  • Query using OOP
  • Disconnect from the database
3. Define a Database-Driven Class
  • Active record design patterns
  • Set the database
  • Define query methods
  • Build objects using record values
  • Find a single record
  • Display a detail page
4. Object-Oriented CRUD
  • CRUD operations
  • Create a record
  • Dynamic attribute list
  • Sanitize values for database
  • Find record to update
  • Update a record
  • HTML forms for OOP
  • Validations and errors
  • Delete a record
  • Create inheritable code
5. Object-Oriented Authentication
  • Admin class
  • Hashing passwords
  • Admin validations
  • Find by username
  • Verify password
  • Define a session class
  • Add page access control
  • Improve the session class
  • Session messages
6. Object-Oriented Pagination
  • Pagination concepts
  • Define a pagination class
  • Paginate bicycles
  • Previous and next page links
  • Numbered page links
Conclusion
  • Next steps

Taught by

Kevin Skoglund

Reviews

4.7 rating at LinkedIn Learning based on 139 ratings

Start your review of PHP: Object-Oriented Programming with Databases

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.