getcircle.php

<?php

	ini_set('display_errors', 1);
	ini_set('display_startup_errors', 1);
	error_reporting(E_ALL);

	$id = $_GET['id'];
	$pid = $_GET['pid'];
	$k = $_GET['k'];

	require('db.php');

	$query = "SELECT a.pid, st_distance(a.geom, b.geom) as dist FROM points a, (select geom from points where pid = ".$pid." AND id = ".$id.") b WHERE a.id = ".$id." ORDER BY dist LIMIT 1 OFFSET 1"; 

	$result = pg_query($query) or die(pg_last_error());
	while($row = pg_fetch_object($result)) {
		$qid = intval($row->pid); // . "\t" . $row->dist . "\n";
		$query2 = "SELECT st_asgeojson(st_buffer((ST_MinimumBoundingRadius(st_collect(geom))).center,(ST_MinimumBoundingRadius(st_collect(geom))).radius)) as json, st_area(st_transform(st_buffer((ST_MinimumBoundingRadius(st_collect(geom))).center,(ST_MinimumBoundingRadius(st_collect(geom))).radius),3857)) as area FROM (SELECT a.pid, a.geom, st_distance(a.geom, b.geom) as dist FROM points a, (select geom from points where pid = ".$qid." AND id = ".$id.") b WHERE a.id = ".$id." ORDER BY dist LIMIT ".$k.") c";
		$res = pg_query($query2) or die(pg_last_error());
		while($row = pg_fetch_object($res)) {
			header('Content-Type: application/json; charset=utf-8');
			$out = json_decode($row->json);
			$out->properties = (Object)array();
			$out->properties->area = round($row->area);
			echo json_encode($out);
			//echo $row->json;
		}
	}
	/* $str = "SELECT st_asgeojson(ST_ConvexHull(ST_GeomFromText('MULTIPOINT(" . implode(",",$geom) . ")'))) as json;";
	$result = pg_query($str) or die(pg_last_error());

	

	while($row = pg_fetch_object($result)) {
		 //. "\n";
	} */

?>