Need to display all records that contains the cities found with the 40 miles radius

$30-250 USD

Pågår

Lagt ut

omtrent 4 år siden

$30-250 USD

Betalt ved levering

``` $city_name = 'Miami'; $state = 'FL'; $distance = 40; $sql_city = "SELECT * FROM zip_codes WHERE city = ''.$city_name.'' and state = ''.$state.''"; if ($result_city->num_rows > 0) { // output data of each row while($row_city = $result_city->fetch_assoc()) { $lat1 = $row_city["latitude"]; $lon1 = $row_city["longitude"]; } } $sql_cities = "SELECT *, ( 3959 * acos( cos( radians($lat1) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($lon1) ) + sin( radians($lat1) ) * sin( radians( latitude ) ) ) ) AS distance FROM zip_codes HAVING distance < $distance;"; $result_cities = $conn->query($sql_cities); while($row_cities = $result_cities->fetch_assoc()) { $city = $row_cities["city"]; } $sql_loads = "SELECT * FROM loads WHERE active='1' AND origin_city='".$coming_from_city."' OR origin_city='".$city."' ORDER BY id DESC"; ?> ```

MySQL

PHP

Prosjekt-ID: 24684145

Om prosjektet

5 forslag

Eksternt prosjekt

Aktiv 4 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

Tildelt til:

@beeinfo

Hello, I am very interested in assisting you with your html table to show the records with in 40 miles of MI. I can do this in roughly 8-12 hours maximum. I am very skilled in php/mysql/html and custom development and have been working for over 10 years. I will make sure your table is responsive for all devices as well (mobile, tablet, desktop).Kindly send me a message here so that we can discuss and start the work immediately. Thank you for your opportunity. I look forward to hearing back from you. Thanks, Bee

$80 USD om 1 dag

4,9

(164 omtaler)

6,8

5 frilansere byr i gjennomsnitt $94 USD for denne jobben

@einnovention

Hi there! We are a company with more than 7 years of experience and +10million turnaround, Yes we can do this job within minimum posible time and cost :) Lets have a chat for detailed discussion :) we already have one for you, lets have a chat bro :) Best: Einnovention

$140 USD om 7 dager

4,9

(149 omtaler)

7,1

@wahajman

Hi. I can help you in completing to display all records that contains the cities found with the 40 miles radius a professional way. Be sure you will get the quality work and reliable help. Let's discuss further details via chat to proceed on the project. Waiting for positive response. Regards, Wahaj

$70 USD om 1 dag

4,9

(166 omtaler)

6,8

@cababay

Hello, i am a software architect from Turkey. I have experience on back-end development for about 10 years. I am expert on PHP and MySQL. I developed many similar projects. Please contact me. Thank you!

$120 USD om 2 dager

5,0

(22 omtaler)

4,8

@darkez85

How are you? I checked jpg file. Because I am php mysql javascript expert. I can assure you of a complete professional ворк on timeline. If you hire me, I will complete your project perfectly. Thank you very much

$60 USD om 7 dager