32

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.

Improve this question
0

2 Answers 2

Reset to default
64

json_encode is available in php > 5.2.0:

echojson_encode($row);

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

1 Comment

Hint: Use JSON.parse(response) to decode in JavaScript.
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);
Improve this answer

1 Comment

Please, provide some additional information along with your answer.