Mysqli :multi->query

来源：互联网发布：天猫打印发货单软件编辑：程序博客网时间：2024/05/21 07:20

<?php$mysqli=new mysqli("localhost","root","123456","test002");if($mysqli->connect_error){    die ("LINK FAILED".$mysqli->connect_error);}$mysqli->query("set names utf8");$sqls="insert into user1(name,password,email,age) values('宋江',md5('dfe4567'),'malin@sohu.com',13);";$sqls.="insert into user1(name,password,email,age) values('林冲',md5('dfe4567'),'malin@sohu.com',13);";$sqls.="insert into user1(name,password,email,age) values('鲁智深',md5('dfe4567'),'malin@sohu.com',13);";$b=$mysqli->multi_query($sqls);echo $mysqli->affected_rows;if($b){    echo "success";}else{    die("fail".$mysqli->error);}echo $mysqli->affected_rows;$mysqli->close();

****************************************************

<?php$mysqli = new mysqli("localhost", "root", "123456", "test003");if ($mysqli->connect_error) {    die ("LINK FAILED" . $mysqli->connect_error);}$mysqli->query("set names utf8");$sqls = "select * from user1;";$sqls .= "select * from words;";$b = $mysqli->multi_query($sqls);if ($b) {    echo "success<br>";} else {    die("fail" . $mysqli->error);}if ($b) {    do {        if ($result = $mysqli->store_result()) {            while ($row = $result->fetch_row()) {                foreach ($row as $key => $val) {                    echo "--$val";                }                echo "<br/>";            }            $result->free();            if (!$mysqli->more_results()) {                break;            }        }        echo "*****************<br>";    } while ($mysqli->next_result());}

0 0