source: schedule/Transaction/source.php@ 17689

<?php
//connect to the mysql
$db = mysql_connect("localhost","scheduletest","t3stsched");
mysql_select_db('sandboxschedule', $db) or die("Could not select database");

//database query
$sql = @mysql_query("select*from source");

$rows = array();
while($r = mysql_fetch_assoc($sql)) {
  $rows[] = $r;
}

//echo result as json
echo json_encode($rows);
?>