php - PDO 准备错误

Question

已关闭。此问题需要 debugging details 。它目前不接受答案。

---

编辑问题以包含 desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem 。这将有助于其他人回答问题。

已关闭 8 年前。

Improve this question

public function connect(){
        /*connect to data base change to PDO, for securely*/
        try{
        $connection = new PDO('mysql:host=127.0.0.1;dbname=system', 'root', '' );
        $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $connection->setAttribute(PDO::ATTR_EMULATE_PREPARES,false);
        }catch(PDOException $e){
            die('this won\'t work');
        }
    }

    public function insert($table, $fields, $values){
        $fields = implode(", ", $fields);
        $values = implode("','", $values);
        try{
        /*what have i done wrong here??*/
        $stmt = $this->connection->prepare("INSERT INTO $table(ID, $fields) VALUES ('', '$values')");
        $stmt->execute();
        return TRUE;
        }catch(PDOException $j){
            die("Could not send data");
        }
    }
}

错误:在非对象in上调用成员函数prepare()。prepare存在但为空？

我在这里做错了什么？

Answer 1

您没有存储与该对象的连接。因此，在您的下一个方法中，连接对象丢失了。试试这个:

  try{
    $this->connection = new PDO('mysql:host=127.0.0.1;dbname=system', 'root', '' );
    $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $this->connection->setAttribute(PDO::ATTR_EMULATE_PREPARES,false);
    }catch(PDOException $e){
        die('this won\'t work');
    }

希望对您有所帮助!