json_from_db.php

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db('myapp_development');

$query = empty($_GET['query']) ? '' : $_GET['query'];

$rows = mysql_query("SELECT * FROM users where username like '%$query%' ORDER BY created_at DESC");
while ($obj = mysql_fetch_object($rows)) {
  $arr[] = $obj;
}
header('Content-type: application/json');
echo '{rows:' . json_encode($arr) . '}';
?>