PHP PDO SQLite准备了语句问题

I am trying to migrate a PHP app from MySQL to SQLite, and some things that used to work, simply stopped working now. I am using PDO through a custom database wrapper class (the class is a singleton, seems logical to do it like that).

我正在尝试将PHP应用程序从MySQL迁移到SQLite，以及过去常常工作的一些东西，现在就停止工作了。我通过自定义数据库包装类使用PDO（该类是单例，似乎合乎逻辑地这样做）。

The problem: When trying to execute a query on a prepared statement, it throws a "fatal error: Call to a member function execute() on a non-object ...".

问题：当尝试在预准备语句上执行查询时，它会抛出“致命错误：在非对象上调用成员函数execute（）......”。

Relevant code (narrowed it down to this, after some hours of var_dumps and try-catch):

相关代码（在var_dumps和try-catch几个小时后缩小到这个范围）：

Connection string:

连接字符串：

$this->connection = new PDO("sqlite:"._ROOT."/Storage/_sqlite/satori.sdb");

Obviously, the $connection variable here is a private variable from the class.

显然，这里的$ connection变量是类中的私有变量。

The error happens here (inside a function that is supposed to perform database insert):

这里发生错误（在应该执行数据库插入的函数内）：

    try{
        $statement = self::getInstance()->connection->prepare($sql);
    }catch (PDOException $e){
        print $e->getMessage;
    }

    try{
        var_dump($statement);
        $statement->execute($input);
    }catch (Exception $e){
        print $e->getMessage();
    }

More accurately, it happens when I try to $statement->execute($input).

更准确地说，当我尝试$ statement-> execute（$ input）时会发生这种情况。

Any help appreciated. Thanks.

任何帮助赞赏。谢谢。

2 个解决方案

#1

You are probably getting a mySQL error when the statement is being prepared, but you don't have PDO configured to throw an exception in case of an error.

在准备语句时，您可能会收到mySQL错误，但是您没有配置PDO以在发生错误时抛出异常。

<?php

  $dbh = new PDO( /* your connection string */ );
  $dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
  // . . .
?>

#2

try declaring the $statement variable outside the first try block. e.g.

尝试在第一个try块之外声明$ statement变量。例如

$statement = null;

try{
        $statement = self::getInstance()->connection->prepare($sql);
    }catch (PDOException $e){
        print $e->getMessage;
    }

    try{
        var_dump($statement);
        $statement->execute($input);
    }catch (Exception $e){
        print $e->getMessage();
    }

#1