I have a stored procedure
. I'm calling through PDO
. when I run the procedure in Phpmyadmin
. It return output like below.
Problem
I don't know how many columns will stored procedure returns. I need column name and its Value name.
My Attempt here
$sql = "call surveyreport (28);";
$stmt = $pdo->query($sql);
$a=array();
do {
$rows = $stmt->fetchAll(PDO::FETCH_NUM);
if ($rows) {
array_push($a, $rows);
}
} while ($stmt->nextRowset());
it returns
Array ( [0] => Array ( [0] => Array ( [0] => 1068 [1] => SATHIYA MOORTHI [2] => Yes [3] => ) [1] => Array ( [0] => 5000 [1] => Ben Praveen [2] => Yes [3] => ) ) )
How Can I get Column name? and Its value. Thank You.