Pick up specific fetchAll item in PHP

Question

Pick up specific fetchAll item in PHP

Asked 7 years, 8 months ago

Viewed 545 times

-1

I’m using the code:

$lista = $db->query('select * from tabela') or trigger_error($db->error);
$lista->execute();
$item = $lista->fetchAll(PDO::FETCH_ASSOC);
$mes = 1;
    while ($mes < 13){
    echo $obito[$mes]['total']; //quero listar o total aqui
    $mes++;
}

3

Hi Italo this $db is a PDO instance??

– Hiago Souza

2016/10/26 at 18:41
2

what is $db? what is queryMes? code missing before those lines.

– novic

2016/10/26 at 18:41
is a yes instance

– Italo Rodrigo

2016/10/26 at 18:41
1

May echo $item[3]['nome'];

– rray

2016/10/26 at 18:42
@Virgilionovic query works well, is that I simplified the code above. the variable $item should list all my items

– Italo Rodrigo

2016/10/26 at 18:42
2

@Italorodrigo do not simplify, put, really what you are doing, everything relevant and in the details.

– novic

2016/10/26 at 18:43
1

I will edit the question

– Italo Rodrigo

2016/10/26 at 18:44
1

use the print_r or var_dump to know if it comes as array or object. If it is a PDO instance, it must come as object.

– William Aparecido Brandino

2016/10/26 at 18:45
edited and posted the code I’m using now

– Italo Rodrigo

2016/10/26 at 18:50
1

That $lista->execute() doesn’t make any sense. Gives a print_r($obito) and ask the question, so everyone knows the structure of it.

– rray

2016/10/26 at 18:52
thanks to all, I managed to solve

– Italo Rodrigo

2016/10/26 at 18:55

Show 6 more comments

1 answer

Browser other questions tagged php mysqli

You are not signed in. Login or sign up in order to post.

by Hiago Souza • **5,837** points · Answer 1 · 2016-10-26T18:43:33+00:00

You can try the code below;

$host = 'localhost'; // endereço do servidor de banco de dados.
$dbname = 'seu_banco_de_dados'; //nome de sua base de dados
$user   = 'root'; // seu usuário do banco
$pass   = ''; // sua senha do banco

$db = new PDO('mysql:host='.$host.';dbname='.$dbname,$user,$pass);
$lista = $db->prepare(queryMes($ano,$ibge));
$lista->execute();
$item = $lista->fetchAll(PDO::FETCH_ASSOC);

echo $item[3]['nome'];

Or you can use the for to list...

$host = 'localhost'; // endereço do servidor de banco de dados.
$dbname = 'seu_banco_de_dados'; //nome de sua base de dados
$user   = 'root'; // seu usuário do banco
$pass   = ''; // sua senha do banco
$lista = $db->prepare(queryMes($ano,$ibge));
$lista->execute();
$item = $lista->fetchAll(PDO::FETCH_ASSOC);

foreach($item as $info) {
    echo $info['nome']."<br/>";
}