'Doctrine PHP - Get multiple table data by calling stored procedure
I would like to get 2 table data from doctrine PHP by calling Stored Procedure.
Getting 2 table data from stored procedure is my business logic.
MYSQL Procedure:
DELIMITER $$
USE `test`$$
DROP PROCEDURE IF EXISTS `pr_test`$$
CREATE DEFINER=`root`@`%` PROCEDURE `pr_test`()
BEGIN
SELECT UUID() AS `uuid`;
SELECT "Large Data Set";
END$$
DELIMITER ;
PHP Code:
$stmt = $em->getConnection()->prepare("CALL pr_test()");
$stmt->execute();
$data = $stmt->fetchAll();
I am able to get only the data set. couldn't able to get the second table.
I have checked the documentation, and there is the method called - nextRowSet() but it was removed in new doctrine versions.
Is there any way that I can achieve multiple table rowsets?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
