PHP: Accessing Databases with PDO and MySQLi

Sale!

Safe Payment

Secure payment via Credit Card, Don't keep any cards information.

Secure Download

All download sources is secure & reliable through Google Drive.

Lifetime Access

All softwares and products gets unlimited access & lifetime use.

If you are going to buy up from 5+ products through our website you can asking for 30% OFF Coupon code.

Categories PHP & MySQL, Videos Tags David Powers, PHP & MySQL Videos

PHP: Accessing Databases with PDO and MySQLi

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.

Video Demo Here :

Topics include:

Connecting to a database with PDO or MySQLi
Fetching a result set
Executing simple non-SELECT queries
Sanitizing user input
Binding input and output values
Passing an array of values to the execute() method
Working with advanced PDO fetch methods
Executing a MySQLi transaction
Freeing resources that are no longer needed
Submitting multiple queries
Creating an instance of a class from a result set

About the Author

David Powers has been developing websites since 1994 and writing books on web development since 2003.

He is an Adobe Community Professional and Adobe Certified Instructor for Dreamweaver. You’ll often find him giving help and advice in the Dreamweaver forums and the Adobe Developer Center, to which he has contributed many popular tutorials and training videos. He also greatly enjoys traveling and taking photos.