News Feed
Sections




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

Brian Swan's Blog:
SQL Server Driver for PHP Connection Options Transaction Isolation Levels
September 09, 2010 @ 13:53:32

On his blog today Brian Swan has posted the results of some of his research on transaction isolation levels in SQL Server PHP applications.

Last week I had the good fortune of presenting at the the Seattle PHP Meet Up on a topic I knew only a little about: transaction isolation levels. It was fun doing the homework to learn more and I'll share what I learned in this post. This post is only somewhat PHP-specific. I'll focus largely on the concepts behind database transactions and isolation levels. Most of the concepts I'll look at are database agnostic (although I will use SQL Server as the vehicle for explaining the concepts) and are supported by most relational database management systems out there (e.g. SQL Server, MySQL, Oracle, DB2, etc.).

He introduces database transactions for those not familiar (a key to understanding the rest of the post) and some PHP code that connects to a SQL Server and begins a transaction to update some banking information. He uses this example to show how to set up isolation levels like "READ UNCOMMITTED", "READ COMMITTED" and "SERIALIZABLE".

0 comments voice your opinion now!
transaction isolation level sqlserver driver tutorial


blog comments powered by Disqus

Similar Posts

Noupe.com: Beautiful Forms - Design, Style, & make it work with PHP & Ajax

Chris Hartjes' Blog: Metatesting: Understanding Mock Objects

Jakub Zalas' Blog: Mocking Symfony Container services in Behat scenarios with Mockery

Shashikant Jagtap: Behat2.4 : Painless installation with Composer

MaltBlue.com: Zend Form Mastery with Zend_Config - Part 2, Core Form Configuration


Community Events





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


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

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