php - PDO fetchAll 非对象

Question

为什么我收到错误 Fatal error: Call to a member function fetchAll()。我已经查看了具有相同错误的其他问题，但我的代码似乎很好，它似乎与 $this->$db 和 var_dump 返回 object 有关(PDO)#2 (0) { }

index.php

<?php  
    include('assets/misc/functions.php');

  $cars = new Cars(connection());

  $listAll = $cars->listCars();

  var_dump($listCars);
?>

config.php

<?php

function connection()
{
    try
    {
        $host   = 'localhost';
        $dbuser = 'jzmcond_pdo1';
        $dbpass = '';
        $dbname = 'jzmcond_pdo1';

        $dbConnection = new PDO("mysql:host=" . $host . ";dbname=" . $dbname.";", $dbuser, $dbpass);

        return $dbConnection;
    } catch (PDOException $error)
    {
        echo $error->getMessage();
        return FALSE;
    }
}
?>

函数:

<?php

include('config.php');

class Cars{
    protected $db;

    public function __construct(PDO $db){
        $this->db = $db;
    }

    public function listCars()
    {
        $query = $this->db->prepare("SELECT `id` `rego` `engineSize` `type` `colour` `year` `additionalFeatures` FROM `cars`")->execute();
        //return $query->fetchAll();

        var_dump($this->db); exit();
    }
}

?>

Answer 1

您的查询语法错误，您没有输入逗号

改变

SELECT `id` `rego` `engineSize` `type` `colour` `year` `additionalFeatures` FROM `cars

到

SELECT `id`, `rego`, `engineSize`, `type`, `colour`, `year`, `additionalFeatures` FROM `cars`

在这种情况下你甚至不需要准备，试试这个:

public function listCars()
{
    $query = "SELECT `id`, `rego`, `engineSize`, `type`, `colour`, `year`, `additionalFeatures` FROM `cars`";
    $stmt = $this->db->query($query);
    if (!$stmt) {
        echo "\nPDO::errorInfo():\n";
        print_r($this->db->errorInfo());
        exit();
    }
    $rows = $stmt->fetchAll();

    return $rows;
}