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

//new xml
$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers"); //head element markers
$parnode = $dom->appendChild($node);


$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);



?>