English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 04m | 714 MB
Learn how to interact with databases using object-oriented PHP code. In this intermediate course, Kevin Skoglund teaches powerful PHP techniques that streamline interactions with MySQL databases. PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that object-oriented programming (OOP) offers. Kevin shows how OOP techniques can optimize database queries, help manage sessions, and simplify user logins. He provides practical examples and tips to create objects that interact seamlessly with database rows, to build a content management system with HTML forms, to authenticate users, and to break up long lists of database data into smaller pages.
Note: This is an intermediate-level training course that assumes you have existing knowledge of PHP. To refresh your skills, check out PHP Essential Training and PHP: Object-Oriented Programming.
Topics include:
- Creating a project database and tables
- Connecting to the database
- Database queries with OOP
- The active record design pattern
- Defining a database-driven class
- Performing common database tasks with OOP
- Creating inheritable and reusable code
- Object-oriented user authentication
- Object-oriented pagination
Table of Contents
Introduction
1 Welcome
2 How to use the exercise files
3 What you need to know
Overview and Project Setup
4 Project overview
5 Create a project database
6 Create a database table
7 Project files
The Database Connection
8 Database credentials
9 Connect to the database
10 MySQLi methods and properties
11 Query using OOP
12 Disconnect from the database
Define a Database-Driven Class
13 Active record design patterns
14 Set the database
15 Define query methods
16 Build objects using record values
17 Find a single record
18 Display a detail page
Object-Oriented CRUD
19 CRUD operations
20 Create a record
21 Dynamic attribute list
22 Sanitize values for database
23 Find record to update
24 Update a record
25 HTML forms for OOP
26 Validations and errors
27 Delete a record
28 Create inheritable code
Object-Oriented Authentication
29 Admin class
30 Hashing passwords
31 Admin validations
32 Find by username
33 Verify password
34 Define a session class
35 Add page access control
36 Improve the session class
37 Session messages
Object-Oriented Pagination
38 Pagination concepts
39 Define a pagination class
40 Paginate bicycles
41 Previous and next page links
42 Numbered page links
Conclusion
43 Next steps
Resolve the captcha to access the links!