Hi there,
I’m trying to pull data from MySQL, basically when I fetch from the result set a multi-dimensional array is created. And this means I have to use a loop inside another loop to start manipulating the data. I guess I want to have it create a single-dimensional array so I can use a single loop to manipulate data. Below is the code:
class List {
public function __contruct(){
$this->db = new Database();
}
public function getAll(){
if($sth = $this->db->query('SELECT * FROM admin')){
$sth->setFetchMode(PDO::FETCH_ASSOC);
return $sth->fetchAll();
}
}
}
…and calling the method from class…
$list = new List();
$result = $list->getAll();
while($row = $result){
echo $row['first_name'];
echo $row['last_name'];
echo $row['email'];
}
I’m kind of confused a bit, what I’m I doing wrong? if I print_r on result this is what I am getting:
print_r($result);
Array
(
[0] => Array
(
[id] => 1
[first_name] => David
[last_name] => Daniels
[email] => dave@yahoo.com
)
[1] => Array
(
[id] => 2
[first_name] => stacey
[last_name] => stone
[email] => stace@gmail.com
)
)