while in infinite loop using $ result = $ result-fetch (PDO :: FETCH_ASSOC);

Question

while in infinite loop using $ result = $ result-fetch (PDO :: FETCH_ASSOC);

Navigation

#1 by (3 votes)

1

<?php include ('pdo.php');
class crud
{
    public static function select($arg){
        $pdo = new pdoinit();
        $result = $pdo->prepare($arg);
        $result->execute();
        $resultado = $result->fetch(PDO::FETCH_ASSOC);
        return $resultado;
    }
}
$arr = crud::select('select * from grupos');
print_r($arr);
while ($row = $arr){
    echo $row['nome'];
}

php pdo

asked by anonymous 14.11.2016 / 16:01

1 answer

Change the Actionbar title in old versions Call 2 events on onclick

score 3 · Accepted Answer

There are two errors in your code.

The first mistake is simple, you are copying infinitely all content from $arr to $row , one solution would be to use foreach .

foreach($arr as $row) {
   echo $row['nome'];
}

Let's go to the second error, note that you are using fetch in line $resultado = $result->fetch(PDO::FETCH_ASSOC); which will return only one line at a time, so result will have an associative array with the first line, I recommend using fetchAll so this line would look like this:

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