该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
$mysqli=@new mysqli("localhost","root","liuyang","firedb");
if(mysqli_connect_error()){
echo "ERROR ".mysqli_connect_errno()."|".mysqli_connect_error();
exit;
}
/*
$sqls="insert into shop values('136','lamp','100','200','very good');";
$sqls.="update shop set name=lamp where id<40";
*/
$sqls="select current_user();";
$sqls.="desc shop;";
$sqls.="select * from shop";
echo $sqls."
";
$result=$mysqli->multi_query($sqls);
var_dump($result);
if($result){
/*
echo "Exectue success!!
";
echo "Affect rows:".$mysqli->affected_rows;
*/
do{
$result=$mysqli->store_result();
echo '
echo '
';while($field=$result->fetch_field()){
echo '
'.$field->name.'';}
echo '
';while($rows=$result->fetch_assoc()){
echo '
';foreach($rows as $row){
echo '
'.$row.'';}
echo '
';}
echo '
';if($mysqli->more_results()){
echo '
-----
----
';
}
}while($mysqli->next_result());
}else{
echo "ERROR ".$mysqli->errno."|".$mysqli->error;
}
$mysqli->close();