How can we return an associative array which uses php classes with PDO?

Question

 public function displayMember()
    {
        $statement=$this->db->query("SELECT user_name,user_email,user_gender,date_of_join,user_firstname FROM tbl_users");
          while($row=$statement->fetch(PDO::FETCH_ASSOC))

This is from a class file. How we can return the associative array in the page where we display our values where we call the displayMember() method. What I need is to print the data not inside this function but to pass it and print it on the page I call this function inside a table.

And the question is...? What's unclear? Why it's not `$result[]=$row` inside loop? — Alma Do, Nov 06 '13 at 09:51
See fetchObj at http://php.net/manual/en/pdostatement.fetch.php — DarkBee, Nov 06 '13 at 09:56

score 0 · Answer 1 · answered Nov 06 '13 at 10:04

0

public function fetchMembers()
{
    $sql = "SELECT user_name,user_email,user_gender,date_of_join,user_firstname FROM tbl_users";
    return $this->db->query($sql)->fetchAll();
}
$members = $class->fetchMembers();

Now you can pass $members to template. It is not an associative array but rather a list though

answered Nov 06 '13 at 10:04

Your Common Sense

156,878
40
214
345

This didn't worked for me. – Krishnadas PC Nov 06 '13 at 13:29
I happens. You should try harder. – Your Common Sense Nov 06 '13 at 14:23

score -1 · Accepted Answer · answered Nov 09 '13 at 05:42

I found the answer finally. This is how it worked for me

public function displayMember()
    {
        $statement=$this->db->query("SELECT user_name,user_email,user_gender,date_of_join,user_firstname FROM tbl_users");
          while($row=$statement->fetch(PDO::FETCH_ASSOC))
           {
            $data[]=$row;
           }
         if(!empty($data))
          {
           return $data;
           }
}

And on the displaying page

if($obj->displayMember()!=NULL)
{

foreach($obj->displayMember() as $value)
{
extract($value);

echo $user_name.'<br>';
echo $user_email.'<br>';
echo $user_gender.'<br>';
//actually I echoed the values inside a table.

}
}

Thanks for all your support.

How can we return an associative array which uses php classes with PDO?

2 Answers2