PHP, JSON, and MySQL

Question

What is the easiest way to retrieve data from the database, and convert the data to a JSON String?

Is there any kind of helper class? or am I supposed to loop through the columns in my dataset to create the JSON string?

Answer 1

You can use the json_encode function to convert a native PHP array or stdClass object to it's corresponding JSON representation:

$result = $db->query('SOME QUERY');
$set = array();
if($result->num_rows) {
   while($row = $result->fetch_array()) {
      $set[] = $row;
   }
}
echo json_encode($set);