在PHP调用存储过程返回结果集的时候，会提示：can't return a result set in the given context；解决can't return a result set in the given context的方法。
关键两点：
1.define('CLIENT_MULTI_RESULTS', 131072);
2.$link = mysql_connect("127.0.0.1", "root", "123",1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());
<?php
define('CLIENT_MULTI_RESULTS', 131072);
$link = mysql_connect("127.0.0.1", "root", "123",1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());
mysql_select_db("test") or die("Could not select database");
$sql = "create procedure select_data()
begin
select * from user;
end;";
mysql_query($sql);
$result = mysql_query("call test.select_data()") or die("Query failed:" .mysql_error());
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$line = '<tr><td><a target = _blank href=\''.$row["name"].'\'>'.$row["name"].'('.$row["pwd"].')'.'</a></td></t
r>';
echo $line;
printf("\n");
}
?>
实例：
存储过程实例下载
评论