PDO中的提取仅获取一个结果 [英] fetch in PDO gets only one result
本文介绍了PDO中的提取仅获取一个结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个代码
$sql = new PDO('mysql:host=localhost;dbname=b','root','root');
$f = $sql->query('select * from user');
$sql->setFetchMode(PDO::FETCH_ASSOC);
while($row = $f->fetch()){
print_r($row);
}
输出为
Array
(
[id] => 1
[name] => turki
[mail] => ablaf
[pass] => 144
)
Array
(
[id] => 2
[name] => wrfwer
[mail] => fwerf
[pass] => werf
)
$ b b
这就是我真正想要的。但是如果我这样做
and that's what I really want. But if I do this
<?php
$sql = new PDO('mysql:host=localhost;dbname=b','root','root');
$f = $sql->query('select * from user');
$f->setFetchMode(PDO::FETCH_ASSOC);
print_r($f->fetch());
?>
输出
Array
(
[id] => 1
[name] => turki
[mail] => ablaf
[pass] => 144
)
它有一个结果,但我有两行桌子;为什么?
It has one result but I have two rows in the table; why is that?
推荐答案
Fetch应该用于显示数据库结果中的下一行
Fetch should be used to display next row from database result
要获取所有行,您应该使用 fetchAll() ;
To get all rows you should use fetchAll();
- PDOStatement :: fetch - 从结果集中获取下一行
- PDOStatement :: fetchAll() - 返回包含所有结果集行的数组
- PDOStatement::fetch — Fetches the next row from a result set
- PDOStatement::fetchAll() — Returns an array containing all of the result set rows
将您的示例更改为:
<?php
$sql = new PDO('mysql:host=localhost;dbname=b','root','root');
$f = $sql->query('select * from user');
$f->setFetchMode(PDO::FETCH_ASSOC);
print_r($f->fetchAll());
?>
或如果您想使用 PDOStatement :: fetch 到
<?php
$sql = new PDO('mysql:host=localhost;dbname=b','root','root');
$f = $sql->query('select * from user');
while($row = $sth->fetch(PDO::FETCH_ASSOC))
{
print_r($row);
}
?>
这篇关于PDO中的提取仅获取一个结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文