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

The Code of a Ninja: Salt, Hash and Store Passwords Securely with Phpass

Greebo.net: Converting your PHP app to MySQLi prepared statements

Lorenzo Alberton's Blog: Create a video preview as animated GIF with FFmpeg and PHP SPL

Chris Jones' Blog: PHP OCI8 and Oracle 11g DRCP Connection Pooling in Pictures

Wez Furlong\'s Blog: PDO MySQL slides from MySQLUC 2006


Community Events





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


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

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