<?php
//创建mysqli对象实例
$mysqli = new MYSQLi("localhost", "question", "questionadmin", "questionnaire");
if ($mysqli->connect_error) {
die("连接失败") . $mysqli->connect_error;
}
//创建预编译的对象实例
$sql = "select name from users where id>?;";
$mysqli_stmt = $mysqli->prepare($sql);
//绑定数据
$id = "133";
$mysqli_stmt->bind_param("i", $id);
//绑定结果集
$mysqli_stmt->bind_result($name);
//执行
$mysqli_stmt->execute();
//显示结果集
while ($mysqli_stmt->fetch()) {
echo "<br/>" . $name;
}
$mysqli_stmt->free_result();
$mysqli_stmt->close();
$mysqli->close();
<?php
$mysqli = new MYSQLi("localhost", "question", "questionadmin", "questionnaire");
if ($mysqli->connect_error) {
die("连接失败") . $mysqli->connect_error;
}
$sql = "select * from users;";
$sql .= "select * from users1;";
if ($result = $mysqli->multi_query($sql)) {
do {
$res = $mysqli->store_result();
//转移从上次查询的结果集
while ($row = $res->fetch_row()) {
foreach ($row as $key => $val) {
echo $val;
}
echo "<br/>";
}
$res->free();
if (!$mysqli->more_results()) {
die;
}
echo "新的结果集<br/>";
} while ($mysqli->next_result());
/*while($mysqli->next_result()){
$res=$mysqli->store_result();//转移从上次查询的结果集
while($row=$res->fetch_row()){
foreach($row as $key=>$val){
echo $val;
}
echo "<br/>";
}
