how to get database names with object-oriented php

Question

how to get database names with object-oriented php

Navigation

#1 by (0 votes)

0

Good morning I have a question as to how to get all the data registered in the database with my code. because I'm trying and my while is entering loop infinite could anyone help me?

class code:

require_once 'banco.php';
    class Album{
        public $id;
        public $nomeAlbum;
        public $img;



        public function listAll(){
            $con = new Conexao();
            $con->conectar();

            $sql = mysqli_query($con->conectar(), "SELECT nome_album, img FROM album");
            $con->desconectar();

            return $sql;
        }
    }

index code

require_once "album.class.php";
    $obj = new Album();

while($aux = mysqli_fetch_object($obj->listAll())){
  echo $aux->img;
}

php mysqli

asked by anonymous 07.11.2017 / 10:44

1 answer

Select only a few columns of mapped objects with Hibernate How to make the question page box?

score 0 · Answer 1

You are entering an infinite loop because you are looping 'enquanto' into a query object, you need to fetch to a variable, and then open loop in it:

require_once "album.class.php";
$obj = new Album();
$aux = mysqli_fetch_array($obj->listAll())
foreach($aux as $row){
  echo $row['img'];
}