
平台论坛博客文库

› 论坛 › 程序设计 › PHP › 青高手修改下我的代码，根据查询条件得到结果自动分页

青高手修改下我的代码，根据查询条件得到结果自动分页 [复制链接]

moshangxie

白手起家

论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-09-19 22:32 |只看该作者 |倒序浏览

每次输入不同的查询条件，得到的结果能够自动分页

我的代码如下：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.STYLE2 {font-size: 24px; color: #000000; font-weight: bold;}
-->
</style></head>
<body>
<div align="center">
<table width="600" height="730" border="0" cellpadding="0" cellspacing="0" background="images/bf.jpg">
<tr bgcolor="#00FFFF">
<td width="4" height="25" bgcolor="#FFFFFF">　</td>
<td width="800" bgcolor="#b0e1fb">　
<hr />
<p align="left">     请输入查询条件：</p>
</td>
<td width="10" bgcolor="#FFFFFF">　</td>
</tr>
<tr>
<td height="600">　</td>
<td align="center" valign="top"> <form method="post" name="form1" id="form1" >
<table width="800" border="1" cellpadding="1" cellspacing="1" style="border-width: 0px" height="52" >
<tr>
<td width="137" height="23" align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
用户：</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium" width="120">
<input type="text" name="accountno" size="16"></td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
MAC：</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium" width="156">
<input type="text" name="mac" size="16"></td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
登录IP：</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
<input type="text" name="ip_address" size="16"></td>
</tr>
<td width="137" height="24" align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
 开始时间：</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium" width="120">
</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
到</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium" width="156">
结束时间：</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium" width="120">
</td>
<td align="center" bgcolor="#b0e1fb" style="border-style: none; border-width: medium">
</td>
</tr>
</table>
<p align="center">                                                                                                                                                                                      
<input type="submit" value="查询" name="B1">       
<input type="reset" value="重置" name="B2"></p>
<table width="800" border="1" cellpadding="1" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#CCCCCC">
<tr>
<td height="31" align="center" bgcolor="#b0e1fb">用户</td>
<td align="center" bgcolor="#b0e1fb"> IP</td>
<td align="center" bgcolor="#b0e1fb">MAC</td>
<td align="center" bgcolor="#b0e1fb">登录时间</td>
<td align="center" bgcolor="#b0e1fb">下线时间</td>
<td align="center" bgcolor="#b0e1fb">在线时长</td>
</tr>
<?php
require("./conn.php");
error_reporting(0);
$conn=mysql_open();
$accountno = $_POST["accountno"];
$ip_address = $_POST["ip_address"];
$mac = $_POST["mac"];
$start_time = $_POST["start_time"];
$stop_time = $_POST["stop_time"];
$query="select *from login_info where accountno=accountno";
if($accountno!=""&&$ip_address==""&&$mac==""&&$start_time==""&&$stop_time=="")
$query.="&&accountno='".$accountno."'ORDER BY start_time" ;
if($ip_address!=""&&$accountno==""&&$mac==""&&$start_time==""&&$stop_time=="")
$query.="&&ip_address='".$ip_address."'";
if($mac!=""&&$accountno==""&&$ip_address==""&&$start_time==""&&$stop_time=="")
$query.="&&mac='".$mac."'";
if($start_time!=""&&$stop_time==""&&$accountno==""&&$ip_address==""&&$mac=="" )
$query.="&&start_time >='".$start_time."' ORDER BY start_time ";
if($stop_time!=""&&$start_time=="" &&$accountno==""&&$ip_address==""&&$mac=="")
$query.="&&stop_time <='".$stop_time."' ORDER BY stop_time ";
if($stop_time==""&&$start_time!=""&&$accountno!=""&&$ip_address==""&&$mac=="")
$query.="&&start_time >='".$start_time."'&&accountno ='".$accountno."' ";
if($stop_time!=""&&$start_time!=""&&$accountno==""&&$ip_address==""&&$mac=="")
$query.="&&start_time >='".$start_time."'&&stop_time <='".$stop_time."'ORDER BY start_time ";
if($stop_time==""&&$start_time!=""&&$ip_address!=""&&$accountno==""&&$mac=="")
$query.="&&start_time >='".$start_time."'&&ip_address='".$ip_address."' ORDER BY start_time ";
if($stop_time!=""&&$start_time!=""&&$ip_address!=""&&$accountno==""&&$mac=="")
$query.="&&start_time >='".$start_time."'&&stop_time <='".$stop_time."'&&ip_address='".$ip_address."' ORDER BY start_time ";
if($stop_time!=""&&$start_time!=""&&$ip_address==""&&$accountno==""&&$mac!="")
$query.="&&start_time >='".$start_time."'&&stop_time <='".$stop_time."'&&mac='".$mac."' ORDER BY start_time ";
if($stop_time!=""&&$start_time!=""&&$ip_address==""&&$accountno!=""&&$mac=="")
$query.="&&start_time >='".$start_time."'&&stop_time <='".$stop_time."'&&accountno ='".$accountno."' ORDER BY start_time ";
// echo $query;
genpage($query,40);
$result=mysql_query($query);
$num=mysql_num_rows($result);
if($num>=1){
while($myrow=mysql_fetch_array($result)){
?>
<tr>
<td width="60" bgcolor="#FFFFFF"><?php echo $myrow[accountno];?></td>
<td width="60" align="center" bgcolor="#FFFFFF"><?php echo $myrow[ip_address];?></td>
<td width="60" align="center" bgcolor="#FFFFFF"><?php echo $myrow[mac];?></td>
<td width="140" align="center" bgcolor="#FFFFFF"><?php echo $myrow[start_time];?></td>
<td width="140" align="center" bgcolor="#FFFFFF"><?php echo $myrow[stop_time];?></td>
<td width="60" align="center" bgcolor="#FFFFFF"><?php echo $myrow[length];?></td>
</tr>
<?php
}
mysql_close($conn);
}
else
{
echo "<script LANGUAGE='javascript'>alert('对不起！没有符合您要求的用户信息，请重新查询！');top.location=index.php;</script>";
}
?>
</table>
</form></td>
<td>　</td>
</tr>
</table>
</div>
</body>
</html>

复制代码

评分

参与人数 1	可用积分 -1	收起理由
xinglu1983	-1	作业帖 or 问题意图不明，请认真思考你的问 ...

查看全部评分

文库|博客

返回列表

Chinaunix › 论坛 › 程序设计 › PHP › 青高手修改下我的代码，根据查询条件得到结果自动分页

青高手修改下我的代码，根据查询条件得到结果自动分页 [复制链接]

评分

浏览过的版块