問題描述

我正在嘗試使用 PDO 回顯表的所有行，但遇到了問題.

I'm trying to echo out all the rows of a table using PDO but am running into trouble.

用舊的方式做我會這樣做

With the old way of doing I'd have done it like

$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)){
   $title= $row['title'];
   $body= $row['body'];
}

但是我正在嘗試使用 PDO；

But with PDO I'm trying;

$result = $db->prepare("SELECT title, body FROM post");
$result->execute();

while ($row = $db->fetchAll(PDO::FETCH_ASSOC))
{
$title = $row['title'];
$body = $row['body'];
}

echo $title;
echo $body;

它一直給我調用未定義的方法 PDO::fetchAll()

Which keeps giving me Call to undefined method PDO::fetchAll()

做手冊中給出的例子

<?php
$sth = $dbh->prepare("SELECT name, colour FROM fruit");
$sth->execute();

/* Fetch all of the remaining rows in the result set */
print("Fetch all of the remaining rows in the result set:
");
$result = $sth->fetchAll();
print_r($result);
?>

有效，但我認為我無法像使用 $row=['blah']; 那樣控制各個列.我呢?它也像這樣打印出來；比較丑:

Works, but I don't think I have control over the individual colums like I would with a $row=['blah']; do I? It also prints out like this; rather ugly:

Array ( [0] => Array ( [title] => 這是數據庫中輸入的測試標題[0]

Array ( [0] => Array ( [title] => This is the test title entered in the database[0]

需要做什么才能正確使用 PDO 來做到這一點?

What needs to be done to properly use PDO to do this?

推薦答案

change:

while ($row = $db->fetchAll(PDO::FETCH_ASSOC))
{
$title = $row['title'];
$body = $row['body'];
}

到:

while ($row = $result->fetch(PDO::FETCH_ASSOC))
{
$title = $row['title'];
$body = $row['body'];
}

這篇關于使用 PDO 回顯顯示表中的所有行的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！