Adding values to MySQL results array

Question

I'm using this to get MySQL results into an array

$var = array();
$sql = "SELECT doc as document ,part, `desc`, price, qty, total FROM parts LIMIT 10";

$result = mysqli_query($con, $sql);

while($obj = mysqli_fetch_object($result)) {        
$var[] = $obj;  
}

That works great. Is it possible to add a value to each row? Something like

$var = array();
$sql = "SELECT doc as document ,part, `desc`, price, qty, total FROM parts LIMIT 10";

$result = mysqli_query($con, $sql);

while($obj = mysqli_fetch_object($result)) {        
$var[] = $obj;  
array_push($var['url'] = $url);
}

Jayesh Chitroda · Accepted Answer · 2016-05-18 13:44:25Z

2

You should append url into $obj and then store $obj into $var array:

while($obj = mysqli_fetch_object($result)) {  
  $obj->url = $url;     // first store url into obj
  $var[] = $obj;  
}

edited May 18, 2016 at 13:44

answered May 18, 2016 at 13:10

Jayesh Chitroda

5,03915 silver badges18 bronze badges

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

3 Comments

user3572565 Over a year ago

Thanks - But I get Fatal error: Cannot use object of type stdClass as array on this line $obj['url'] = 'ggggg';

user3572565 Over a year ago

Yes! Perfect. Thank you very much

Arulkumar Over a year ago

@JayeshChitroda: if $obj->url = $url; works instead of $obj['url'] = $url; please update the same in the answer. It can helpful for those who looking the same answer in future, it may possible that they miss your comments and simply check your answer only.

Ranjit Shinde · Accepted Answer · 2016-05-18 13:11:33Z

0

Hope this will help.

while($obj = mysqli_fetch_object($result)) {        
    $var[] = array($obj,'url'=>$url);
}

answered May 18, 2016 at 13:11

Ranjit Shinde

1,1301 gold badge8 silver badges24 bronze badges

1 Comment

user3572565 Over a year ago

Thanks - But this puts the url outside of the row data - {{"document":"IH767898","part":"EHA320","desc":" 1.4 HH 11\/2","price":"10.31","qty":"1","total":"10.31","corder":"Frank"},"url":"www.test.com"}

Collectives™ on Stack Overflow

Adding values to MySQL results array

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related