getmedical.php

<?php

// Licence: DWYWT v 1.0 See LICENCE file

include "include/db.php";

// check what is passed
$bbox=$_GET['bbox'];

// split the bbox into its parts
list($left,$bottom,$right,$top)=explode(",",$bbox);

//open the database and get the road
$chconn = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$query=sprintf("SELECT * FROM medicalfacility WHERE east>='%1.7f' AND west<='%1.7f' AND north>='%1.7f' AND south<='%1.7f'",$left,$right,$bottom,$top);
$resroad = mysql_query($query);

$ret=array();

$geofeatures=array();
$geofeatures['type']="FeatureCollection";
$features=array();

// if there are no rows, that's OK, just return an empty object
while ($row=mysql_fetch_array($resroad)) {
	$feature=array();
	$feature['type']="Feature";
	$prop=array();
	$prop['osmid']=$row["osmid"];

	// get the list of lon/lat for the current road
	$medicalfacilityid=$row['id'];
	$pstyle=array();

	$ptsquery="SELECT * FROM tags WHERE medicalfacilityid='{$medicalfacilityid}' ORDER BY id";
	$respts=mysql_query($ptsquery);
    while ($ptsrow=mysql_fetch_array($respts)) {
        $prop[$ptsrow['okey']]=$ptsrow['oval'];
        if ($ptsrow['okey']=='amenity') {
            if ($ptsrow['oval'] == 'hospital') {
                $pstyle['color']="red";
            } else {
                $pstyle['color']="blue";
            }
        }
    }
	mysql_free_result($respts);

	$pstyle['stroke']=true;
	$prop['style']=$pstyle;
	$feature['properties']=$prop;
	$mcoords=array();

	// get the list of lon/lat for the current road
	$medicalfacilityid=$row['id'];

	$ptsquery="SELECT * FROM mpoints WHERE medicalfacilityid='{$medicalfacilityid}' ORDER BY id";
	$respts=mysql_query($ptsquery);
	if (mysql_num_rows($respts) > 1) {
		$geom=array();
		$geom['type']="LineString";
		// This medical facility is defined as a way
		while ($ptsrow=mysql_fetch_array($respts)) {
			$ll=array($ptsrow['lon'],$ptsrow['lat']);
			$mcoords[]=$ll;
		}
		$geom['coordinates']=$mcoords;
		$feature['geometry']=$geom;
	} else {
		// This facility is defined as a node
		$geom=array();
		$geom['type']="Point";
        $ptsrow=mysql_fetch_array($respts);
		$geom['coordinates'] = array($ptsrow['lon'],$ptsrow['lat']);
		$feature['geometry']=$geom;
	}
	mysql_free_result($respts);

	// add this to the list of features
	$features[]=$feature;

}
$geofeatures['features']=$features;
$ret['featlist']=$geofeatures;

// tidy up the DB
mysql_free_result($resroad);
mysql_close($chconn);

// encode the road array as json and return it. toads can be empty
$encoded = json_encode($ret);
exit($encoded);
?>