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

NetTuts.com: Test Code Coverage: From Myth to Reality

Zend Developer Zone: Accessing DB2 Data Inside of i5/OS

Blake Gardner: Practical usage of PHP 5.5 generators: yield keyword

Do It Yourself Web Development: Setting Up Composer PHP Dependencies Manager in Windows

Nicolas Grekas (on Github): Improved handling of HTTP requests in PHP


Community Events





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


series podcast release code framework symfony2 refactor introduction testing experience laravel threedevsandamaybe opinion language unittest list developer install community interview

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