News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

NetTuts.com:
PHP Database Access Are You Doing It Correctly?
June 04, 2012 @ 13:33:54

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!

0 comments voice your opinion now!
mysql pdo tutorial connection refactor


blog comments powered by Disqus

Similar Posts

Iwan Luijks' Blog: Using Enchant with PHP on Windows - Part 1

SitePoint PHP Blog: Sophisticated Object Iterators in PHP

DevShed: Performing Basic Tasks with MySQL 4.1 and Above, using mysqli with PHP 5

DevShed: Creating a Simple Threaded Discussion Forum

Andrew Podner: Lithium: Getting Stuff From Your Database


Community Events





Don't see your event here?
Let us know!


api release unittest opinion interview introduction series language update framework podcast laravel package community library bugfix zendserver symfony install deployment

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework