PHP: How to loop inside a result set obtained with PDO? (how to use fetch()?)

Question

I have this method that I want to give me all usernames in the database, in a list.

I know that fetch() should be inside a look of some kind. But I don't know how to loop inside an object, because I've tried with a for and a while and I've got this error that says that it cannot be treated as an array or string (ie: Catchable fatal error: Object of class PDOStatement could not be converted to string).

So, How do I do a loop inside a result set?

The code below is my last attempt, and it shows only the first result (naturally, because it should be inside some kind of loop). I've looked into some other questions here, but as I'm just starting with objects, they are too complex and I cannot quite grasp the concept.

function getUsuarios() {
        $usuariosRaw = $this->pdo->query('SELECT nombre FROM usuarios');
        $listadoUsuarios = $usuariosRaw->fetch();   
        echo 'Listado de Reservas:<br>';
        echo $listadoUsuarios['nombre'].'<br>';
    }

Is it so difficult to read a manual first? There are Examples section - ru2.php.net/manual/en/pdo.query.php#refsect1-pdo.query-examples — u_mulder
– u_mulder, Commented Nov 9, 2014 at 17:18
No, it's not. But it seems I was looking in the wrong place, because I was reading this: php.net/manual/en/pdostatement.fetch.php and didn't understand (hence the question). Thanks for the link (it doesn't use fetch() though). — Rosamunda
– Rosamunda, Commented Nov 9, 2014 at 17:48

trzyeM- · Accepted Answer · 2014-11-09 18:19:35Z

1

function getUsuarios() {
        $usuariosRaw = $this->pdo->query('SELECT nombre FROM usuarios');
        $listadoUsuarios = $usuariosRaw->fetchAll();   
        echo 'Listado de Reservas:<br>';
       foreach( $listadoUsuarios  as $row ) 
{ 
echo $row['nombre'].'<br>';
}
    }

Is not working?

edited Nov 9, 2014 at 18:19

answered Nov 9, 2014 at 17:50

trzyeM-

9638 silver badges10 bronze badges

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

1 Comment

Rosamunda Over a year ago

It works! THANKS!! (there's a $ missing before listadoUsuarios and the system didn't allow me to edit your post with just one character)

noobdev · Accepted Answer · 2014-11-09 18:22:43Z

0

connection to pdo :

function connect() {
try {
    $dbh = new PDO('mysql:dbname=test;host=localhost','root', 'root');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $ex) {
    echo $ex->getMessage();
}

return $dbh;

}

function to get users :

function getUser(\PDO $dbh){
 $sql = 'SELECT name FROM users';
 $stmt = $dbh->query($sql);
 $result = $stmt->fetchAll(5); // PDO::FETCH_OBJ
 return $result;
}

loop to get results :

    <?php 
      require_once 'db.php';
      $dbh = connect();
     $users = getUser($dbh);
    ?>


    <?php foreach($users as $user):?>
       <p><?= $user->name; ?></p>
    <?php endforeach; ?>

hope that help you

answered Nov 9, 2014 at 18:22

noobdev

1,2812 gold badges8 silver badges6 bronze badges

Collectives™ on Stack Overflow

PHP: How to loop inside a result set obtained with PDO? (how to use fetch()?)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related