[ACCEPTED]-PDO looping throug and printing fetchAll-fetchall

Accepted answer

Score: 34

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 2 only column names and omits the numeric 1 index.

Source: stackoverflow.com

More Related questions

What is the best way to bind decimal / double / float values with PDO in PHP?

SQL Select * from multiple tables

PDO SQL-state "00000" but still error?

Create SQLite database in memory

How to connect to mssql using pdo through PHP and Linux?

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

php pdo get only one value from mysql; value that equals to variable

PDO MySQL: Insert multiple rows in one query

PDO Error: " Invalid parameter number: parameter was not defined

PDO::Query() returning false

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.