Warning: Invalid argument supplied for foreach () when passing a resultset

Question

Warning: Invalid argument supplied for foreach () when passing a resultset

Navigation

#1 by (2 votes)

0

Warning: Invalid argument supplied for foreach () in C: \ xampp \ htdocs \ course_php \ pdo.php on line 9

My code is:

<?php 

try {
    $conexion = new PDO('mysql:host=localhost;dbname=curso', 'root', '');
    echo "conexion exitosa";

    $resultado = $conexion->query ( 'SELECT * FROM curso');

    foreach ($resultado as $fila) {
        print_r($fila);
       }

} catch (PDOException $e) {
    print "¡Error!: " . $e->getMessage();
} >

php pdo foreach

asked by Paul Brito 28.09.2018 в 22:10

source

1 answer

Problems with the sum of the values of an array How to work with decimals in linux shell, conditional use if & else

score 2 · Answer 1

$ result is a "pointer" to the resultset obtained with the query, to access the rows you must do it through the fetch functions eg.

while($fila = $resultado->fetch()) {
        echo $row['nombreColumna'];// Y asi con cada columna
    }