PHP: Accessing Databases with PDO and MySQLi
With David Powers
Liked by 780 users
Duration: 3h 47m
Skill level: Advanced
Released: 7/7/2014
Course details
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Nathan Antwi
Nathan Antwi
Backend Software Engineer @ Lockheed Martin DevSecOps & Cloud Security
-
September Twentyone
September Twentyone
--
-
John Chintall, Ph.D.
John Chintall, Ph.D.
Principal Consultant at The Chintall Group
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone