Create json Object by php from mysql result [duplicate]

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://longvansolution.tk/image/sample.jpg","PACKED","0909056788"], ["takeshi","24/12/2012","BF6464633","Vn-zoom","16 nguyen cuu van, quan binh thanh","http://longvansolution.tk/image/hoadon3.jpg","PACKED","098897657"] ]}

Can you help me?

There is a matching question + answer concerning the string-type-problem at: stackoverflow.com/questions/28261613/… — Marcel Ennix
– Marcel Ennix, Commented Feb 1, 2015 at 11:27

Stanley · Accepted Answer · 2013-11-09 04:37:12Z

14

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);

edited Nov 9, 2013 at 4:37

answered Dec 19, 2012 at 3:31

Stanley

5,1474 gold badges37 silver badges44 bronze badges

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

3 Comments

jamis0n Over a year ago

Does anyone know how to get all the columns in one line from each $row result? Without specifying each column name?

Stanley Over a year ago

Use mysql_fetch_assoc() function

dualed Over a year ago

No, use mysql i _fetch_assoc()

Collectives™ on Stack Overflow

Create json Object by php from mysql result [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related