I cannot figure a way to retrieve the return statement in PHP. It works just perfect in MySQL, but this from PHP doesn't for some reason.
PHP Code:
<?php
public function call()
{
$out = array();
echo '<pre>';
if ($this->multi_query("CALL testOut(@outvar); SELECT @outvar;"))
{
do
{
if ($result = $this->store_result())
{
while ($row = $result->fetch_object())
{
$out[] = $row;
}
$result->close();
}
$this->next_result();
}
while ($this->more_results());
}
var_dump($out);
return (array) $out;
}
?>
|