April 22nd, 2008, 02:35 AM
|
|
Registered User
|
|
Join Date: Apr 2008
Posts: 1
Time spent in forums: 44 m 49 sec
Reputation Power: 0
|
|
MDB2::bindParamArray() error
Hi,
I am newly joined in this forum and i have an issue.I need you people help to resolve issue.
And my issue was,
I am using PEAR package.
To run a queries we are using stored procedures.
We are running queries by using MDB2::prepare() function and we are binding arguments by using MDB2::bindParamArray().
Finally we are executing execute method.
I will give the code for you:
PHP Code:
$objstmt = $this->dbh->prepare('CALL sp_adminEmail_exists(:adminid, :licenseeId, :txtAdminEmail)');
$arrParams = array('adminid' => $input->fields['adminId'],
'licenseeId' => $input->fields['licenseeId'],
'txtAdminEmail' => $input->fields['adminEmail']);
$intBind = $objstmt->bindParamArray($arrParams);
$arrAdmin = $objstmt->execute();
$this->dbh we have the db connection and $input->fields indicates the posted values.
It is working fine... and cool.
But at some instances i am getting an error saying
"Lost connection to MySQL server during query and MySQL server has gone away"
How to resolve this issue and i am unable to find the occurrences to re-produce the same... It happening randomly.
Will you people please help me to resolve this issue.
Expecting favorable response
Thanks in advance
Prasanna.
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
