PDO Statement does not return full array

Question

I cant figure out why i only get 1 entry in the returning array, when the table has 4 entries in total.

My PDO code is:

$stmtkat = $this->db->prepare("SELECT * FROM kategorie");
$stmtkat->execute();
$katarray=$stmtkat->fetch(PDO::FETCH_ASSOC);
var_dump($katarray);

The return array i get:

 array(2) { ["id"]=> string(1) "1" ["kategorie"]=> string(12) "Coaching" }

The table has 4 rows, why do i get only the first row into the array? What i am doing wrong? Obviously i am new to PDO.

Ty for your time.

That gives me the data output: Array ( [id] => 1 [kategorie] => Coaching ) — girax
– girax, Commented Apr 4, 2016 at 14:40

RiggsFolly · Accepted Answer · 2016-04-04 14:44:09Z

4

You are only fetching one of the result rows produced by your query

If you use ->fetch() to get result rows one at a time you do it in a while loop like this

$stmtkat = $this->db->prepare("SELECT * FROM kategorie");
$stmtkat->execute();
while ( $katarray=$stmtkat->fetch(PDO::FETCH_ASSOC) ) {
    var_dump($katarray);
}

Or use fetchAll() to return all rows into a local array from a single call to the PDO Stmt object

$stmtkat = $this->db->prepare("SELECT * FROM kategorie");
$stmtkat->execute();
$katarray=$stmtkat->fetchAll(PDO::FETCH_ASSOC) ) {

var_dump($katarray);

edited Apr 4, 2016 at 14:44

answered Apr 4, 2016 at 14:39

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JimL Over a year ago

was just about to comment you could mention fetchAll as well, +1 :)

RiggsFolly Over a year ago

@JimL Yup that occured to me only when I realised he had called the variable $katarray. Thanks for the nudge

girax Over a year ago

Thanks, that did it :)

Tomasz · Accepted Answer · 2016-04-04 14:41:11Z

2

You get only one row in return because:

PDOStatement::fetch — Fetches the next row from a result set

Use fetchAll() instead to get full array() of result or use fetch() inside while() loop.

Example with fetch() and while():

while ($stmtkat->fetch(PDO::FETCH_ASSOC)) {
  var_dump($katarray);
}

Example with fetchAll():

$result = $stmtkat->fetchAll(PDO::FETCH_ASSOC)
var_dup($result);

answered Apr 4, 2016 at 14:41

Tomasz

5,2222 gold badges37 silver badges42 bronze badges

1 Comment

girax Over a year ago

Thank you too, that was it.

Collectives™ on Stack Overflow

PDO Statement does not return full array

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related