得到存储过程的多组结果,数据库操作要使用mysqli扩展。
例:
<?php
$cn = mysqli_connect("localhost","root","");
mysqli_select_db($cn,'mysql');
$res = mysqli_query($cn,"call proc1()");
while($row = mysqli_fetch_array($res))
{
print_r($row);
}
?>
例:
<?php
$cn = mysqli_connect("localhost","root","");
mysqli_select_db($cn,'mysql');
$res = mysqli_query($cn,"call proc1()");
while($row = mysqli_fetch_array($res))
{
print_r($row);
}
?>
$res = $cn->query($sql);
do {
$row = $res->fetchAll(PDO::FETCH_NUM);
if ($row)
{
print_r($row);
}
} while ($res->nextRowset());
这个怎么实现?我每次都取不到@error_code的值.
-------------------------------------------
得到存储过程的多组结果,数据库操作要使用mysqli扩展。
例:
<?php
$cn = mysqli_connect("localhost","root","");
mysqli_select_db($cn,'mysql');
$res = mysqli_query($cn,"call proc1()");
while($row = mysqli_fetch_array($res))
{
print_r($row);
}
?>
没能取到.我的结果是下面这样的.
------------------------------------------------------------------------------------
call sp_get_encrypt_key('test','test1');
+----------------------------------+----------------------------------+
| public_key | private_key |
+----------------------------------+----------------------------------+
| 0042f191f042388271aee57dc54d530f | 0042f191f042388271aee57dc54d530f |
+----------------------------------+----------------------------------+
1 row in set (0.00 sec)+------------+
| public_key |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)
-----------------------------there is no error,the sp returns just one result.
<?php
$cn = mysqli_connect("localhost","root","");
mysqli_select_db($cn,'mysql');
$res = mysqli_query($cn,"call proc1()");
while($row = mysqli_fetch_array($res))
{
print_r($row);
}
?>这个方法是可行的。
-------------------------------------
得到存储过程的多组结果,数据库操作要使用mysqli扩展。
<?php
$cn = mysqli_connect("localhost","root","");
mysqli_select_db($cn,'mysql');
$res = mysqli_query($cn,"call proc1()");
while($row = mysqli_fetch_array($res))
{
print_r($row);
}
?>这个方法是可行的。
---------------------------这样只能得到一组结果集的多组数据.
我说的是有过个result.也就是多个结果集的.这样不行.只能返回第一个结果集.
mysqli_multi_query();
参考:http://cn2.php.net/manual/en/function.mysqli-multi-query.php