PHP PDO combine separate array

Question

I have following function which returns multiple rows of data, but it is returning separate arrays:

   function getAllDataByID($uid)
   {
   try {  

            $conn = DB::db_connect();
            $sql = "Select id from tbl1 where uid =:uid";
            $query = $conn->prepare($sql);
            $query->execute(array(':uid'=>$uid));
            $query->setFetchMode(PDO::FETCH_ASSOC);
            return $query;
        }
        catch (Exception $e) {
            return $e->getMessage();
        }   
   }

output:

array(1) {
  ["id"]=>
  string(2) "22"
}
array(1) {
  ["id"]=>
  string(2) "21"
}
array(1) {
  ["id"]=>
  string(2) "18"
}

Whereas I want it to be a nested array.

Possible duplicate of How to create a nested array out of an array in PHP — PacMan
– PacMan, Commented Apr 13, 2016 at 19:43
Basically, nested means i can access the array like $arr['id'][0],$arr['id'][1], $arr['id'][2] i want to print all the result with loop and with this seperate array's i am not able to do it — Daljeet Seni
– Daljeet Seni, Commented Apr 13, 2016 at 19:50

David Wyly · Accepted Answer · 2016-04-13 19:40:39Z

0

Sounds like you want to use PDO::FETCH_COLUMN, which will return tuples

answered Apr 13, 2016 at 19:40

David Wyly

1,7011 gold badge11 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zsoro · Accepted Answer · 2018-04-15 16:52:54Z

0

I am using my custom Database class for querying, inserting, updating and deleting in short working with my database and it works flawlessly. You do not have to use it but worth check out line 85 while ($row = $this->statement->fetch(PDO::FETCH_ASSOC)) where I append the row to existing array which will be used to return data in a way you need.

answered Apr 15, 2018 at 16:52

zsoro

801 silver badge11 bronze badges

Collectives™ on Stack Overflow

PHP PDO combine separate array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related