<?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/>"; }