Sample code for JSON Data. It fetches and encodes data into JSON format

fetch.php

<?php
header("content-type:application/json");
mysql_connect("localhost","root","");
mysql_select_db("database");
$sql="select * from table";
$data=array();
$results=mysql_query($sql);
while($r=mysql_fetch_row($results))
{
   $data[] = array("title"=>$r[1],"author"=>$r[2]); 
}
echo json_encode($data);
?>