Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Now that PHP has true object-oriented capabilities, it's best practice to access databases using PDO (PHP Data Objects) and MySQLi. These methods produce database-neutral code that works with over a dozen systems, including MySQL, SQL Server, PostgreSQL, and SQLite. Learn how to use PDO and MySQLi to perform basic select, insert, update, and delete operations; improve security with prepared statements; and use transactions to execute multiple queries simultaneously. Author David Powers also covers advanced topics like instantiating custom objects, and compares PDO to MySQLi so you can decide which method is right for you.
Welcome to this course on accessing databases with Object-Oriented PHP. I'm David Powers. We begin with PHP data objects, PDO. PDO, produces database neutral code that works with more than a dozen database systems. Including MySQL, Microsoft SQL Server, PostgreSQL, and SQLite. Then we'll examine the object oriented interface of MySQL Improved, which is dedicated to MySQL.
You'll not only see how to perform basic select, insert, update, and delete operations,. But also how to improve security with prepared statements, and to use transactions to execute a series of queries as a single unit that commits changes only if all parts succeed. We'll also look at some advanced topics such as instantiating custom objects with values drawn from a database. So without more or do, let's start accessing databases with Object-Oriented PHP.
There are currently no FAQs about Accessing Databases with Object-Oriented PHP.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.