ZF-11580: Not able to fecth multiple resultsets from stored procedure using mysqli as a driver

Issue Type: Bug Created: 2011-07-20T06:45:26.000+0000 Last Updated: 2012-05-17T17:36:59.000+0000 Status: Open Fix version(s): Reporter: Satheesh Kumar (satheeshks80) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db

  • db
  • zend
  • zf-crteam-padraic
  • zf-crteam-priority

Related issues: Attachments:


I have a stored procedure "test_procedure" which will execute 3 select statements and returns 3 result sets. I can able to get all 3 result sets by using PHP native mysqli methods. But I could not achieve the same using Zend DB.

Code using Zend DB

$stmt=$db->prepare("call test_procedure(?,?,?)"); $stmt->execute(array(1,2,3)); $results = $stmt->fetchAll();

Is there any limitations in Zend DB adapter. then, is it possible to call native mysqli methods through Zend DB adapter.


Posted by Adam Lundrigan (adamlundrigan) on 2012-05-17T17:36:59.000+0000

Downgrading from blocker to major

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.