是否可以回退 PDO 结果? [英] Is it possible to rewind a PDO result?

问题描述

我正在尝试为 PDO 语句的结果编写一个迭代器，但我找不到任何方法可以倒回到第一行.我想避免调用 fetchAll 并存储所有结果数据的开销.

I'm trying to write an iterator for results from a PDO statement but I can't find any way of rewinding to the first row. I would like to avoid the overhead of calling fetchAll and storing all the result data.

// first loop works fine
foreach($statement as $result) {
    // do something with result
}

// but subsequent loops don't
foreach($statement as $result) {
    // never called 
}

有没有办法重置语句或寻找第一行?

Is there some way of reseting the statement or seeking the first row?

推荐答案

我很确定这是依赖于数据库的.正因为如此，这是你应该尽量避免的事情.但是，我认为您可以通过启用 缓冲查询 来实现您想要的.如果这不起作用，您始终可以使用 fetchAll.这两种解决方案都会影响您的应用程序性能，因此如果结果集很大，请三思而后行.

I'm pretty sure this is database dependent. Because of that, it is something you should try to avoid. However, I think you can achieve what you want by enabling buffered queries. If that doesn't work, you can always pull the result into an array with fetchAll. Both solutions have implications for your applications performance, so think twice about it, if the resultsets are large.

这篇关于是否可以回退 PDO 结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！