PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

NetTuts.com: PHP Database Access: Are You Doing It Correctly?

Note: This article was originally published at PHPDeveloper on 5 June 2012.
PHPDeveloper

In this new tutorial on NetTuts.com, they talk about one of the more fundamental connection types you can do in PHP - database connections. They want to be sure you're "doing it correctly" via PHP's PDO API.

We've covered PHP's PDO API a couple of times here on Nettuts+, but, generally, those articles focused more on the theory, and less on the application. This article will fix that! To put it plainly, if you're still using PHP's old mysql API to connect to your databases, read on!

They compare the three main methods for connecting to a MySQL database - mysql, mysqli and PDO - and how a typical mysql/mysqli codebase can be refactored to use PDO. They show examples of connections, error handling, fetching data, using prepared statements and snippets of code for CRUD (Create, Read, Update, Delete) handling.

Be sure and check out the comments - there's some great tips there too!