Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

PHP Forum


You are currently viewing our PHP Forum as a guest. Please register to participate.
Login



Freelance Jobs

Reply
Old 05-10-2008, 03:21 PM routes calculations
solomongaby's Avatar
Webmaster Talker

Latest Blog Post:
How Do You Find Music Online ?
Posts: 522
Name: Gabe Solomon
Location: Romania
Trades: 1
I have to make a script similar to that on http://www.uship.com/.
I needs to save routes in a database and have a search engine that whe enterint the start and end zip code will show all the routes close to that entered.

I have no ideea how to do this and ii was hoping you guys could point me in the right direction.

Thank you for your ideas.
__________________
If you like my posts ... TK is appreciated:)

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
solomongaby is offline
Reply With Quote
View Public Profile Visit solomongaby's homepage!
 
 
Register now for full access!
Old 05-10-2008, 05:54 PM Re: routes calculations
vectorialpx's Avatar
Extreme Talker

Posts: 241
Name: octavian
Location: Bucharest
Trades: 0
you don't know to take similar results, or what?
http://www.google.com/search?q=mysql+similar+results
or search at phpclasses something [there, sure, are some classes]
__________________
you can
Please login or register to view this content. Registration is FREE
vectorialpx is offline
Reply With Quote
View Public Profile Visit vectorialpx's homepage!
 
Old 05-11-2008, 04:27 AM Re: routes calculations
solomongaby's Avatar
Webmaster Talker

Latest Blog Post:
How Do You Find Music Online ?
Posts: 522
Name: Gabe Solomon
Location: Romania
Trades: 1
maybe my explinations were not clear. I will try again:
For example i input a route from Washington to New York. The results should return every shippings in the database that are along or close to that route ( meaning road from washington to new york ).

For example it should return a shipping from baltimore to wilmington because the route from Washington to New York passes trough them. Or a route from baltimore to Philadelphia ( here it should say how much miles/Km is of route ) since philadelphia is not on the search route but it is close to it.

Hope this makes thing clearer about my question.
__________________
If you like my posts ... TK is appreciated:)

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
solomongaby is offline
Reply With Quote
View Public Profile Visit solomongaby's homepage!
 
Old 05-11-2008, 01:56 PM Re: routes calculations
addonchat's Avatar
Super Talker

Posts: 115
Name: Chris Duerr
Trades: 0
I assume you have a database of these information to start with (geographical locations, road distances) but after that it's just a graph.

http://en.wikipedia.org/wiki/Graph_theory

And I think specifically what you're looking for

http://en.wikipedia.org/wiki/Shortest_path

Dijkstra is easy to implement:

http://en.wikipedia.org/wiki/Dijkstra%27s_algorithm
PHP code here: http://en.giswiki.net/wiki/Dijkstra's_algorithm
__________________
Chris Duerr
AddonChat Java Chat Software

Please login or register to view this content. Registration is FREE
-
Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE
addonchat is offline
Reply With Quote
View Public Profile
 
Old 05-11-2008, 02:05 PM Re: routes calculations
solomongaby's Avatar
Webmaster Talker

Latest Blog Post:
How Do You Find Music Online ?
Posts: 522
Name: Gabe Solomon
Location: Romania
Trades: 1
that is the thing .... i don't have the database. I was wondering if anybody has a service for this that they would recommend. I was thinking google maps.
Also how do you suppose i should store the shippings in the database for fast calculations for the application i described above. I reckon start Zip and end Zip, would not be to correct.
__________________
If you like my posts ... TK is appreciated:)

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
solomongaby is offline
Reply With Quote
View Public Profile Visit solomongaby's homepage!
 
Reply     « Reply to routes calculations
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.15808 seconds with 12 queries