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

PHPMaster.com: Amazon DynamoDB: Store PHP Sessions with Load Balancer

Hiveminds Magazine: Using numbers in PHP function names

Vance Lucas' Blog: Get Only Public Class Properties for the Current Class in PHP

CodeForest.net: Key/value tables and how to use them in PHP and MySQL

Sebastian Bergmann's Blog: php|works 2006


Community Events





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


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

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