Explore the most commonly used methods and properties of the MySQLi database adapter using their object-oriented syntax.
- [Instructor] Once we have a database connection object,…we can then ask that object for information…or to perform tasks for us.…After all, that's what object properties and methods…are designed to do,…to ask for information or to perform tasks.…Let's see what some of the methods and properties…that are available to us are.…The database connection object…has many properties and methods,…but there are really just four…which are most frequently used.…The first and certainly the one we use the most often…is the one to query the database.…The procedural version of this uses mysqli_query.…
The object-oriented version is just simply called query…and you're going to see this as a common pattern.…What used to be called mysqli_…is now whatever comes after that underscore…as the method name.…So here we have the database object,…we use the arrow notation,…the dash and the greater than sign,…and then the name of the method we want to call,…which in this case is just query.…Another common method we use is mysqli_real_escape_string…
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.
- 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
Skill Level Intermediate
Consuming RESTful APIs in PHP with Guzzlewith Justin Yost2h 12m Intermediate
PHP: Accessing Databases with PDO and MySQLiwith David Powers3h 47m Intermediate
1. Overview and Project Setup
2. The Database Connection
3. Define a Database-Driven Class
4. Object-Oriented CRUD
5. Object-Oriented Authentication
6. Object-Oriented Pagination
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.