include("zpd.php");
?>
mysql_connect($db_host,$db_user,$db_pass) or die("Could not connect to MySQL (Main connection)");
mysql_select_db($db_database) or die("Could not connect to database (Main connection)");
$query = "SELECT * FROM fietsroutes WHERE provincie='Oost-Vlaanderen' and route='ja' ORDER BY fietsroute ASC";
$result = mysql_query($query)
or die ("Couldn't execute query.");
echo "\n
Home O-Vl.\n
";
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "\n
$titel\n
$gemeente - $kilometers km \n
";
}
?>
RouteYou:
$client = new SoapClient('http://www.routeyou.com/webservice/token/fietsrouteDOTorg.nl?wsdl');
$search->limit = '';
$search->offset = '';
$search->keywords = '';
$search->location = 'Oost-Vlaanderen';
$search->language = '';
$search->min_length = '';
$search->max_length = '';
$search->min_level = '';
$search->max_level = '';
$search->min_score = '3';
$search->max_score = '';
$search->min_time = '';
$search->max_time = '';
$search->type = 'BIKE';
$routes = $client->searchRoutes($search);
usort($routes, create_function('$a,$b', 'return(strcmp($a->title, $b->title));'));
foreach ($routes as $route) {
$afstand=round($route->length/1000);
echo utf8_decode("\n
route_id&midframe >$route->title
\n
");
IF($route->area == "") {
echo "Oost-Vlaanderen - $afstand km\n
";
}
ELSEIF ($route->area != "") {
echo utf8_decode("$route->area - $afstand km\n
");
}
ELSE {
echo"";
}
}
?>