Here's a very basic PHP solution which will convert from your input format to your output format:
$coord_array = sscanf($input, "lon = %f, lat = %f");
$x_coord = $coord_array[0];
$y_coord = $coord_array[1];
$output = "((" . $x_coord . " " . $y_coord . "))";
Sample data:
$input:
lon = 12.34, lat = 56.78
$output:
((12.34 56.78))
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!