Geek Answers Handbook

Best way to store route data in MySQL

I am working on an application that requires me to store some directions for the location, below is an example of the data I am trying to save:

Direction 1
FROM THE WEST: Take 528 East (Beechline), take the exit from the airport, then take exit 13 to Narcosese Rd and turn LEFT, PARK TO FLY is 1/4 mile to your left.

Direction 2
From EAST: Take 528 West (Beechline), before exiting the airport, take exit 13 to Narcosese Rd and turn right, PARK TO FLY is 1/4 mile to your left.

Direction 3
From Florida Turnpike: Take the exit from 254 to 528 East (Beachline), go through the exit from the airport, then take exit 13 to Narcosese and turn LEFT, PARK FOR SUMMER, located 1/4 mile to your left.

Direction 4
From 417 (Greenway): Take exit number 26 to 528 West (Beechline), then take exit 13 at Narcosese Rd and turn RIGHT, PARK YEARS, 1/4 mile to your left.

Direction 5
C 408 (East / West Expressway): Take exit 16 to the Southern SSR. 551 (Goldenrod Rd). Drive aprox. 4 miles and turn left onto Hoffner Rd. Hoffner goes to Narcosis Rd. PARK TO FLY is 2 miles from you.

I was wondering if anyone could tell me the best and recommended way to store this data in MySQL.

, , , , , ? , .

, ?

mysql Locations, , Directions , .

  • .

2
, , , , , .. , , "" , , mysql.

!

+5
2

, , , "". - , FROM, FROM, .

+3

-, , PHP Mysql. :

place(
  place_id;
  place_name;
)
direction(
  direction_id;
  direction_name;
)
direction_place(
  direction_place_id;
  order;
  direction_id;
  place_id;
)

, .

-2

More articles:


All Articles