Schedule of appointments using fetchAll (PDO :: FETCH_NAMED)

Question

Schedule of appointments using fetchAll (PDO :: FETCH_NAMED)

Navigation

#1 by (2 votes)
#2 by (1 votes)

-2

I'm using fetchAll (PDO :: FETCH_NAMED) to get the records from my database.

I received the following array

Array ( 
        [0] => Array ( 
              [idAgenda] => 2 
              [dataAgenda] => 1996-02-14 
              [localAgenda] => teste 
              [cidadeAgenda] => São Paulo 
        ) 
        [1] => Array ( 
              [idAgenda] => 1 
              [dataAgenda] => 1996-02-14 
              [localAgenda] => teste2 
              [cidadeAgenda] => Santos 
        ) 
 )

I wanted to know how I get the data separately from this array?

php pdo fetchall

asked by anonymous 23.05.2016 / 01:03

2 answers

2

Good evening, So there are several ways to retrieve this information I recommend is the foreach. But I'll leave the two examples.

Example with foreach

<?php

//... daqui para trás é o seu código
$dados = $dbh->fetchAll(PDO::FETCH_NAMED);

foreach($dados as $dado) {
    echo $dado['idAgenda'] . '<br />';
    echo $dado['dataAgenda'] . '<br />';
}

Example with FOR

<?php

//... daqui para trás é o seu código
$dados = $dbh->fetchAll(PDO::FETCH_NAMED);
$quantidadeReg = count($dados);
for($i = 0; $i < $quantidadeReg; $i++) {
    echo $dados[$i]['idAgenda'] . '<br />';
    echo $dados[$i]['dataAgenda'] . '<br />';
}

23.05.2016 / 01:28

Responsibility to keep information of items in a class What is eth0, wlan0, wlo1? [closed]

score 1 · Accepted Answer

1

Good evening,

Here is an example of how you will retrieve the values.

foreach ($array as $value) {
    //$value se tornará um array
    $a = $value["item"];
}

There you go!

23.05.2016 / 01:18