How to enable php debugging in visual studio 2010 when using PHP Tools for Visual Studio 

You can goto this link http://www.devsense.com/products/php-tools/doc-demos and click on the last link named as Configuring remote debug  or you can go directly on this link - http://www.devsense.com/products/php-tools/doc-demos# . You will find this tutorial very easy and comprehensible , i hope you will also be able to leverage the power of debugging php in visual studio using this extension .

PHP PHP IDE, PHP Tools for Visual Studio, Remote Debugging, Debugging in Visual Studio

PHP IDE 

I recently started working on php and i was so reluctant to switch to it because of my ignorance and null knowledge about PHP IDE softwares present currently .

I used Sublime Text 2 for a while but it felt a lot tedious to work on bigger things using it . I started searching and found these two comfortable to work with 

1. http://www.jetbrains.com/phpstorm/

2. http://www.mpsoftware.dk/phpdesigner.php#.UaIKd0CnwQY

3. http://www.zend.com/products/studio/

But even though these are full fledged IDE's i missed visual studio a lot and i tried to get some solution so that i can code using VS 2010 and i found this extension which made my life a lot easier - http://www.devsense.com/products/php-tools/doc-demos.

PHP PHP IDE

MySQL transactions examples in PHP

 http://stackoverflow.com/questions/2708237/php-mysql-transactions-examples

mysql_query("SET AUTOCOMMIT=0");
mysql_query("START TRANSACTION");
$a1 = mysql_query("INSERT INTO rarara (l_id) VALUES('1')");
$a2 = mysql_query("INSERT INTO rarara (l_id) VALUES('2')");
if ($a1 and $a2)
{ 
mysql_query("COMMIT"); 
} 
else
{
mysql_query("ROLLBACK"); 
}

MySQL, PHP Transactions, PHP, MySQL