Create json Object by php from mysql result

Question

Possible Duplicate: JSON encode MySQL results I want to use php to create a json object like below. it will return a string as a response from result sql query. ``` {"Orders":[ {"DeliveryId":"DeliveryId","CustomerName":"CustomerName","PhoneNumber":"PhoneNumber","Address":"Address"}, {"DeliveryId":"DeliveryId","CustomerName":"CustomerName","PhoneNumber":"PhoneNumber","Address":"Address"} ] } ``` my code ``` <?php mysql_connect("mysql12.000webhost.com","a4602996_longvan","longvan2012"); mysql_select_db("a4602996_lv"); $id=$_POST[user]; $sql=mysql_query("select * from testlongvan where Status = 'PACKED'" ); $json = array(); if(mysql_num_rows($sql)){ while($row=mysql_fetch_row($sql)){ $json['Orders'][]=$row; } } //while($row=mysql_fetch_assoc($sql)) //$output[]=$row; print(json_encode($json)); mysql_close(); ?> ``` But when use my code the result is not what I expected: {"Orders":[ ["longvan","10/12/2012","Be34433jh","Long Van","115 Pham Viet Chanh, quan Binh Thanh","http://longvansolutio…

Accepted Answer

You have to create an array for each row to specify the field name and value.

```
$json['Orders'][] = array('DeliveryId' => $row[0], 'CustomerName' => $row[1], ...);
```

Or use mysqli_fetch_assoc() function if the table column name is exactly what you want to use in your JSON:

```
$rows = array();
while($r = mysqli_fetch_assoc($sql)) {
    $rows[] = $r;
}
$data = array('Orders' => $rows);
print json_encode($data);
```

Create json Object by php from mysql result

Solution

Problem

Related problems