PDO 连接器无法在具有多个实例的页面上使用

发布于 2024-10-17 11:23:17 字数 1519 浏览 2 评论 0原文

在我的 php 页面的顶部，我包含一个名为

include("connector.php")

Connector.php

<?php

    try
    {
        $db = new PDO('mysql:host=localhost;dbname=DB', 'USER', 'PW');
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    catch (PDOException $e)
    {
        echo $e->getMessage();
    }
?>

的连接脚本，然后我根据需要在我的页面上进行所有后续调用。然而，特别是在一页上，我最初调用 MySQL 存储过程：

$stmt = $db->prepare("CALL Procedure(:id)");
$stmt->bindParam(':id', $id);
$stmt->execute();

while($row=$stmt->fetch()) {
    echo "<tr>
        <td>".$row['ID']."</td>
        <td>".$row['NAME']."</td>
        </tr>";
}

我的存储过程没有问题，但是当我尝试进行任何后续调用时，我会收到通常的 PDO Mysql 无缓冲查询错误：

致命错误：未捕获的异常带有消息的“PDOException” 'SQLSTATE[HY000]：一般错误：2014 其他时无法执行查询无缓冲查询处于活动状态。考虑使用 PDOStatement::fetchAll()。或者，如果您的代码只是曾经要对抗mysql，你可以通过设置启用查询缓冲 PDO::MYSQL_ATTR_USE_BUFFERED_QUERY 属性。'在 C:\page.php:261 堆栈跟踪：#0 C:\page.php(261): PDOStatement->execute(Array) #1 {main} 扔进去 C:\page.php 在第 261 行

是的，我尝试过使用 FetchAll，但不，我不想使用 PDO::MYSQL_ATTR_USE_BUFFERED_QUERY 属性，因为我们可能会在稍后的时间点关闭 MySQL，并且我不希望基于每个数据库进行重建（不是值得一提的是，即使我确实包含它也不起作用）。

任何想法为什么会发生这种情况？我可以在每个数据库调用之前“包含”connector.php 文件，但这似乎是重复的，我必须将每个语句 $db->NULL 。

注意：这似乎只影响调用存储过程的页面。有什么想法吗？

注意：这是在运行 Apache 2.2.14、PHP 5.3.1 的 XAMPP 1.7.3 的 Windows 计算机上运行的

原文

At the top of my php page, I include a connection script called by:

include("connector.php")

Connector.php

<?php

    try
    {
        $db = new PDO('mysql:host=localhost;dbname=DB', 'USER', 'PW');
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    catch (PDOException $e)
    {
        echo $e->getMessage();
    }
?>

I then make all subsequent calls on my pages as necessary. On one page in particular however, I initially make a call into a MySQL stored procedure:

$stmt = $db->prepare("CALL Procedure(:id)");
$stmt->bindParam(':id', $id);
$stmt->execute();

while($row=$stmt->fetch()) {
    echo "<tr>
        <td>".$row['ID']."</td>
        <td>".$row['NAME']."</td>
        </tr>";
}

There is no issue with my stored procedure but down the page when I try and make any subsequent calls, I get the usual PDO Mysql unbuffered queries error:

Fatal error: Uncaught exception
'PDOException' with message
'SQLSTATE[HY000]: General error: 2014
Cannot execute queries while other
unbuffered queries are active.
Consider using
PDOStatement::fetchAll().
Alternatively, if your code is only
ever going to run against mysql, you
may enable query buffering by setting
the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY
attribute.' in
C:\page.php:261
Stack trace: #0
C:\page.php(261):
PDOStatement->execute(Array) #1 {main}
thrown in
C:\page.php
on line 261

Yes, I have tried using FetchAll, and NO I do not want to use the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute as we may switch off MySQL at a later point in time and I do not wish to rebuild based on every DB (not to mention even when I did include it did not work).

Any ideas why this might be happening? I could 'include' the connector.php file before every DB call but that seems repetitive and I'd have to $db->NULL every statement.

Note: this seems to only affect pages with calls into stored procedures. Any ideas?

Note: This is being run on a Windows machine with XAMPP 1.7.3 running Apache 2.2.14, PHP 5.3.1

分享到QQ

分享到微博