Re: Calling stored procedure from PHP

[Markus Popp]

Now it works :-) ... thanks! It's some quite complicated syntax (compared to what I'm used to), but the important thing is that it works.

Here's a little example:

<table>
<tr>
<th>Name</th>
<th>Continent</th>
<th>Language</th>
<th>isOfficial</th>
<th>percent</th>
<th>PeopoleSpeaking</th>
</tr>
<?php
$sql = "call getLang()";

if ($mysqli->multi_query($sql))
{
do
{
if ($result = $mysqli->use_result())
{
while ($data = $result->fetch_row())
{
echo "<tr>\n";
echo "\t<td>".$data[0]."</td>\n";
echo "\t<td>".$data[1]."</td>\n";
echo "\t<td>".$data[2]."</td>\n";
echo "\t<td>".$data[3]."</td>\n";
echo "\t<td>".$data[4]."</td>\n";
echo "\t<td>".$data[5]."</td>\n";
echo "</tr>\n";
}
$result->close();
}
} while ($mysqli->next_result());
}
?>
</table>

--
Markus Popp, Web Developer, mysql.com
Oracle Austria