Having trouble while encoding json Array in php

Question

I have two different queries which I have to append in same array in form of JSON..

Here is my code from 1st query...

while($row = mysqli_fetch_array($res)) {
    array_push($result,array('name'=>$row[0],'photo'=>$row[1],'rollno'=>$row[2],'id'=>$row[3]));
}

Here is my second query push similar as first one.. number of rows is always same as above query

array_push($result,array('status'=>'$status');

After that I'm encoding them like this

echo json_encode(array("result"=>$result));

Here is what I am getting

{"result":[{"name":"Abhishek Singh","photo":"http:\/\/onsitesupport.info\/diary\/photos\/student\/26.png","rollno":"1","id":"26"},
          {"status":"status"}]

But I want to result like this

 {"result":[{"name":"Abhishek Singh","photo":"http:\/\/onsitesupport.info\/diary\/photos\/student\/26.png","rollno":"1","id":"26","status":"status"}]

I mean status will merge into my every node... how can I achieve this..?

user array_merge insted of array_push like this array_merge($result,array('status'=>'$status'); — JYoThI
– JYoThI, Commented Jan 12, 2017 at 5:46
@JYoThI not worked after doing this it was added like this.... {"result":{"0":{"name":"Abhishek Singh","photo":"http:\/\/onsitesupport.info\/diary\/photos\/student\/26.png","rollno":"1","id":"26"},"status":"status"}} — Abhishek Singh
– Abhishek Singh, Commented Jan 12, 2017 at 5:48
@JYoThI status gone right now... {"result":[{"name":"Abhishek Singh","photo":"http:\/\/onsitesupport.info\/diary\/photos\/student\/26.png","rollno":"1","id":"26"}]} — Abhishek Singh
– Abhishek Singh, Commented Jan 12, 2017 at 5:52
do a $result['status'] = $status; then do your array_push — Ruslan Abuzant
– Ruslan Abuzant, Commented Jan 12, 2017 at 5:53

mith · Accepted Answer · 2017-01-12 06:15:28Z

2

Try the below to add status field to each array:

while($row = mysqli_fetch_array($res)){
      array_push($result,array('name'=>$row[0],'photo'=>$row[1],'rollno'=>$row[2],'id'=>$row[3]));
}

$res_row = 0;
while($row2 = mysqli_fetch_array($res2)){
   $status = $row2[0]; // status value here
   $result[$res_row]['status']=$status;
   $res_row++;
}

echo json_encode(array("result"=>$result));

answered Jan 12, 2017 at 6:15

mith

1,7001 gold badge10 silver badges13 bronze badges

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

5 Comments

Abhishek Singh Over a year ago

a littile bit issue with it ... a status null is adding at start... all nodes are assigned a name like 0,1,2

mith Over a year ago

I am not clear with your issue. can you please explain more... @Abhishek

Abhishek Singh Over a year ago

i am getting this... {"result":{"status":null,"0":{"name":"Abhishek Singh","photo":"http:\/\/onsitesupport.info\/diary\/photos\/student\/26.png","rollno":"1","id":"26","status":"P"}}}

Abhishek Singh Over a year ago

all status are correct but a status was adding at start

Abhishek Singh Over a year ago

sorry it was my mistake of adding a null status.. thanks for you help

Ruslan Abuzant · Accepted Answer · 2017-01-12 05:59:10Z

1

Try this please, using temporary arrays that are merged after all your queries are complete:

// Query 1
while($row = mysqli_fetch_array($res)){
$tmpResults[] = $row;
}

// Query 2
$tmpResult2 = array('status'=>'$status');

// Merge Everything
$final = array_merge($tmpResults, $tmpResult2);

// Encode
$json = json_encode($final, TRUE);

Good luck

answered Jan 12, 2017 at 5:59

Ruslan Abuzant

6316 silver badges17 bronze badges

1 Comment

Abhishek Singh Over a year ago

Thanks for you help

Collectives™ on Stack Overflow

Having trouble while encoding json Array in php

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related