📄 search.php
字号:
<?
include_once 'inc/auth.php';
$PAGE_SIZE = 5;
setcookie ('BUS_CITY', $CITY, (time () + 259200000));
echo '
<html>
<head>
<title>公交查询 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function set_page()
{
PAGE_START=(PAGE_NUM.value-1)*';
echo $PAGE_SIZE;
echo '+1;
location="search.php?CITY=';
echo $CITY;
echo '&START=';
echo $START;
echo '&END=';
echo $END;
echo '&LINEID=';
echo $LINEID;
echo '&PAGE_START="+PAGE_START;
}
</script>
</head>
<body class="bodycolor" topmargin="5" >
';
mysql_select_db ('BUS', $connection);
$TABLE = ($CITY.'_LINE');
$START = trim ($START);
$END = trim ($END);
if (($LINEID != ''))
{
$query = (((((''.'SELECT COUNT(*) from ').$TABLE).' where LINEID like \'%').$LINEID).'%\'');
}
else
{
$query = (((((((''.'SELECT COUNT(*) from ').$TABLE).' where PASSBY like \'%').$START).'%\' and PASSBY like \'%').$END).'%\'');
}
$BUS_COUNT = 0;
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$BUS_COUNT = $ROW[0];
}
$PAGE_TOTAL = ($BUS_COUNT / $PAGE_SIZE);
$PAGE_TOTAL = ceil ($PAGE_TOTAL);
if (($BUS_COUNT <= $PAGE_SIZE))
{
$LAST_PAGE_START = 1;
}
else
{
if ((($BUS_COUNT % $PAGE_SIZE) == 0))
{
$LAST_PAGE_START = (($BUS_COUNT - $PAGE_SIZE) + 1);
}
else
{
$LAST_PAGE_START = (($BUS_COUNT - ($BUS_COUNT % $PAGE_SIZE)) + 1);
}
}
if (($PAGE_START == ''))
{
$PAGE_START = 1;
}
if (($BUS_COUNT < $PAGE_START))
{
$PAGE_START = $LAST_PAGE_START;
}
if (($PAGE_START < 1))
{
$PAGE_START = 1;
}
$PAGE_END = (($PAGE_START + $PAGE_SIZE) - 1);
if (($BUS_COUNT < $PAGE_END))
{
$PAGE_END = $BUS_COUNT;
}
$PAGE_NUM = ((($PAGE_START - 1) / $PAGE_SIZE) + 1);
$query1 = str_replace ('COUNT(*)', '*', $query);
$cursor1 = exequery ($connection, $query1);
if (($BUS_COUNT == 0))
{
message ('<br>提示', '没有符合条件的公交线路');
echo '<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
';
exit ();
}
echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 公交线路查询结果 </span><br><br>
</td>
<td valign="bottom">
';
echo '<s';
echo 'pan class="small1">当前为第<b>';
echo $PAGE_START;
echo '</b>至<b>';
echo $PAGE_END;
echo '</b>条 (第';
echo $PAGE_NUM;
echo '页，共';
echo $PAGE_TOTAL;
echo '页，每页最多';
echo $PAGE_SIZE;
echo '条)</small>
</td>
</tr>
</table>
<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>
';
if (($LOGIN_USER_PRIV == 1))
{
echo ' <td nowrap align="center">操作 </td>
';
}
echo ' </tr>
';
$BUS_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor1))
{
++$BUS_COUNT;
if (($BUS_COUNT < $PAGE_START))
{
continue;
}
if (($PAGE_END < $BUS_COUNT))
{
break;
}
$ID = $ROW['id'];
$LINEID1 = $ROW['lineid'];
$PASSBY = $ROW['PassBy'];
$STARTTIME = $ROW['startTime'];
$ENDTIME = $ROW['endTime'];
$BUSTYPE = $ROW['busType'];
if ((($BUS_COUNT % 2) == 1))
{
$TableLine = 'TableLine1';
}
else
{
$TableLine = 'TableLine2';
}
echo ' <tr class="';
echo $TableLine;
echo '">
<td nowrap align="center">';
echo $LINEID1;
echo '</td>
<td nowrap align="center">';
echo $STARTTIME;
echo '</td>
<td nowrap align="center">';
echo $ENDTIME;
echo '</td>
<td align="center" width="550">
';
if ((substr ($PASSBY, -1, 1) == ','))
{
$PASSBY = substr ($PASSBY, 0, -1);
}
$PASSBY = str_replace (',', ' - ', $PASSBY);
$PASSBY = str_replace ($START, (('<font color=\'FF0000\'>'.$START).'</font>'), $PASSBY);
$PASSBY = str_replace ($END, (('<font color=\'FF0000\'>'.$END).'</font>'), $PASSBY);
echo $PASSBY;
echo ' </td>
<td nowrap align="center">';
echo $BUSTYPE;
echo '</td>
';
if (($LOGIN_USER_PRIV == 1))
{
echo ' <td nowrap align="center"><a href="new.php?ID=';
echo $ID;
echo '&CITY=';
echo $CITY;
echo '">编辑</a></td>
';
}
echo ' </tr>
';
}
echo ' <tr class="TableControl">
<td colspan="6" align="right">
<input type="button" value="首页" class="SmallButton" ';
if (($PAGE_START == 1))
{
echo 'disabled';
}
echo ' onclick="location=\'search.php?CITY=';
echo $CITY;
echo '&START=';
echo $START;
echo '&END=';
echo $END;
echo '&LINEID=';
echo $LINEID;
echo '\'">
<input type="button" value="上一页" class="SmallButton" ';
if (($PAGE_START == 1))
{
echo 'disabled';
}
echo ' onclick="location=\'search.php?CITY=';
echo $CITY;
echo '&START=';
echo $START;
echo '&END=';
echo $END;
echo '&LINEID=';
echo $LINEID;
echo '&PAGE_START=';
echo ($PAGE_START - $PAGE_SIZE);
echo '\'">
<input type="button" value="下一页" class="SmallButton" ';
if (($BUS_COUNT <= $PAGE_END))
{
echo 'disabled';
}
echo ' onclick="location=\'search.php?CITY=';
echo $CITY;
echo '&START=';
echo $START;
echo '&END=';
echo $END;
echo '&LINEID=';
echo $LINEID;
echo '&PAGE_START=';
echo ($PAGE_END + 1);
echo '\'">
<input type="button" value="末页" class="SmallButton" ';
if (($BUS_COUNT <= $PAGE_END))
{
echo 'disabled';
}
echo ' onclick="location=\'search.php?CITY=';
echo $CITY;
echo '&START=';
echo $START;
echo '&END=';
echo $END;
echo '&LINEID=';
echo $LINEID;
echo '&PAGE_START=';
echo $LAST_PAGE_START;
echo '\'">
页数
<input type="text" name="PAGE_NUM" value="';
echo $PAGE_NUM;
echo '" class="SmallInput" size="2"> <input type="button" value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -