echo
'User id:'.
$uId
;
//获取用户 id
类型三:调用带返回结果集的方法
代码如下:
try
{
$spname
= 'P__Test_GetData';
$query
= mysql_query ( "call $spname()",
$conn
)
or
die
( "[$spname]Query
failed:".mysql_error() );
while
(
$row
= mysql_fetch_array (
$query
) ) {
echo
$row
['ProvinceID'].'::'.
$row
['ProvinceName'];
//输出数据集
}
}
catch
( Exception
$e
) {
echo
$e
;
}
类型四:调用带返回多个结果集的方法(目前只能通过 mysqli 来实现~~)
代码如下:
//PHP
$rows
=
array
();
$db
=
new
mysqli(
$server
,
$user
,
$psd
,
$dbname
);
if
(mysqli_connect_errno()){
$this
->message('Can not connect to MySQL server');
}
$db
->query("SET NAMES UTF8");
$db
->query("SET @Message");
if
(
$db
->real_query("call P__Test_GetData2(@Message)")){
do
{
if
(
$result
=
$db
->store_result()){
while
(
$row
=
$result
->fetch_assoc()){
array_push
(
$rows
,
$row
);
}
$result
->close();
}
}
while
(
$db
->next_result());
}
$db
->close();
print_r(
$rows
);
//Procedure
……
select * from T1 where ……