Home / Questions / 348856
Accepted
Fernando Iam
Asked: 2020-04-24 12:48:33 +0800 CST 2020-04-24 12:48:33 +0800 CST

I only get one result in the query

  • 772

I was trying to get the data from a table, but I only get one data to come out. I did it by looking at an example, but I don't know what the truth is wrong


public function listarUsuarios(){

                $sql = "SELECT *FROM usuario  ";
                $result = $this->conn->query($sql);

                    if ($result->num_rows > 0) {

                        $row = $result->fetch_all(MYSQLI_ASSOC);

                        return $row;
                    }

                    $this->conn->close();
            }

             <?php

    foreach ($row as $key){

            echo $key['nia'].'<br';
            echo $key['password'].'<br';
    }
?>
php

1 Answers

  1. Best Answer

    you have to close the tags <br>, it would be as follows:

     echo $key['nia'].'<br>';
 echo $key['password'].'<br>';
    • 2