HOME |  PHOTOS |  BOOKS |  INSTAGRAM |  CONTACT

$value) { $NATIONS[$i] = explode(",", $value); $i++; } unset($value); unset($read); unset($format); // ✖ CREATE ROUTE ARRAY $cityFILE= "https://spreadsheets.google.com/tq?tqx=out:csv&key=0AvVUEHcmdLvAdDlZQXpEM2xjQzFUVm42TmhScldVOUE"; $read = file_get_contents($cityFILE); $format = str_replace('"','',$read); $cities = explode("\n", $format); $i= 0; foreach($cities as $key => $value) { $ROUTE[$i] = explode(",", $value); if ($ROUTE[$i][5] == 1 ) { $NATLIST[]=$ROUTE[$i][1]; } $i++; } unset($value); unset($read); unset($format); array_shift($ROUTE); // ✖ CREATE MILES CONVERTER function miles2kms($miles) { $ratio = 1.609344; $kms = $miles * $ratio; return $kms; } // ✖ DECLARE VALUES $LAND = $ROUTE[0][25]; $AIR = $ROUTE[0][26]; $SEA = $ROUTE[0][27]; $tHOTEL = $ROUTE[0][7]; $tHOSTL = $ROUTE[0][8]; $tFAMLY = $ROUTE[0][9]; $tSUBLT = $ROUTE[0][10]; $tCAMPS = $ROUTE[0][11]; $tCOUCH = $ROUTE[0][12]; $tBUSES = $ROUTE[0][13]; $tTRAIN = $ROUTE[0][14]; $tAUTOS = $ROUTE[0][15]; $tFERRY = $ROUTE[0][16]; $tPLANE = $ROUTE[0][17]; $tFOOD = $ROUTE[0][18]; $tBEER = $ROUTE[0][19]; $tSTAY = $ROUTE[0][20]; $tTRAV = $ROUTE[0][21]; $tMISC = $ROUTE[0][22]; $tCULT = $ROUTE[0][23]; $tVISA = $ROUTE[0][24]; $tTOTAL = $tFOOD+$tBEER+$tSTAY+$tTRAV+$tMISC+$tCULT+$tVISA; $COUNTX = count($NATIONS); $COUNTZ = count($ROUTE); $NATLIST = array_unique($NATLIST); $tNATIONS = count($NATLIST); // ✖ CREATE VARIABLES for ($i=0; $i<=$COUNTX; $i++) { ${"t" . $NATIONS[$i][1]} = 0; ${"c" . $NATIONS[$i][1]} = 0; ${"v" . $NATIONS[$i][1]} = 0; ${"f" . $NATIONS[$i][1]} = 0; ${"h" . $NATIONS[$i][1]} = 0; ${"l" . $NATIONS[$i][1]} = 0; ${"o" . $NATIONS[$i][1]} = 0; ${"e" . $NATIONS[$i][1]} = 0; } // ✖ PARSE COUNTRIES for ($i=0; $i<=$COUNTZ; $i++) { if ($ROUTE[$i][5] == 1) { // BY COUNTRY ${"t" . $ROUTE[$i][1]} += ($ROUTE[$i][7]+ $ROUTE[$i][8] + $ROUTE[$i][9] + $ROUTE[$i][10] + $ROUTE[$i][11] + $ROUTE[$i][12]); ${"c" . $ROUTE[$i][1]} += ($ROUTE[$i][18] + $ROUTE[$i][19] + $ROUTE[$i][20] + $ROUTE[$i][21] + $ROUTE[$i][22] + $ROUTE[$i][23]+ $ROUTE[$i][24]); ${"v" . $ROUTE[$i][1]} += $ROUTE[$i][24]; ${"f" . $ROUTE[$i][1]} += $ROUTE[$i][18]; ${"l" . $ROUTE[$i][1]} += $ROUTE[$i][21]; ${"h" . $ROUTE[$i][1]} += $ROUTE[$i][20]; ${"o" . $ROUTE[$i][1]} += $ROUTE[$i][24]; ${"e" . $ROUTE[$i][1]} += $ROUTE[$i][23]; // BY REGION ${"t" . $ROUTE[$i][6]} += ($ROUTE[$i][7]+ $ROUTE[$i][8] + $ROUTE[$i][9] + $ROUTE[$i][10] + $ROUTE[$i][11] + $ROUTE[$i][12]); ${"c" . $ROUTE[$i][6]} += ($ROUTE[$i][18] + $ROUTE[$i][19] + $ROUTE[$i][20] + $ROUTE[$i][21] + $ROUTE[$i][22] + $ROUTE[$i][23]+ $ROUTE[$i][24]); ${"v" . $ROUTE[$i][6]} += $ROUTE[$i][24]; ${"l" . $ROUTE[$i][6]} += $ROUTE[$i][21]; ${"f" . $ROUTE[$i][6]} += $ROUTE[$i][18]; ${"h" . $ROUTE[$i][6]} += $ROUTE[$i][20]; ${"o" . $ROUTE[$i][6]} += $ROUTE[$i][24]; ${"e" . $ROUTE[$i][6]} += $ROUTE[$i][23]; } //IF } //FOR ?>

// Data is beautiful.


NUMBER OF DAYS TRAVELING:0
NUMBER OF COUNTRIES VISITED:

NUMBER OF DAYS PRIVATE HOUSE:
NUMBER OF DAYS LOCAL FAMILIES:
NUMBER OF DAYS IN HOTELS:
NUMBER OF DAYS IN HOSTELS:
NUMBER OF DAYS COUCHSURFING:
NUMBER OF DAYS OVERNIGHT BUS:

NUMBER OF LEGS BY BUS:
NUMBER OF LEGS BY TRAIN:
NUMBER OF LEGS BY CAR:
NUMBER OF LEGS BY BOAT:
NUMBER OF LEGS BY PLANE:

TOTAL SPENT ON FOOD:$
TOTAL SPENT ON DRINKS:$
TOTAL SPENT ON TRAVEL:$
TOTAL SPENT ON HOUSING:$
TOTAL SPENT ON CULTURE/TOURS:$
TOTAL SPENT ON OTHER:$
TOTAL SPENT ON VISAS:$

RUNNING DAILY AVERAGE:0
RUNNING MONTHLY AVERAGE:0
RUNNING TOTAL (ENTIRE TRIP):$





DISTANCE BREAKDOWN
DISTANCE TRAVELED MILES KILOMETERS
BY LAND
BY AIR
BY SEA
TOTAL DISTANCE



AVG / DAY AVG / DAY
TOTAL STAY TOTAL COST VISA ON FOOD ON HOUSING
\n"; echo "\n"; echo "\n"; echo "".$NATIONS[$i][0]."\n"; echo "" . ${"t" . $NATIONS[$i][1]} . " DAYS\n"; echo "$" . round(${"c" . $NATIONS[$i][1]}) . "\n"; echo "". $USD . ${"v" . $NATIONS[$i][1]} . "\n"; if (${"t".$NATIONS[$i][1]} > 0) { echo "$".round(${"f".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)."\n"; echo "$".round(${"h".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)."\n"; } else { echo "$0\n"; echo "$0\n"; } echo "\n"; echo "\n\n"; } if ($PANDA == 3) // IS REGION { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (${"t".$NATIONS[$i][1]} > 0) { echo "\n"; echo "\n"; } else { echo "\n"; echo "\n"; } echo "\n"; echo "
" .$NATIONS[$i][0]. "" . ${"t" . $NATIONS[$i][1]} . " DAYS$" . round(${"c" . $NATIONS[$i][1]}) . "$" . ${"v" . $NATIONS[$i][1]} . "$".round(${"f".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)."$".round(${"h".$NATIONS[$i][1]}/${"t".$NATIONS[$i][1]},0)."$0$0
\n\n"; } } // END FOR LOOP ?>