mysql多条语句执行,仅仅支持mysqli方法
语句如下:
SELECT @uid := uid, @nid := nid, @tid := tid, FROM lcd_userstore WHERE user_id = 1, SELECT @node_name := node_name, @node_tablenum := node_tablenum, FROM lcd_node_list WHERE nid=@nid, SELECT @uid uid, @nid nid, @tid tid, @node_name node_name, @node_tablenum node_tablenum;
function
test(){
$mysqli =
new
mysqli(HOST,USER,PWD,MYSQLDB);
$mysqli->query("set names
'utf8");
//多条sql语句
$sql =
"SELECT
@shar_fid
:=
`fids`
FROM
lcd_share
WHERE
`code`
=
'MCrJT6';
SELECT *
FROM
lcd_file_53
WHERE
fid
=
@shar_fid;";
echo $sql;
if ($mysqli->multi_query($sql)){//multi_query()执行一条或多条sql语句
do{
if ($rs
=
$mysqli->store_result()){//store_result()方法获取第一条sql语句查询结果
while ($row=$rs->fetch_row()){
var_dump($row);
echo "
";
}
$rs->Close(); //关闭结果集
if ($mysqli->more_results()){
//判断是否还有更多结果集
echo "
";
}
}
}while($mysqli->next_result());//next_result()方法获取下一结果集,返回bool值
}
$mysqli->close();
//关闭数据库连接
}
$mysqli
$mysqli->query("set
//多条sql语句
$sql
SELECT
echo
if
do{
if
while
var_dump($row);
echo
";
}
$rs->Close();
if
echo
";
}
}
}while($mysqli->next_result());//next_result()方法获取下一结果集,返回bool值
}
$mysqli->close();
}
以上方法才能对多条select语句进行查询