MySQL to geojson parser

getjson.php

<?php
header('Content-type: text/plain');
$username = "[user]";
$password = "[password]";
$hostname = "localhost";	
$database = "[database]";


// Opens a connection to a mySQL server
$connection=mysql_connect ($hostname, $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}

// Set the active mySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}

// json output - insert table name below after "FROM"
$query = 'SELECT * FROM survey';
$dbquery = mysql_query($query);

if(! $dbquery )
{
  die('Could not get data: ' . mysql_error());
}

// Parse the dbquery into geojson 
// ================================================
// ================================================
// Return markers as GeoJSON

$geojson = array(
    'type'      => 'FeatureCollection',
    'features'  => $feature
 );

while($row = mysql_fetch_assoc($dbquery)) {
    $feature = array(
        'type' => 'Feature', 
      'geometry' => array(
        'type' => 'Point',
        'coordinates' => array((float)$row['lon'], (float)$row['lat'])
            ),
      'properties' => array(
            'name' => $row['title']
        //Other fields here, end without a comma
            )
        );
    array_push($geojson, $feature);
};
mysql_close($connection);

// // Return routing result
    header("Content-Type:application/json",true);
    echo json_encode($geojson);
?>

How supposed to be the MySQL table?

@iWexter
Looks like a database table called 'survey'.

With the following 3 rows:

• title
• lon
• lat

But it's up to you, if you can program a bit of PHP.