2006-05-22 (月)
■ PDO で複数の SQL 文を連続実行するとエラーになる理由
PDO を使って、こんな感じのコードを書いていた。
$dbh = new PDO($dsn); $sql = "SELECT * FROM table1 WHERE id='$id'"; $stmt = $dbh->prepare($sql); $stmt->execute(); $row1 = $stmt->fetch(); $sql = "SELECT * FROM table2 WHERE id='$id'"; $stmt = $dbh->prepare($sql); $stmt->execute(); $row2 = $stmt->fetch();
ところが、実行すると以下のようなエラーが出て止まってしまう。
Fatal error: Call to a member function execute() on a non-object.
エラーメッセージを見ると、 １回目でなく２回目の $stmt->execute(); でエラーになっている。 スクリプトの他の箇所では SQL 文をいくつも連続して実行できているのに、 なぜかここの箇所だけエラーになる。
試行錯誤して、 $stmt->fetch(); の後に $stmt = null; を追加してみたら、 一応動くようにはなった。 しかし、なぜそんな処理が必要になるのか、理由がさっぱり分からない。
そうしてさらに調べた結果、 PDOStatement::closeCursor のマニュアル に答えが書いてあった。 要するに、最後まで fetch しきらずに次の SQL 文の実行に移る場合は、 $stmt->closeCursor(); を実行する必要があるということか。
[コメントを書く]
本日のリンク元
- 206 http://d.hatena.ne.jp/mitaina/20090906/1252242675
- 59 http://d.hatena.ne.jp/Arko/20081127/1227747441
- 35 google検索(Call to a member function prepare() on a non-object)
- 34 google検索(Call to a member function fetchAll() on a non-object)
- 32 google検索(Call to a member function execute() on a non-object)
- 28 google検索(Call to a member function execute() on a non-object)
- 25 google検索(Call to a member function fetch() on a non-object)
- 25 google検索(Call to a member function execute() on a non-object)
- 24 http://www.esannoeweb.com/2010/09/08/【php】mdb2の...
- 22 google検索(PHP prepare 連続)
- 22 http://game5.jp/blog/2009/09/06/pdoquery、pdoprepa...
- 21 google検索(Call to a member function prepare() on a non-object)
- 21 google検索(Call to a member function fetch() on a non-object)
- 20 google検索(Call to a member function execute() on a non-object in)
- 16 google検索(pdo prepare エラー)
- 13 google検索(Call to a member function execute() on a non-object)
- 13 http://www.google.co.jp/hws/search?hl=ja&q=Call to...
- 12 google検索(Call to a member function fetchRow() on a non-object)
- 12 google検索(Call to a member function execute() on a non-object)
- 11 google検索(Call to a member function execute() on a non-object in)
- 11 google検索(Fatal error: Call to a member function fetchALL() on a non-object)
- 11 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 11 google検索(Call to a member function fetchAll() on a non-object)
- 10 google検索(Call to a member function fetchAll() on a non-object)
- 9 google検索(pdo sql 連続実行)
- 9 google検索(Call to a member function fetch() on a non-object)
- 9 google検索(Call to a member function fetch() on a non-object in )
- 9 google検索(f)
- 9 http://www.google.co.jp/
- 9 http://game5.jp/blog/2009/09/06/pdoquery、pdoprepa...
- 8 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 8 google検索(Call to a member function prepare() on a non-object)
- 8 google検索(Fatal error: Call to a member function fetch() on a non-object in)
- 8 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 8 google検索(Call to a member function fetchAll() on a non-object i)
- 8 google検索(Call to a member function fetch() on a non-object in)
- 8 google検索(Call to a member function prepare() on a non-object)
- 8 http://azby.search.nifty.com/websearch/search?sele...
- 7 http://www.revulo.com/
- 7 google検索(Call to a member function fetchAll() on a non-object in)
- 7 google検索(Call to a member function fetch() on a non-object in)
- 7 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 6 google検索(php sql 実行)
- 6 google検索(pdo prepare エラー)
- 6 google検索(Fatal error: Call to a member function fetch() on a non-object in )
- 6 google検索(Call to a member function prepare() on a non-object in)
- 6 google検索(Call to a member function prepare() on a non-object )
- 6 google検索(Call to a member function fetch() on a non-object )
- 6 google検索(Call to a member function execute() on a non-object)
- 6 google検索(Call to a member function execute() on a non-object)
- 6 google検索(Call to a member function Execute() on a non-object)
- 6 google検索(Call to a member function fetch() on a non-object)
- 6 google検索(Call to a member function fetch() on a non-object)
- 6 google検索(Call to a member function execute() on a non-object in)
- 6 http://www.about-reference.com/php/manual/function...
- 5 https://www.google.co.jp/
- 5 google検索(Call to a member function fetchAll() on a non-object in)
- 5 google検索(Call to a member function fetchAll() on a non-object)
- 5 google検索(Call to a member function execute())
- 5 google検索(Fatal error: Call to a member function fetch() on a non-object in)
- 5 google検索(Call to a member function fetch)
- 5 google検索(Call to a member function fetch() on a non-object )
- 5 google検索(Call to a member function fetch())
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(Call to a member function execute() on a non-object )
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(Call to a member function Execute() on a non-object)
- 5 google検索( Call to a member function fetchAll() on a non-object in)
- 5 google検索(call to a member function fetch on a non-object in)
- 5 google検索(Call to a member function prepare() on a non-object)
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(pdo 複数 sql )
- 5 google検索(Call to a member function fetchRow() on a non-object エラー)
- 5 google検索(Call to a member function fetchRow() on a non-object)
- 5 google検索(Call to a member function fetch() on a non-object in)
- 5 google検索(Call to a member function fetch() on a non-object)
- 5 google検索(Call to a member function execute() on a non-object)
- 5 google検索(複数のSQL文)
- 5 google検索(f)
- 5 http://www.google.co.jp/hws/search?hl=ja&client=fe...
- 5 http://webmemo.uzuralife.com/category/275
- 4 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 4 google検索(Fatal error: Call to a member function fetch() on a non-object)
- 4 http://www.google.co.jp/url?sa=t&rct=j&q=php fetch...
- 4 http://www.google.co.jp/url?sa=t&rct=j&q=pdo エラ�...
- 4 http://www.google.co.jp/url?sa=t&rct=j&q=call to a...
- 4 http://www.google.co.jp/url?sa=t&rct=j&q=Fatal err...
- 4 http://www.google.co.jp/url?sa=t&rct=j&q=Call to a...
- 4 google検索(複数SELECT 連続実行)
- 4 google検索(PHP Fatal error: Call to a member function fetch() on a non-object)
- 4 google検索(php pdo 複数)
- 4 google検索(PDO non-object)
- 4 google検索(Fatal error: Call to a member function fetchRow() on a non-object in)
- 4 google検索(Fatal error: Call to a member function fetchALL() on a non-object in)
- 4 google検索(Call to a member function prepare() on a non-object in )
- 4 google検索(Call to a member function fetchAll() on a non-object)
- 4 google検索(Call to a member function fetchAll() on a non-object)
- 4 google検索(Call to a member function fetchAll() on a non-object )
