📄 search.php
字号:
<?
include_once("inc/auth.php");
$PAGE_SIZE=5;
setcookie("BUS_CITY", $CITY,time() + 60*60*24*3000);
?>
<html>
<head>
<title>公交查询 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function set_page()
{
PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
location="search.php?CITY=<?=$CITY?>&START=<?=$START?>&END=<?=$END?>&LINEID=<?=$LINEID?>&PAGE_START="+PAGE_START;
}
</script>
</head>
<body class="bodycolor" topmargin="5" >
<?
//-----------先组织SQL语句-----------
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($PAGE_START>$BUS_COUNT)
$PAGE_START=$LAST_PAGE_START;
if($PAGE_START<1)
$PAGE_START=1;
//-- 页尾 --
$PAGE_END=$PAGE_START+$PAGE_SIZE-1;
if($PAGE_END>$BUS_COUNT)
$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>提示","没有符合条件的公交线路");
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';">
</div>
<?
exit;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 公交线路查询结果 </span><br><br>
</td>
<td valign="bottom">
<span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>条 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>条)</small>
</td>
</tr>
</table>
<table class="TableList" width="95%" align="center">
<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)
{
?>
<td nowrap align="center">操作 </td>
<?
}
?>
</tr>
<?
$BUS_COUNT = 0;
while($ROW=mysql_fetch_array($cursor1))
{
$BUS_COUNT++;
if($BUS_COUNT<$PAGE_START)
continue;
else if($BUS_COUNT>$PAGE_END)
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";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center"><?=$LINEID1?></td>
<td nowrap align="center"><?=$STARTTIME?></td>
<td nowrap align="center"><?=$ENDTIME?></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;
?>
</td>
<td nowrap align="center"><?=$BUSTYPE?></td>
<?
if($LOGIN_USER_PRIV==1)
{
?>
<td nowrap align="center"><a href="new.php?ID=<?=$ID?>&CITY=<?=$CITY?>">编辑</a></td>
<?
}
?>
</tr>
<?
} //while($ROW=mysql_fetch_array($cursor1))
?>
<tr class="TableControl">
<td colspan="6" align="right">
<input type="button" value="首页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='search.php?CITY=<?=$CITY?>&START=<?=$START?>&END=<?=$END?>&LINEID=<?=$LINEID?>'">
<input type="button" value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='search.php?CITY=<?=$CITY?>&START=<?=$START?>&END=<?=$END?>&LINEID=<?=$LINEID?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'">
<input type="button" value="下一页" class="SmallButton" <?if($PAGE_END>=$BUS_COUNT)echo "disabled";?> onclick="location='search.php?CITY=<?=$CITY?>&START=<?=$START?>&END=<?=$END?>&LINEID=<?=$LINEID?>&PAGE_START=<?=($PAGE_END+1)?>'">
<input type="button" value="末页" class="SmallButton" <?if($PAGE_END>=$BUS_COUNT)echo "disabled";?> onclick="location='search.php?CITY=<?=$CITY?>&START=<?=$START?>&END=<?=$END?>&LINEID=<?=$LINEID?>&PAGE_START=<?=$LAST_PAGE_START?>'">
页数
<input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" 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 + -