Make a JSON object from a mysql query

json-mysql-php.php

<?php //connect to DB
require('config.php');
include_once('includes/functions.php');

//get 10 of  the recent published posts out of the DB
$query = "SELECT posts.title AS post_title, posts.body AS description, posts.image AS url, users.username
			FROM posts, users
			WHERE posts.user_id = users.user_id
			AND posts.is_published = 1
			ORDER BY date DESC
			LIMIT 10";
//run it
$result = $db->query($query);
//check it
if(! $result){
	die($db->error);
}
if( $result->num_rows >= 1 ){
	$data = array();
	while($row = $result->fetch_assoc()){
		$data[] = $row;
	}
} //end if there are rows 
print(json_encode($data, JSON_UNESCAPED_SLASHES));?>