<?
$username="db30";
$password="FJJAcyMU";
$localhost="utb-mysql.du.se";
$database="db30";
?>

<?php
//db
require("dbinfo.php");

$connection=mysql_connect ($localhost, $username, $password);//connect
if (!$connection) {  die('Not connected : ' . mysql_error());}


$db_selected = mysql_select_db($database, $connection); //vilken databas sp, gäller
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}


$query = "SELECT * FROM kh07jowan_android"; //select all
$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}
 $rows = array();

 while ($row = mysql_fetch_array($result))
        {
            $rows[] = $row;
        }

echo json_encode($rows);



?>