<?
define('CLIENT_MULTI_RESULTS', 131072);
include('../adodb/ADOdb.inc.php'); # 载入ADODB
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$conn = &ADONewConnection('mysql'); # 建立一个连结
$conn->PConnect('localhost','root','','ch',1,CLIENT_MULTI_RESULTS);
$recordSet = &$conn->Execute('call playgame();');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields['id'].' '.$recordSet->fields['userid'].' '.$recordSet->fields['price'].'<BR>';
$recordSet->MoveNext();
}$recordSet->Close(); # 选择性执行
$conn->Close(); # 选择性执行
?>
执行后显示:
PROCEDURE ch.playgame can't return a result set in the given context
网上说要加 CLIENT_MULTI_RESULTS
不用ADODB可以,但是用ADODB连mysql怎么调用存储过程
万分感谢
define('CLIENT_MULTI_RESULTS', 131072);
include('../adodb/ADOdb.inc.php'); # 载入ADODB
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$conn = &ADONewConnection('mysql'); # 建立一个连结
$conn->PConnect('localhost','root','','ch',1,CLIENT_MULTI_RESULTS);
$recordSet = &$conn->Execute('call playgame();');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields['id'].' '.$recordSet->fields['userid'].' '.$recordSet->fields['price'].'<BR>';
$recordSet->MoveNext();
}$recordSet->Close(); # 选择性执行
$conn->Close(); # 选择性执行
?>
执行后显示:
PROCEDURE ch.playgame can't return a result set in the given context
网上说要加 CLIENT_MULTI_RESULTS
不用ADODB可以,但是用ADODB连mysql怎么调用存储过程
万分感谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货