Stored Procedure execution using MySQL Extension

Friends, here I am going to share an interesting thing which I faced recently.

In PHP, everyone knows to establish a mysql connection we use (This is the standard)

Presently, everyone is using Stored Procedures and to execute the Stored Procedure uses the MYSQLi Extension. But in previous versions of PHP which have no support for MYSQLi, it’s a been tricky. Because to execute Multi-Query statements(Stored Procedures), we have to enable it by adding two new parameters in mysql_connect. Otherwise it throws errors.


So the cod eshould look like

To read more about this, check this

http://www.devx.com/webdev/Article/42887/1954
http://www.php.net/manual/en/mysql.constants.php#mysql.client-flags

150 150 Burnignorance | Where Minds Meet And Sparks Fly!