pdo mysql fetchall,PDO循环通道和打印fetchAll

I'm having trouble getting my data from fetchAll to print selectively.

In normal mysql I do it this way:

$rs = mysql_query($sql);

while ($row = mysql_fetch_array($rs)){

$id = $row['id'];

$n = $row['n'];

$k = $row['k'];

}

In PDO, I'm having trouble. I bound the params, then I'm saving the fetched data into $rs like above, with the purpose of looping through it the same way..

$sth->execute();

$rs = $query->fetchAll();

Now comes the trouble part. What do I do PDO-wise to get something matching the while loop above?! I know I can use print_r() or dump_var, but that's not what I want. I need to do what I used to be able to do with regular mysql, like grabbing $id, $n, $k individually as needed. Is it possible?

Thanks in advance..

解决方案

It should be

while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

$id = $row['id'];

$n = $row['n'];

$k = $row['k'];

}

If you insist on fetchAll, then

$results = $query->fetchAll(PDO::FETCH_ASSOC);

foreach($results as $row) {

$id = $row['id'];

$n = $row['n'];

$k = $row['k'];

}

PDO::FETCH_ASSOC fetches only column names and omits the numeric index.