📄 show.php
字号:
<?php
include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/infofind.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 列车时刻查询结果 (最多显示100条)</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n";
$connection = openconnection( );
mysql_select_db( "TRAIN", $connection );
if ( $TRAIN != "" )
{
$query1 = "select id,fstation,estation,ftime,etime,distance,kind,day from train where train='{$TRAIN}' ";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$CIRCLE_TIMES = 1;
echo "\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">车次 </td>\r\n <td nowrap align=\"center\">发车时间 </td>\r\n <td nowrap align=\"center\">到站时间 </td>\r\n <td nowrap align=\"center\">公里数 </td>\r\n <td nowrap align=\"center\">硬座票价 </td>\r\n <td nowrap align=\"center\">操作 </td>\r\n </tr>\r\n\r\n";
$TRAINID = $ROW[0];
$TRAIN_FSTATION = $ROW[1];
$TRAIN_ESTATION = $ROW[2];
$DEPART_TIME = $ROW[3];
$ARRIVE_TIME = $ROW[4];
$DISTANCE = $ROW[5];
$TRAIN_KIND = $ROW[6];
$DAY = $ROW[7];
$TOTAL_HOUR = 24 * $DAY - ( floor( $DEPART_TIME ) - floor( $ARRIVE_TIME ) );
$TRAIN_FTIME_MINUTE = 100 * ( $DEPART_TIME - floor( $DEPART_TIME ) );
$TRAIN_ETIME_MINUTE = 100 * ( $ARRIVE_TIME - floor( $ARRIVE_TIME ) );
$TOTAL_MINUTE = $TRAIN_ETIME_MINUTE - $TRAIN_FTIME_MINUTE;
if ( $TOTAL_MINUTE < 0 )
{
$TOTAL_HOUR = $TOTAL_HOUR - 1;
$TOTAL_MINUTE = 60 + $TOTAL_MINUTE;
}
$TOTAL_MINUTE = floor( $TOTAL_MINUTE );
$DEPART_TIME = str_replace( ".", ":", $DEPART_TIME );
if ( strlen( strstr( $DEPART_TIME, ":" ) ) == 2 )
{
$DEPART_TIME .= "0";
}
$ARRIVE_TIME = str_replace( ".", ":", $ARRIVE_TIME );
if ( strlen( strstr( $ARRIVE_TIME, ":" ) ) == 2 )
{
$ARRIVE_TIME .= "0";
}
$query2 = "select pass.zhanci,stationa.station,stationb.station,kind.kind,kind.id from pass,kind,train,station stationa,station stationb ";
$query2 .= "where pass.trainid={$TRAINID} and train.id=pass.trainid and kind.id=train.kind and stationa.id=train.fstation and stationb.id=train.estation order by pass.zhanci desc";
$cursor2 = exequery( $connection, $query2 );
if ( odbc_fetch_row( $cursor2 ) )
{
$NUMBER_OF_STATION = floor( odbc_result( $cursor2, 1 ) );
$FIRST_STATION = odbc_result( $cursor2, 2 );
$END_STATION = odbc_result( $cursor2, 3 );
$TRAIN_KIND_NAME = odbc_result( $cursor2, 4 );
$TRAIN_KIND_NUM = odbc_result( $cursor2, 5 );
}
$TRAIN_NAME = strtoupper( $TRAIN )."次"."（".$FIRST_STATION."--".$END_STATION."）".$TRAIN_KIND_NAME."列车";
switch ( $TRAIN_KIND_NUM )
{
case "1" :
$SEAT = "kttkz";
$BED = "kttkw";
break;
case "2" :
$SEAT = "ktpkz";
$BED = "ktpkw";
break;
case "3" :
$SEAT = "";
$BED = "";
break;
case "4" :
$SEAT = "kttkz";
$BED = "kttkw";
break;
case "5" :
$SEAT = "tkz";
$BED = "tkw";
break;
case "6" :
$SEAT = "pkz";
$BED = "pkw";
break;
case "7" :
$SEAT = "";
$BED = "";
break;
case "8" :
$SEAT = "tkz";
$BED = "tkw";
}
$DISTANCE2 = $DISTANCE + 100;
$query3 = "select ".$SEAT.",".$BED." from price where distance>=".$DISTANCE." and distance<".$DISTANCE2;
if ( $TRAIN_KIND_NUM != 3 && $TRAIN_KIND_NUM != 7 )
{
$cursor3 = exequery( $connection, $query3 );
if ( odbc_fetch_row( $cursor3 ) )
{
$PRICE_SEAT = odbc_result( $cursor3, 1 );
$PRICE_BED = odbc_result( $cursor3, 2 );
}
$ARRAY_PRICE_SEAT = explode( ",", $PRICE_SEAT );
$ARRAY_PRICE_BED = explode( ",", $PRICE_BED );
$PRICE_HARDSEAT = $ARRAY_PRICE_SEAT[0];
$PRICE_SOFTSEAT = $ARRAY_PRICE_SEAT[1];
$PRICE_HARDBED_TOP = $ARRAY_PRICE_BED[0];
$PRICE_HARDBED_MIDDLE = $ARRAY_PRICE_BED[1];
$PRICE_HARDBED_BELOW = $ARRAY_PRICE_BED[2];
$PRICE_SOFTBED_TOP = $ARRAY_PRICE_BED[3];
$PRICE_SOFTBED_BELOW = $ARRAY_PRICE_BED[4];
}
else
{
$PRICE_HARDSEAT = "";
$PRICE_SOFTSEAT = "";
$PRICE_HARDBED_TOP = "";
$PRICE_HARDBED_MIDDLE = "";
$PRICE_HARDBED_BELOW = "";
$PRICE_SOFTBED_TOP = "";
$PRICE_SOFTBED_BELOW = "";
}
switch ( $DAY )
{
case "0" :
$DAY_NAME = "当天";
break;
case "1" :
$DAY_NAME = "次日";
break;
case "2" :
$DAY_NAME = "第三天";
break;
case "3" :
$DAY_NAME = "第四天";
break;
case "4" :
$DAY_NAME = "第五天";
break;
case "5" :
$DAY_NAME = "第六天";
break;
case "6" :
$DAY_NAME = "第七天";
}
echo "\r\n<tr class=\"TableData\">\r\n\t<td nowrap align=\"center\">";
echo $TRAIN_NAME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DEPART_TIME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DAY_NAME;
echo " ";
echo $ARRIVE_TIME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DISTANCE;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $PRICE_HARDSEAT;
echo "</td>\r\n\t<td nowrap align=\"center\">\r\n\t <a href=\"detail.php?TRAIN_NAME=";
echo $TRAIN_NAME;
echo "&DEPART_TIME=";
echo $DEPART_TIME;
echo "&ARRIVE_TIME=";
echo $ARRIVE_TIME;
echo "&TOTAL_HOUR=";
echo $TOTAL_HOUR;
echo "&TOTAL_MINUTE=";
echo $TOTAL_MINUTE;
echo "&DISTANCE=";
echo $DISTANCE;
echo "&NUMBER_OF_STATION=";
echo $NUMBER_OF_STATION;
echo "&PRICE_HARDSEAT=";
echo $PRICE_HARDSEAT;
echo "&PRICE_SOFTSEAT=";
echo $PRICE_SOFTSEAT;
echo "&PRICE_HARDBED_TOP=";
echo $PRICE_HARDBED_TOP;
echo "&PRICE_HARDBED_MIDDLE=";
echo $PRICE_HARDBED_MIDDLE;
echo "&PRICE_HARDBED_BELOW=";
echo $PRICE_HARDBED_BELOW;
echo "&PRICE_SOFTBED_TOP=";
echo $PRICE_SOFTBED_TOP;
echo "&PRICE_SOFTBED_BELOW=";
echo $PRICE_SOFTBED_BELOW;
echo "&DAY=";
echo $DAY;
echo "&TRAINID=";
echo $TRAINID;
echo "\" >详情</a>\r\n\t</td>\r\n</tr>\r\n\r\n";
}
}
else
{
$query = "select passa.trainid,passa.day,passb.day,passa.zhanci,passb.zhanci,passa.depart,passb.arrive,passa.distance,passb.distance,stationa.station,stationb.station from pass passa,pass passb,station stationa,station stationb ";
$query .= "where passb.trainid=passa.trainid and passb.zhanci>passa.zhanci and passa.station=stationa.id and passb.station=stationb.id and stationa.station like '%{$START}%' and stationb.station like '%{$END}%'";
$cursor = exequery( $connection, $query );
$CIRCLE_TIMES = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
if ( $CIRCLE_TIMES == 0 )
{
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">车次 </td>\r\n <td nowrap align=\"center\">发车时间 </td>\r\n <td nowrap align=\"center\">到站时间 </td>\r\n <td nowrap align=\"center\">公里数 </td>\r\n <td nowrap align=\"center\">硬座票价 </td>\r\n <td nowrap align=\"center\">操作 </td>\r\n </tr>\r\n";
}
$TRAINID = $ROW[0];
$PASSA_DAY = $ROW[1];
$PASSB_DAY = $ROW[2];
$PASSA_ZHANCI = $ROW[3];
$PASSB_ZHANCI = $ROW[4];
$DEPART_TIME = $ROW[5];
$ARRIVE_TIME = $ROW[6];
$PASSA_DISTANCE = $ROW[7];
$PASSB_DISTANCE = $ROW[8];
$STATIONA_STATION = $ROW[9];
$STATIONB_STATION = $ROW[10];
$DAY = $PASSB_DAY - $PASSA_DAY;
$TOTAL_HOUR = 24 * $DAY - ( floor( $DEPART_TIME ) - floor( $ARRIVE_TIME ) );
$PASSA_DEPART_MINUTE = 100 * ( $DEPART_TIME - floor( $DEPART_TIME ) );
$PASSB_ARRIVE_MINUTE = 100 * ( $ARRIVE_TIME - floor( $ARRIVE_TIME ) );
$TOTAL_MINUTE = $PASSB_ARRIVE_MINUTE - $PASSA_DEPART_MINUTE;
if ( $TOTAL_MINUTE < 0 )
{
$TOTAL_HOUR = $TOTAL_HOUR - 1;
$TOTAL_MINUTE = 60 + $TOTAL_MINUTE;
}
$TOTAL_MINUTE = floor( $TOTAL_MINUTE );
$DEPART_TIME = str_replace( ".", ":", $DEPART_TIME );
if ( strlen( strstr( $DEPART_TIME, ":" ) ) == 2 )
{
$DEPART_TIME .= "0";
}
$ARRIVE_TIME = str_replace( ".", ":", $ARRIVE_TIME );
if ( strlen( strstr( $ARRIVE_TIME, ":" ) ) == 2 )
{
$ARRIVE_TIME .= "0";
}
$NUMBER_OF_STATION = $PASSB_ZHANCI - $PASSA_ZHANCI;
$DISTANCE = $PASSB_DISTANCE - $PASSA_DISTANCE;
$query = "select train.train,train.kind,stationa.station,stationb.station,kind.kind from train,station stationa,station stationb,kind ";
$query .= "where train.id={$TRAINID} and train.kind=kind.id\tand stationa.id=train.fstation and stationb.id=train.estation";
$cursor1 = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$CHECI = $ROW[0];
$TRAIN_KIND_NUM = $ROW[1];
$FIRST_STATION = $ROW[2];
$END_STATION = $ROW[3];
$TRAIN_KIND_NAME = $ROW[4];
}
$TRAIN_NAME = $STATIONA_STATION."到".$STATIONB_STATION."<BR>".$CHECI."次"."（".$FIRST_STATION."--".$END_STATION."）".$TRAIN_KIND_NAME."列车";
switch ( $TRAIN_KIND_NUM )
{
case "1" :
$SEAT = "kttkz";
$BED = "kttkw";
break;
case "2" :
$SEAT = "ktpkz";
$BED = "ktpkw";
break;
case "3" :
$SEAT = "";
$BED = "";
break;
case "4" :
$SEAT = "kttkz";
$BED = "kttkw";
break;
case "5" :
$SEAT = "tkz";
$BED = "tkw";
break;
case "6" :
$SEAT = "pkz";
$BED = "pkw";
break;
case "7" :
$SEAT = "";
$BED = "";
break;
case "8" :
$SEAT = "tkz";
$BED = "tkw";
}
$DISTANCE2 = $DISTANCE + 100;
$query4 = "select ".$SEAT.",".$BED." from price where distance>=".$DISTANCE." and distance<".$DISTANCE2;
if ( $TRAIN_KIND_NUM != 3 && $TRAIN_KIND_NUM != 7 )
{
$cursor4 = exequery( $connection, $query4 );
if ( odbc_fetch_row( $cursor4 ) )
{
$PRICE_SEAT = odbc_result( $cursor4, 1 );
$PRICE_BED = odbc_result( $cursor4, 2 );
}
$ARRAY_PRICE_SEAT = explode( ",", $PRICE_SEAT );
$ARRAY_PRICE_BED = explode( ",", $PRICE_BED );
$PRICE_HARDSEAT = $ARRAY_PRICE_SEAT[0];
$PRICE_SOFTSEAT = $ARRAY_PRICE_SEAT[1];
$PRICE_HARDBED_TOP = $ARRAY_PRICE_BED[0];
$PRICE_HARDBED_MIDDLE = $ARRAY_PRICE_BED[1];
$PRICE_HARDBED_BELOW = $ARRAY_PRICE_BED[2];
$PRICE_SOFTBED_TOP = $ARRAY_PRICE_BED[3];
$PRICE_SOFTBED_BELOW = $ARRAY_PRICE_BED[4];
}
else
{
$PRICE_HARDSEAT = "";
$PRICE_SOFTSEAT = "";
$PRICE_HARDBED_TOP = "";
$PRICE_HARDBED_MIDDLE = "";
$PRICE_HARDBED_BELOW = "";
$PRICE_SOFTBED_TOP = "";
$PRICE_SOFTBED_BELOW = "";
}
switch ( $DAY )
{
case "0" :
$DAY_NAME = "当天";
break;
case "1" :
$DAY_NAME = "次日";
break;
case "2" :
$DAY_NAME = "第三天";
break;
case "3" :
$DAY_NAME = "第四天";
break;
case "4" :
$DAY_NAME = "第五天";
break;
case "5" :
$DAY_NAME = "第六天";
break;
case "6" :
$DAY_NAME = "第七天";
}
echo "\r\n<tr class=\"TableData\">\r\n\t<td nowrap align=\"center\">";
echo $TRAIN_NAME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DEPART_TIME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DAY_NAME;
echo " ";
echo $ARRIVE_TIME;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $DISTANCE;
echo "</td>\r\n\t<td nowrap align=\"center\">";
echo $PRICE_HARDSEAT;
echo "</td>\r\n\t<td nowrap align=\"center\"><a href=\"detail.php?TRAIN_NAME=";
echo $TRAIN_NAME;
echo "&DEPART_TIME=";
echo $DEPART_TIME;
echo "&ARRIVE_TIME=";
echo $ARRIVE_TIME;
echo "&TOTAL_HOUR=";
echo $TOTAL_HOUR;
echo "&TOTAL_MINUTE=";
echo $TOTAL_MINUTE;
echo "&DISTANCE=";
echo $DISTANCE;
echo "&NUMBER_OF_STATION=";
echo $NUMBER_OF_STATION;
echo "&PRICE_HARDSEAT=";
echo $PRICE_HARDSEAT;
echo "&PRICE_SOFTSEAT=";
echo $PRICE_SOFTSEAT;
echo "&PRICE_HARDBED_TOP=";
echo $PRICE_HARDBED_TOP;
echo "&PRICE_HARDBED_MIDDLE=";
echo $PRICE_HARDBED_MIDDLE;
echo "&PRICE_HARDBED_BELOW=";
echo $PRICE_HARDBED_BELOW;
echo "&PRICE_SOFTBED_TOP=";
echo $PRICE_SOFTBED_TOP;
echo "&PRICE_SOFTBED_BELOW=";
echo $PRICE_SOFTBED_BELOW;
echo "&DAY=";
echo $DAY;
echo "&TRAINID=";
echo $TRAINID;
echo "\" >详情 </a></td>\r\n</tr>\r\n";
$CIRCLE_TIMES = $CIRCLE_TIMES + 1;
if ( 100 < $CIRCLE_TIMES )
{
break;
}
}
}
echo "</table>\r\n\r\n";
if ( $CIRCLE_TIMES == 0 )
{
message( "", "没有符合条件的结果" );
}
button_back( );
echo "</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -