Query Postgis Table with PHP

manpreet Best Answer 2 years ago

Would you be so kind as to help me with the following in OpenLayers. I need to be able to use the coordinates from a user click in a postgis query. To catch the coordinates of a click I built a click handler to use the function map.getLonLatFromViewPort(ext.xy), which delivers me the coordinates of my click in the following format: lon = 568417.33622114, lat = 681985.1902844. These are sent to a php-script using a GET request.

I then want to query my postgis db using ST_GeometryFromText, which requires that I put my coordinates in the following syntax ((568417.33622114 681985.1902844)).

Any help on how to get my coordinates in the correct format would be appreciated!

manpreet 2 years ago

$coord_array = sscanf($input, "lon = %f, lat = %f");
$x_coord = $coord_array[0];
$y_coord = $coord_array[1];
$output = "((" . $x_coord . " " . $y_coord . "))";

$input:
lon = 12.34, lat = 56.78
$output:
((12.34 56.78))