多重查询

<?php
//连接数据库product 数据表product
//mysqli---连接对象
//mysqli_result---select结果集对象
//mysqli_stmt  ---预处理对象
 
//第一步：连接数据库  mysqli
$mysqli = new mysqli("localhost","root","","product");

//mysqli_init();----不连接任何数据库情况下产生一个对象
//mysqli->query("set names utf8");

//第二步：mysqli_result
//$result = $mysqli->query("select * from product");

//insert update delete
//insert into product values().....;
//显示影响的行数、该字段的名称、指针在第几个列、字符串最大的长度？
//三个对象

//显示客户端版本
echo $mysqli->get_client_info();
echo "<br>";
//echo $mysqli->get_host_info();

echo $mysqli->get_server_info();
echo "<br>";

//执行多个查询
//multi_query   more_result  next_result
//store_result(将完整的结果集存储)  user_result(表示开始使用结果集)
//每条语句后用：作为分隔符
$sql = "set names utf8;select name from product;select price from product";

$res = $mysqli->multi_query($sql);

print_r($res);
echo "<br>";
$more = $mysqli->more_results();
print_r($more);
echo "<br>";

$next = $mysqli->next_result();
print_r($next);
echo "<br>";

 

//if($mysqli->multi_query($sql)){
//$res2 = $mysqli->store_result();
//$row = $res2->fetch_row();
//print_r($row);
//}

//$result = $mysqli->store_result();
//print_r($result);

echo $mysqli_affected_rows;
?>