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.
Hello, I'm a specialist in geographic information systems. Perhaps I could help you.
Bu iş için 11 freelancer ortalamada $156 teklif veriyor
Dear Sir or Madam: Thank you for giving us opportunity to submit our proposal for your project. Our company have good team of people which includes: Project Manager, Web Developer, Web Designer, Q/A and Testing sta Daha Fazla
Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/projects/ Daha Fazla
Hi, I can provide the required solution. Please can you share more details. Regards.
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.
Hello, We have gone through from your requirements and we can deliver google map functionality as you want. Thanks