How can i create a search query in php which retrieves results as coordinates from postgresql and views the results as a map (google map or open street map)
This is a very vague question. So, I will answer it the same way.
You write a sql query to get the data and return it to the frontend for the points to be created in google maps.
ok, so you have postgres up and running with postgis?
php connects via pdo.
the queries will return WKT strings.
you can use them within the google javascript SDK, but lat/lon must be interchanged.
1 Like