<?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()); }