php mysqli_next_result,PHP mysqli_next_result() 函数_程序员人生

实例

执行多个针对数据库的查询。请使用 mysqli_next_result() 函数来准备下一个结果集：

$con=mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection

if (mysqli_connect_errno($con))

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$sql = "SELECT Lastname FROM Persons ORDER BY LastName;";

$sql .= "SELECT Country FROM Customers";

// Execute multi query

if (mysqli_multi_query($con,$sql))

{

do

{

// Store first result set

if ($result=mysqli_store_result($con))

{

while ($row=mysqli_fetch_row($result))

{

printf("%sn",$row[0]);

}

mysqli_free_result($con);

}

}

while (mysqli_next_result($con));

}

mysqli_close($con);

?>