how to get an array of objects from sql query

Question

My code is

$sql = 'select * from table;' $res = $connection->query($sql);
while($row = mysqli_fetch_row($res){'tackle output'};

to get an object

while($row = $res->fetch_object()){'tackle output'};

Question: what do I have to do to get an array of objects, so my output is thus

$data[$row[0]]= fetch_object();

fecth_assoc is an array. $row['fieldName'], i need an array of objects. — bluepinto
– bluepinto, Commented May 17, 2016 at 10:08

Majid Abbasi · Accepted Answer · 2016-05-17 10:03:43Z

2

try this one:

$data = array();
while($row = $res->fetch_object()){
      $data[] = $row;
}

answered May 17, 2016 at 10:03

Majid Abbasi

1,5313 gold badges12 silver badges22 bronze badges

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

3 Comments

I need a rec id to be the array index. For use in, if(isset($data[$id})){do something}

put it like $data[$row->id] = $row;

@bluepinto you are welcome, i have answered your question, if its helpful to you please fill free to accept and UV answer

Brijal Savaliya · Accepted Answer · 2016-05-17 11:00:16Z

1

Use it like

$data = array();
while($row = $res->fetch_object()){
      $data[$row->id] = $row;
}

answered May 17, 2016 at 11:00

Brijal Savaliya

1,0919 silver badges19 bronze badges

ibrahim mohho · Accepted Answer · 2016-05-17 10:05:40Z

0

answered May 17, 2016 at 10:05

ibrahim mohho

515 bronze badges