存储过程是
CREATE DEFINER = `root`@`localhost` PROCEDURE `testPrc`(IN UserID int)
BEGINselect user_name from user WHERE user_id = UserID ;
END;
在PHP里面为什么获取不到user_name $rs = $conn->Execute( "call testPrc(17)");
echo "<script>alert('"rs["user_name"]"');</script>";
CREATE DEFINER = `root`@`localhost` PROCEDURE `testPrc`(IN UserID int)
BEGINselect user_name from user WHERE user_id = UserID ;
END;
在PHP里面为什么获取不到user_name $rs = $conn->Execute( "call testPrc(17)");
echo "<script>alert('"rs["user_name"]"');</script>";
echo $row["user_name"];
$con=mysql_connect('localhost','root','4585') or die('error');
mysql_select_db('test');
$array=mysql_query("CALL testPrc(1)");
while($r=mysql_fetch_array($array,MYSQL_ASSOC))
var_dump($r);
if(!$con)
mysql_close($con);
//+++++++++++++++++++++++++++++++++++
array(2) {
["id"]=>
string(1) "1"
["name"]=>
string(4) "wang"
}检查$conn对象里的Execute方法,另外前台alert建议写成:echo "<script>alert('rs[user_name]');</script>";
输出看看。