how to use array_push for json_encode

Usama Sadiq picture Usama Sadiq · Mar 15, 2014 · Viewed 41.6k times · Source

I am iOS developer and I am making Webservices in PHP for getting JSON Response.

Code which I wrote is:

    $result = mysqli_query($con,"SELECT * FROM wp_marketcatagories");
    $data =array();
    while($row = mysqli_fetch_array($result))
                 {
                 $data[] = array_push($data, array('id' => $row['id']));
                 }
    $json = json_encode($data);
    echo $json;

This is what I want in result:

[{"id":"1"},{"id":"2"},{"id":"3"},{"id":"4"},{"id":"5"},{"id":"6"},{"id":"7"},{"id":"8"},{"id":"9"},{"id":"10"},{"id":"11"},{"id":"12"}]

But above code is giving me like this:

[{"id":"1"},1,{"id":"2"},3,{"id":"3"},5,{"id":"4"},7,{"id":"5"},9,{"id":"6"},11,{"id":"7"},13,{"id":"8"},15,{"id":"9"},17,{"id":"10"},19,{"id":"11"},21,{"id":"12"},23]

From where this 1, 3, 5 ,.... are coming ?

Answer

anurupr picture anurupr · Mar 15, 2014

no need to assign it to $data[]. You are already pushing the values to the array $data

Just simply use

 array_push($data, array('id' => $row['id']));

instead of

 $data[] = array_push($data, array('id' => $row['id']));