Search code examples
phpjsonmysqliresultset

Converting MySQL result array to JSON


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.


Solution

  • json_encode is available in php > 5.2.0:

    echojson_encode($row);