// PHP Code first!
//Read from DB
$dbh = mysql_connect ("localhost", "davidg3_user", "dbr0xx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("davidg3_mydb");
$query = "SELECT * FROM routes WHERE id ='".$_GET["id"]."'";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
//echo "Data Read:
";
//echo "Route Name:".mysql_result($result, 0, "name")."
";
//echo "Description:".mysql_result($result, 0, "desc")."
";
//echo "Coordinates:".mysql_result($result, 0, "coords")."
";
// routePoints holds the course coordinates, 1 (x,y) pair per array element
$routePoints = explode("|", mysql_result($result, 0, "coords"));
//print "first: $routePoints[0]";
// Closing connection
mysql_close($dbh);
?>
Dave's Running Routes: Your Route
Route name:
This route is suitable for:
if (mysql_result($result, 0, "bike") == "y"){
echo "-- Biking
";
}
if (mysql_result($result, 0, "run") == "y"){
echo "-- Running";
}
?>
Your route begins in:
if (mysql_result($result, 0, "street") != ""){
echo mysql_result($result, 0, "street").", ";
}
if (mysql_result($result, 0, "town") != ""){
echo mysql_result($result, 0, "town").", ";
}
if (mysql_result($result, 0, "state") != ""){
echo mysql_result($result, 0, "state").", ";
}
if (mysql_result($result, 0, "country") != ""){
echo mysql_result($result, 0, "country");
}
?>
//Directions block
if (($dir=mysql_result($result, 0, "directions")) != ""){
echo <<
How to get there:
$dir
END;
}
?>
Description:
echo mysql_result($result, 0, "desc"); ?>
Length:
echo round(mysql_result($result, 0, "length"), 1)." miles (".round(mysql_result($result, 0, "length")*1.609, 1)."km)";
?>
Date added:
echo mysql_result($result, 0, "dateadd"); ?>
return to the route list or print.