PHP
Accessing Databases with PDO and MySQLi
Heads up! This course may be archived and/or unavailable.
Advance your Skills as a PHP Developer: Working with Data,
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.
Contents:
- Introduction
- 1. Why Use Object-Oriented PHP to Access a Database?
- 2. PHP Data Object (PDO) Basics
- 3. PDO-Prepared Statements and Transactions
- 4. Advanced PDO Fetch Methods
- 5. MySQL Improved Basics
- 6. MySQLi Prepared Statements and Transactions
- 7. Diving Deeper into MySQLi
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 3h 47m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | David Powers |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming Data Science |
Tags | Developer PHP Databases Programming Languages Back-End Web Development |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
PHP Wordpress Developer $49k
Developer (PHP or Python) $64k
PHP Developer 1 $69k
PHP/WORDPRESS ENGINEER $87k
HTML / PHP Developer $111k
php devloper $113k
PHP or Python Developer $119k
Senior PHP Programmer $123k
PHP Programmer Lead $126k
C#/PHP Developer $130k
PHP Architect $145k
PHP / Actionscript Developer $162k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 3h 47m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | David Powers |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Programming Data Science |
Tags | Developer PHP Databases Programming Languages Back-End Web Development |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course