Converting MySQL result array to JSON

Question

I want to convert my database query's result array to JSON format in PHP. Here is my code:

$row = mysql_fetch_array($result)

I want to convert $row to JSON format and pass the JSON data to a jQuery plugin.

score 64 · Accepted Answer · edited Jan 31 '14 at 14:55

64

json_encode is available in php > 5.2.0:

echojson_encode($row);

edited Jan 31 '14 at 14:55

aksu

5,221
5
24
39

answered Jan 23 '10 at 05:22

jspcal

50,847
7
72
76

1

Hint: Use `JSON.parse(response)` to decode in JavaScript. – Black Apr 19 '18 at 12:29

score 6 · Answer 2 · answered Mar 11 '14 at 10:27

6

$result = mysql_query($query) or die("Data not found."); 
$rows=array(); 
while($r=mysql_fetch_assoc($result))
{ 
$rows[]=$r;
}
header("Content-type:application/json"); 
echo json_encode($rows);

answered Mar 11 '14 at 10:27

santhosh

77
1
1

1

Please, provide some additional information along with your answer. – Max Mar 11 '14 at 10:47

Converting MySQL result array to JSON

2 Answers2

Linked

Related