";
echo "路線番号:".$route_data[0]['r_id']."
";
echo "路線名:".$route_data[0]['r_name']."
";
echo "ルート色:".$route_data[0]['r_color']."
";
echo "運休日等:".$route_data[0]['suspension_day']."
";
echo "備考1:".$route_data[0]['remarks']."
";
echo "備考2:".$route_data[0]['remarks2']."
";
echo "備考3:".$route_data[0]['remarks3']."
";
}
/*------------------------------------------*/
/*------------バス停データの抽出------------*/
$con=@mysql_connect("localhost","event","L523GpA");
if(!$con){
unset($con,$data,$r_id,$lat,$lng,$time,$day);
die("DB接続エラー");
}
$select_db=@mysql_select_db("eventdb");
if(!$select_db){
unset($con,$select_db,$r_id,$lat,$lng,$time,$day);
die ("DB選択エラー");
}
@mysql_query("set names utf8");
$sql="select bus_name from nbus_master where r_id=".$r_id." order by busstop_id asc";
$res = mysql_query($sql);
if($_GET['debug']==1){
echo "
バス停に関するデータ
";
}
for($i = 0;$row = mysql_fetch_array($res);$i++){
$bus_name[$i]=$row['bus_name'];
if($_GET['debug']==1){
echo $bus_name[$i]."
";
}
}
$busstop_id=$i;
mysql_free_result($res);
$close=@mysql_close($con);
if(!$close){
unset($con,$select_db,$res,$sql,$row,$close,$r_id,$lat,$lng,$time,$day);
die("DB切断エラー");
}
unset($con,$select_db,$res,$sql,$row,$close);
/*------------------------------------------*/
?>
".$route_data[0]['r_name']."
".$route_data[0]['suspension_day']."
");
print("
");
for($i=0;$i<$busstop_id;$i++){
print("");
}
print("
");
print("".$route_data[0]['remarks']."
".$route_data[0]['remarks2']."
".$route_data[0]['remarks3']."
");
?>
トップページへ[0]