execute mysql stored procedures with CodeIgniter

[eluser]alx_benjamin[/eluser]
This is what you need to do.

In CI open file system/database/drivers/mysql/mysql_driver.php and
change function db_connect to:

Code:

function db_connect()
    {
    define("CLIENT_MULTI_RESULTS",131072);//Enable/disable multi-results
    define("CLIENT_MULTI_STATEMENTS",65536);//Enable/disable multi-statement support
        
    return @mysql_connect($this->hostname, $this->username, $this->password, TRUE,CLIENT_MULTI_STATEMENTS);
    }

Then go to config/database.php and change

Code:

$db['default']['pconnect'] = TRUE;

to

Code:

$db['default']['pconnect'] = FALSE;

Enjoy!

Alex