Zend Framework

• Type: Unit Tests: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.2
• Fix Version/s: Next Major Release
• Component/s: Zend_Db, Zend_Db_Adapter_Mysqli
• Labels:

  None

Patrick Calkins wrote:

Code:

$db = Zend_Db::factory('Mysqli', array(
    'host'     => '127.0.0.1',
    'username' => 'webuser',
    'password' => 'xxxxxxxx',
    'dbname'   => 'test'
));

$userName = 'jo';
$password = 'xyzzy';

$stmt = $db->prepare('CALL authenticate_user(?, ?)');
$stmt->bindParam(1, $userName);
$stmt->bindParam(2, $password);
$stmt->execute();
$result = $stmt->fetch();

The bindParam statements call _bindParam in Zend/Db/Statement/Mysqli.php,
which have nothing more than a 'return true;' statement. It does not appear
the Mysqli bind_param function is implemented - is this correct?? If so does
anyone have any workarounds for using stored procedures in MySql 5.1??

Using the PDO_MYSQL driver does not help as it has a problem calling 2
stored procedures back-to-back (throws the 'SQLSTATE[HY000]: General error:
2014 Cannot execute queries while other
unbuffered queries are active.' error, which has been discussed before)...

Zend_Db_Statement_MysqliTest tests bound parameters with regular queries but not with stored procedures.

Also check to see where else these tests should appear.

• Assignee:

  Ralph Schindler

  Reporter:

  Darby Felton

• Created:

  24/Oct/07 2:44 PM

  Updated:

  22/Sep/09 5:32 AM