📄 search.php
字号:
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>列车时刻查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="20" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 列车时刻查询结果 (最多显示100条)</span><br>
</td>
</tr>
</table>
<br>
';
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 '
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">车次 </td>
<td nowrap align="center">发车时间 </td>
<td nowrap align="center">到站时间 </td>
<td nowrap align="center">公里数 </td>
<td nowrap align="center">硬座票价 </td>
<td nowrap align="center">操作 </td>
</tr>
';
$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];
$ARRIVE_TIME = substr ($ARRIVE_TIME, 0, 5);
$DEPART_TIME = substr ($DEPART_TIME, 0, 5);
$TOTAL_HOUR = (((24 * $DAY) + substr ($ARRIVE_TIME, 0, 2)) - substr ($DEPART_TIME, 0, 2));
$TOTAL_MINUTE = (substr ($ARRIVE_TIME, 3, 2) - substr ($DEPART_TIME, 3, 2));
if (($TOTAL_MINUTE < 0))
{
$TOTAL_HOUR = ($TOTAL_HOUR - 1);
$TOTAL_MINUTE = (60 + $TOTAL_MINUTE);
}
if (($ARRIVE_TIME == '00:00'))
{
$ARRIVE_TIME = '<--始发站-->';
}
if (($DEPART_TIME == '00:00'))
{
$DEPART_TIME = '<--终点站-->';
}
$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 ($ROW = mysql_fetch_array ($cursor2))
{
$NUMBER_OF_STATION = floor ($ROW[0]);
$FIRST_STATION = $ROW[1];
$END_STATION = $ROW[2];
$TRAIN_KIND_NAME = $ROW[3];
$TRAIN_KIND_NUM = $ROW[4];
}
$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';
break;
}
}
$DISTANCE2 = ($DISTANCE + 100);
$query3 = ((((((('select '.$SEAT).',').$BED).' from price where distance>=').$DISTANCE).' and distance<').$DISTANCE2);
if ((($TRAIN_KIND_NUM != 3) AND ($TRAIN_KIND_NUM != 7)))
{
$cursor3 = exequery ($connection, $query3);
if ($ROW = mysql_fetch_array ($cursor3))
{
$PRICE_SEAT = $ROW[0];
$PRICE_BED = $ROW[1];
}
$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 = '第七天';
break;
}
}
echo '
<tr class="TableData">
<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 '" >';
echo $TRAIN_NAME;
echo '</a></td>
<td nowrap align="center">';
echo $DEPART_TIME;
echo '</td>
<td nowrap align="center">';
echo $DAY_NAME;
echo ' ';
echo $ARRIVE_TIME;
echo '</td>
<td nowrap align="center">';
echo $DISTANCE;
echo '</td>
<td nowrap align="center">';
echo $PRICE_HARDSEAT;
echo '</td>
<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>
</tr>
';
}
}
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))
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -