How to create Array with BD content

Question

I’m trying to create an array with the contents of a tabela of my banco but somehow, I tried to do this:

// ATRIBUI UMA CONEXÃO PDO   
$pdo = Conexao::getInstance();
// ATRIBUI UMA INSTÂNCIA DA CLASSE CRUD
$crud = Crud::getInstance($pdo, 'cadAgendaEvento');

// BUSCANDO EVENTOS
$sqlEvento = "SELECT * FROM `cadAgendaEvento`";

$dados = array();

foreach ($sqlEvento as $Retorno) {                      

    $dados = $Retorno;  

    echo json_encode(
        array(
            "success" => 1,
            "result" => $dados
        )
    );                              
}

I wonder if this format is correct, apparently not returning me anything.

Answer 1

By resemblance to code, I assume you’re using this library: http://www.devwilliam.com.br/php/crud-generico-com-php-e-pdo

If applicable, just use the method:

public function getSQLGeneric($sql, $arrayParams=null, $fetchAll=TRUE)`

For example:

// BUSCANDO EVENTOS
$dados = $crud->getSQLGeneric($sqlEventos);

At that point the variable $dados will already be an array with the database data.

You can browse this data using a foreach:

foreach ($dados as $dado) {   
    echo $dado;               
}

If you want to print a json the way it showed in your code, you don’t need the for:

echo json_encode(array(
        "success" => 1,
        "result" => $dados
));