PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi,
I'm stuck with this error. give me hint.
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
No isn't due to the $result->close(); it's due to the second call consecutive.
I read this on the php.net
If you use MYSQLI_USE_RESULT all subsequent calls will return error Commands out of sync unless you call mysqli_free_result()
Try running this on your server using the query you entered above. If this works, then there is a problem with your class code that needs to be resolved.
<html>
<head><title>Stored Procedure Tester - MySQL</title></head>
<body>
<?php
$sql = '';
$show_results = false;
if (isset($_POST['form_submitted']))
{
// The form was submitted
$sql = $_POST['query'];
echo '<p>The query you entered entered was <strong>' . $sql . '</strong>.</p>';
// Make sure you add your information here
$mysql = new mysqli('localhost', 'database-username', 'database-password', 'database-name');
if (mysqli_connect_errno())
{
die(printf('MySQL Server connection failed: %s', mysqli_connect_error()));
}
// Check our query results
if ($mysql->multi_query($sql))
{
$show_results = true;
$rs = array();
do {
// Lets work with the first result set
if ($result = $mysql->use_result())
{
// Loop the first result set, reading it into an array
while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
$rs[] = $row;
}
// Close the result set
$result->close();
}
} while ($mysql->next_result());
}
else
{
echo '<p>There were problems with your query [' . $sql . ']:<br /><strong>Error Code ' . $mysql->errno . ' :: Error Message ' . $mysql->error . '</strong></p>';
}
$mysql->close();
}
echo '<form id="proc_tester" action="' . basename($_SERVER['SCRIPT_FILENAME']) . '" method="post">
<p>Enter your procedure:</p>
<p><input type="text" name="query" size="175" maxlength="255" value="' . $sql . '" /></p>
<p><input type="hidden" name="form_submitted" value="true" /><input type="submit" name="submit" value="Submit query" /></p>
</form>';
if ($show_results) {
echo '<pre>';
print_r($rs);
echo '</pre>';
}
?>
</body>
</html>