<?php
	$db = new PDO("pgsql:host=localhost; dbname=gmq717", "postgres", "gmq717");
	if ($_GET['var'] == 'pop') {
		$sql = 'SELECT pop / (ST_AREA(ST_TRANSFORM(geom, 32098)) / 1000000.0) as var, da_number, ST_AsGeoJSON(geom, 6) as geom FROM "montreal_postgis" WHERE ' . $_GET['var'] . ' > ' . $_GET['varMin'] . ' AND ' . $_GET['var'] . ' < ' . $_GET['varMax'] . ';';
	} else {
		$sql = 'SELECT ' . $_GET['var'] . '::INTEGER as var, da_number, ST_AsGeoJSON(geom, 6) as geom FROM "montreal_postgis" WHERE ' . $_GET['var'] . ' > ' . $_GET['varMin'] . ' AND ' . $_GET['var'] . ' < ' . $_GET['varMax'] . ';';
	}
	$query = $db->query($sql);
	echo json_encode($query->fetch());
?>