使用PDO回显表中的所有行 [英] Using PDO to echo display all rows from a table
问题描述
我正在尝试使用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()
按照手册中的示例进行操作
Doing the example given in the manual
<?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:\n");
$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?
推荐答案
更改:
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回显表中的所有行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!