php当中多次使用PDO::query ( string $statement ) 报non-object错误的解决方法

最新推荐文章于 2021-07-30 10:19:13 发布

vancekq

最新推荐文章于 2021-07-30 10:19:13 发布

阅读量3.6k

点赞数

文章标签： query string php null function object

本文链接：https://blog.csdn.net/vancekq/article/details/7815141

版权

$pdo = new PDO("mysql:host=localhost;dbname=acl","root","123456");

$rs = $pdo -> query("call pr_add(12,28)");
while($row = $rs -> fetch()){
print_r($row);
}
$rs  = null;
 //此处如果释放了，就可以了，我之前也在想有类似的函数，居然没有，要用这个了如果没有此句在下面继续使用时会报
//Fatal error: Call to a member function fetch() on a non-object  这样的错误
$rs2 = $pdo -> query("call pr_add2(2,15)");
while($row2 = $rs2->fetch()){
print_r($row2);
}

之前一直找不到方法解决最后还是看了手册当中的这个函数的用法才解决的，感谢下面的这位朋友了，

<?php

/* WRONG */

$oPDO = new PDO();

$oPDOStatement = $oPDO->query('SELECT something');

/* making something with $oPDOStatement, i.e. fetch() */

  $oPDOStatement = $oPDO->query('SELECT something completly different');

/* and now $oPDOStatement is unuseful, fetch() doesn't returns result etc. */

?>

But...

<?php

/* GOOD */

 $oPDO = new PDO();

 $oPDOStatement = $oPDO->query('SELECT something');

 /* making something with $oPDOStatement, i.e. fetch() */

 /* and destroy poor, little object as we had used it */

 $oPDOStatement  = null;

 $oPDOStatement = $oPDO->query('SELECT something completly different');

/* and everything works fine */

?>