Help Needed with Google Maps Draw Search Code

In Progress

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.

Skills: MySQL, PHP

See more: php code for property search, html code for developing website, maps on line, google map with sql, draw map, mysql search area code, google draw, google query, search google mysql, rightmove draw map, google coordinates, google draw search rightmove, google maps draw search rightmove, urgent sale, search feature, website rightmove, google maps working, draw polygon google maps, google map search mysql, mysql coordinates, polygon area, search maps, sql query help, property search code php, search feature php

About the Employer:
( 36 reviews ) Bournemouth, United Kingdom

Project ID: #4458946

Awarded to:

AlexYes

Hello, I'm a specialist in geographic information systems. Perhaps I could help you.

$55 USD in 2 days
(1 Review)
1.5

11 freelancers are bidding on average $156 for this job

graphicaa

We can assist you for an optimum cost. Thanks

$154 USD in 7 days
(116 Reviews)
6.8
oneclickdevelop

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 More

$241 USD in 10 days
(99 Reviews)
6.5
linuxfreak1985

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/ More

$309 USD in 5 days
(80 Reviews)
6.1
ashwanii

Hi, I can provide the required solution. Please can you share more details. Regards.

$147 USD in 4 days
(18 Reviews)
5.9
Eswar87

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.

$169 USD in 3 days
(36 Reviews)
5.8
stdhtelkom

Hello, I have done it previously. Please check pmb. All the best, Steve.

$154 USD in 1 day
(15 Reviews)
5.6
skysap

i am ready for this,let me do it for you. param is very important

$105 USD in 1 day
(5 Reviews)
3.0
raisuddin79

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.

$110 USD in 3 days
(6 Reviews)
2.4
rushicoder

Hello, We have gone through from your requirements and we can deliver google map functionality as you want. Thanks

$77 USD in 3 days
(1 Review)
0.0
carloscosta68

Hi I'm a Web Map and Gis developer (since 2005) (Google Map, Google Earth, Bing Maps, OpenLayers, Mapserver, MapGuide -Coldfsuion/ PHP /Javascript/Jquery/Json/XML/APIs - SqlServer/MySql/Oracle) I can help you wi More

$198 USD in 7 days
(0 Reviews)
0.0
keyStride

Seems like a simple task. Can we chat on PMB?

$66 USD in 3 days
(0 Reviews)
0.0