Radio station JSON test in PHP

<?php
    error_reporting(E_ALL ^ E_NOTICE);
//Copy of http://radioplayer.bauerradio.com/schedule.php?callback=?&name=Hallam+FM and
http://radioplayer.bauerradio.com/scheduleProxy.php?callback=?&name=Magic+105.4 for local purposes
//Details removed for anonymity
header("access-control-allow-origin: *");
header("Access-Control-Allow-Methods: GET");
  //db connection detils
  $host = "localhost";
  $user = "test";
  $password = "testing";
  $database = "radio1";

  //make connection
  $server = mysql_connect($host, $user, $password);
  $connection = mysql_select_db($database, $server);

  //query the database
  $query = mysql_query("SELECT *, DATE_FORMAT(start, '%d/%m/%Y %H:%i:%s') AS start,
                                   DATE_FORMAT(end, '%d/%m/%Y %H:%i:%s') AS end FROM radio1");

    //loop through and return results
  for ($x = 0, $numrows = mysql_num_rows($query); $x < $numrows; $x++) {
    //$row = mysql_fetch_assoc($query);
    while ($row = mysql_fetch_assoc($query)) {
   $foo['data'][] = $row;
}

    $shows[$x] = array("id" => $row["id"],"startminutes" => $row["startminutes"], "start" => $row["start"], "endminutes" => $row["endminutes"],"end" => $row["end"],"mediumname" => $row["mediumname"], "longname" => $row["longname"], "description" => $row["description"],"short_id" => $row["short_id"],"promomessage" => $row["promomessage"],"email" => $row["email"],"phonenumber" => $row["phonenumber"],"textnumber" => $row["textnumber"],"textprefix" => $row["textprefix"],"showimage" => $row["showimage"],"longdescription" => $row["longdescription"],"facebooklink" => $row["facebooklink"],"otherlink" => $row["otherlink"],"websitelink" => $row["websitelink"],"keywords" => $row["keywords"] );
  }
  header("content-type: application/javascript");
  //echo JSON to page
  $response = $_GET["callback"] . "" . json_encode($foo) . ";";
  echo $response;
  ?>