php - fatal error : Class 'TableRows' not found in

Question

我遇到这样的错误

Fatal error: Class 'TableRows' not found in /Applications/XAMPP/xamppfiles/htdocs/colorlib-search-23/test.php on line 15

这是我的代码:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT * FROM users"); 
    $stmt->execute();

    // set the resulting array to associative
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC); 
    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) { 
        echo $v;
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;

检查了数据库表的名称和所有的名称，复制粘贴了其他代码，但仍然无法正常工作

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT * FROM users"); 
    $stmt->execute();

    // set the resulting array to associative
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC); 
    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) { 
        echo $v;
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;

这个错误不应该出现。

Answer 1

Internet 上有一篇极其有害的文章告诉您需要任何 TableRows 类才能使用 PDO。 这是非常垃圾的。

实际上你不需要这样的东西。 只需使用常规的 foreach

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->query("SELECT * FROM users"); 
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);

此时你有一个传统的 PHP 数组，它可以像使用 foreach 的任何其他数组一样迭代，或者使用 json_encode 编码或使用任何其他方式

// iterate over rows
foreach($data as $row) { 
    // iterate over values in each row
    foreach($row as $v) { 
        echo $v, " ";
    }
    echo "<br>"\n;
}