English 中文(简体)
报表1.4:在行动过程中,我只作一次原始询问,第一个记录丢失。
原标题:Symfony 1.4: in action, I do a raw query, the first record gets lost

action action

   $res = Propel::getConnection()->prepare( adasasd );
   $res->execute();

当时,Im从事“海滩”活动

 while ($rec = $res->fetch(PDO::FETCH_OBJ))
 {
 }

这里只列出第一批记录。 它有一些损失。

然而,如果我在“和”之后正确,所有记录都可以查阅。 但是,如果我认为我这样做的话,即便在第一行,第1记录也缺失。

我做了什么错误?

问题回答

我认为,或许可以通过其 cur子在单体功能上的抵消(。 Fetch function php Manual tries establishing it to 0 similar

while ($rec = $res->fetch(PDO::FETCH_OBJ,0)){...}

阅读后发现的一件事情是,有以下功能:PDOStatement:fetchObject 。 (他们说是一种替代办法,也是你可以尝试的一件事)。

FInally I would really recomment to use the fetchAll if you are planning on iterating over all the resutls:

foreach($res->fetchAll(PDO) as $result)
{

}




相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签