We are developing a draw search feature on our property website, similar to [url removed, login to view]
This draw search feature allows a user to draw a defined area on a map, and properties available within that defined area will show in the search results.
99% of the work has been done. We have the map returning the coordinates (lat/lon) when the user selects an area and we have the lat/lon coordinates of every property in our database.
However we need help with one line for sql query which will match the coordinates with the relevant properties. We really just need one line of code………just now we have $Contains = "AND Contains(GeomFromText('POLYGON((".$coords."))'),GeomFromText(property_latitude,property_longitude))"; which does not appear to be working.
Urgent turnaround required on this.
11 freelancer bu iş için ortalamada 156$ teklif veriyor
Hi, I have a very quick solution for this. I am very familiar Google maps API. I can fix this issue right away. Please see the PM for more details Regards, Eswar.
I have good depth on PHP. I am also good with SQL Query. This project Is very interesting to me. I would like to have the change to work with this project. Ready to go.