# Thread: Distance calculation based on multiple locations including starting/ finish point

1. Registered User
Join Date
Jun 2007
Posts
25

## Distance calculation based on multiple locations including starting/ finish point

I would like to calculate the total distance of driving beetween multiple locations (loop), including the distance (starting point (garage) - first location sarting point) and (last location finishig point - finishing point (garage)). Example: (Garage + D1) + (D1 + D2) + (D2 + E1) + (E1 + E2) + E2 + Garage)

I'm having a problem with the correct looping. Here's my simplified code:

PHP Code:
``` <?\$driver = 5;     \$result2 = mysql_query("SELECT * FROM test WHERE id='\$driver' LIMIT 1") or die(mysql_error());     while(\$row2 = mysql_fetch_array( \$result2 )) {         \$lon=\$row2['lon'];         \$lat=\$row2['lat'];    echo "\$lon, \$lat";     }   \$result = mysql_query("SELECT * FROM test1 WHERE driver='\$driver'") or die(mysql_error());      while(\$row = mysql_fetch_array( \$result )) {         \$lon1=\$row['lon1'];         \$lat1=\$row['lat1'];         \$lon2=\$row['lon2'];         \$lat2=\$row['lat2'];        //////////  distance between driver address and starting address            \$distancecalc = (3958*3.1415926*sqrt((\$lat-\$lat1)*(\$lat-\$lat1) + cos(\$lat/57.29578)*cos(\$lat1/57.29578)*(\$lon-\$lon1)*(\$lon-\$lon1))/180);        //////////  distance between statring address and finishing address  - multiple adsresses        \$distancecalc1 = \$distancecalc1 + (3958*3.1415926*sqrt((\$lat2-\$lat1)*(\$lat2-\$lat1) + cos(\$lat2/57.29578)*cos(\$lat1/57.29578)*(\$lon2-\$lon1)*(\$lon2-\$lon1))/180);        //////////  distance between finishing address and driver address        \$distancecalc2 = (3958*3.1415926*sqrt((\$lat2-\$lat)*(\$lat2-\$lat) + cos(\$lat2/57.29578)*cos(\$lat/57.29578)*(\$lon2-\$lon)*(\$lon2-\$lon))/180);        \$distancetotal = \$distancecalc + \$distancecalc1 +\$distancecalc2;        echo "\$distancecalc<br>        \$distancecalc1<br>        \$distancecalc2<br>";    }    echo "\$distancetotal";  ?> ```
I'm aware that code posted above doesnt't do what it meant to .. i just want to keep it clear.. there is some things i tried but no correct resoults.

I would appreciate some help on this one.

Thank you very much.

2. Registered User
Join Date
Jun 2007
Posts
25
Ok. I worked it out with help of mac_gyver (php freaks). All calculations are done as i wish. My code below:

PHP Code:
``` <? include "connectdb.php"; \$driver = 5; \$datestamp = '2013/05/07'; \$result2 = mysql_query("SELECT * FROM drivers WHERE id='\$driver' LIMIT 1") or die(mysql_error()); while(\$row2 = mysql_fetch_array( \$result2 )) { \$lon=\$row2['lon']; \$lat=\$row2['lat']; } \$result = mysql_query("SELECT * FROM quotedb WHERE moveday='\$datestamp' AND driver='\$driver' AND cleared='Not Cleared' AND status='Done' ORDER BY moveday, timeday") or die(mysql_error()); \$distance = 0; // accumulate the distance \$first_pass = true; // flag to detect the first row inside the loop while(\$row = mysql_fetch_assoc( \$result )) { \$lon2a=\$lon2; \$lat2a=\$lat2; \$lon1=\$row['lon1']; \$lat1=\$row['lat1']; \$lon2=\$row['lon2']; \$lat2=\$row['lat2']; // calculate the distance from the Garage to the first point of the first row if(\$first_pass){ \$distance += (3958*3.1415926*sqrt((\$lat-\$lat1)*(\$lat-\$lat1) + cos(\$lat/57.29578)*cos(\$lat1/57.29578)*(\$lon-\$lon1)*(\$lon-\$lon1))/180); \$first_pass = false; } // calculate the distance for each row (segment) in the route \$distance += (3958*3.1415926*sqrt((\$lat2-\$lat1)*(\$lat2-\$lat1) + cos(\$lat2/57.29578)*cos(\$lat1/57.29578)*(\$lon2-\$lon1)*(\$lon2-\$lon1))/180); if ( \$lon2a == "" or \$lat2a =="" ) { } else { // calculate the distance from the second point of the first row to the first point of the next row \$distance += (3958*3.1415926*sqrt((\$lat2a-\$lat1)*(\$lat2a-\$lat1) + cos(\$lat2a/57.29578)*cos(\$lat1/57.29578)*(\$lon2a-\$lon1)*(\$lon2a-\$lon1))/180); } } // calculate the distance from the second point of the last row to the Garage \$distance += (3958*3.1415926*sqrt((\$lat2-\$lat)*(\$lat2-\$lat) + cos(\$lat2/57.29578)*cos(\$lat/57.29578)*(\$lon2-\$lon)*(\$lon2-\$lon))/180); echo "\$distance<br> "; ?> ```
Still think there is a place for improvement in the code. Will aplay Haversine method for calculations. Do you guys have some suggestion to improve this piece of code ... thx

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•

"

"

## X vBulletin 4.2.2 Debug Information

• Page Generation 0.11635 seconds
• Memory Usage 2,858KB
• Queries Executed 15 (?)
Template Usage (33):
• (2)bbcode_php
• (1)footer
• (1)forumjump
• (1)forumrules
• (1)gobutton
• (2)memberaction_dropdown
• (1)navbar
• (1)navbar_moderation
• (1)navbar_noticebit
• (1)navbar_tabs
• (2)option
• (2)postbit
• (2)postbit_onlinestatus
• (2)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (26):
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/config.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./includes/functions_calendar.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/functions_notice.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php

Hooks Called (73):
• init_startup
• friendlyurl_resolve_class
• init_startup_session_setup_start
• database_pre_fetch_array
• database_post_fetch_array
• init_startup_session_setup_complete
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_postinfo_query
• fetch_postinfo
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• strip_bbcode
• friendlyurl_clean_fragment
• friendlyurl_geturl
• forumjump
• cache_templates
• cache_templates_process
• template_register_var
• template_render_output
• fetch_template_start
• fetch_template_complete
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit
• tag_fetchbit_complete
• forumrules
• navbits
• navbits_complete