PHP While Loop returning 1 result should be returning 15?

Question

I wrote a function that should return all users in the database. It's printing the array, but it's only printing one result. Why is it doing this? I surrounded it in a while loop and put a limit in my query...

Code:

function getAllUsers() {

global $PDO;

    $stm = $PDO->prepare("SELECT * FROM `users` ORDER BY `bid` DESC LIMIT 15");

        $stm->execute();

            while($Array = $stm->fetch()) {
                return print_r($Array);
            }

}

You can wait and look at the answers below, or do yourself a favor and learn some basics on certain channels like here — Daniel
– Daniel, Commented Oct 2, 2013 at 3:16

Fouad Fodail · Accepted Answer · 2013-10-02 03:18:48Z

3

Use fetchAll() :

$data = $stm->fetchAll()
foreach ($data as $item ) {
    print_r($item);
}

edited Oct 2, 2013 at 3:18

answered Oct 2, 2013 at 3:10

Fouad Fodail

2,6431 gold badge18 silver badges16 bronze badges

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

2 Comments

Walter Gandarella Over a year ago

you can use the foreach loop instead of the while too

Walter Gandarella Over a year ago

one hand washes the other @FouadFodail =)

Walter Gandarella · Accepted Answer · 2013-10-02 03:13:44Z

1

use the foreach loop instead of the while and fetchAll() instead of the fetch():

foreach ($stm->fetchAll() as $arr) {
   print_r($arr);
}

answered Oct 2, 2013 at 3:13

Walter Gandarella

8781 gold badge7 silver badges17 bronze badges

1 Comment

Drixson Oseña Over a year ago

dont use return, in loop it will only loop once

Emilio Gort · Accepted Answer · 2013-10-02 03:16:55Z

0

function getAllUsers() {

   global $PDO;

   $stm = $PDO->prepare("SELECT * FROM `users` ORDER BY `bid` DESC LIMIT 15");
   $stm->execute();

   $var = array();

   while($Array = $stm->fetch()) {

     $var = $Array;

  }

 return $var;

 }

edited Oct 2, 2013 at 3:16

Emilio Gort

3,4553 gold badges32 silver badges44 bronze badges

answered Oct 2, 2013 at 3:12

w3b

8537 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP While Loop returning 1 result should be returning 15?

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related