MYSQLI multi-SQL statement execution issues
Object creation
$mysqli = new mysqli (' localhost ', ' root ', ' nagiosxi ', ' Hrsystem ');
Connection error
if ($mysqli->connect_error)
{
Die (' Connect database error '. Mysqli_connect_error ());
}
$sql = "INSERT into login (user, pass, email, type) VALUES (' Dengchao1 ', MD5 (' dengchao123 '), [email protected] ', 0);";
$sql. = "INSERT into login (user1, pass, email, type) VALUES (' Dengchao1 ', MD5 (' dengchao123 '), [email protected] ', 0)";
$res = $mysqli->multi_query ($sql);
if ($res && $mysqli->affected_rows > 0)
{
echo "Insert ok
Rows: ". $mysqli->affected_rows;
}
Else
{
$mysqli->close ();
Die (' Insert error
'. $mysqli->error. $mysqli->close ());
}
if (!is_bool ($res))
{
$res->free ();
}
$sql = "SELECT * from Login";
$res = $mysqli->query ($sql);
echo $mysqli->error. "
";
if ($res)
{
while ($row = $res->fetch_row ())
{
foreach ($row as $key = $val)
{
echo "-$val";
}
echo "
";
}
}
if (!is_bool ($res))
{
$res->free ();
}
$mysqli->close ();
?>
Why do you get an error: Commands out of sync; You can ' t run the This command now
This error, the corresponding query statement is
$sql = "SELECT * from Login";
$res = $mysqli->query ($sql);
Very puzzled, please answer, no Baidu to.
------Solution--------------------
Release the multi_query result set first, then query