Basic-PHP MySQL Code

gistfile1.aw

<?php
$host = "localhost";
$username = "root";
$password = "123";
$db_name = "test";

$db=mysql_connect($host, $username, $password) or die('Could not connect');
mysql_select_db($db_name, $db) or die('no db');
$sth = mysql_query("SELECT * FROM sample s");
$rows = array();
while($r = mysql_fetch_assoc($sth)) {
    $rows[] = $r;
}
echo json_encode($rows);
?>