senddate是我表中的字段,已经是时间戳了 是这样的1232553600请教为什么我下面这样的去搜索,找不到相关文章啊有请高手指教谢谢
<select name="senddate" size=1 class=fstyle>
<option value="">请选择</option>
<option value="<? echo date('Y-m-d',time());?>"><? echo date('Y-m-d',time());?></option>
<option value="<? echo date('Y-m-d',strtotime('-1 day'));?>"><? echo date('Y-m-d',strtotime('-1 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-2 day'));?>"><? echo date('Y-m-d',strtotime('-2 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-3 day'));?>"><? echo date('Y-m-d',strtotime('-3 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-4 day'));?>"><? echo date('Y-m-d',strtotime('-4 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-5 day'));?>"><? echo date('Y-m-d',strtotime('-5 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-6 day'));?>"><? echo date('Y-m-d',strtotime('-6 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-7 day'));?>"><? echo date('Y-m-d',strtotime('-7 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-8 day'));?>"><? echo date('Y-m-d',strtotime('-8 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-9 day'));?>"><? echo date('Y-m-d',strtotime('-9 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-10 day'));?>"><? echo date('Y-m-d',strtotime('-10 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-11 day'));?>"><? echo date('Y-m-d',strtotime('-11 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-12 day'));?>"><? echo date('Y-m-d',strtotime('-12 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-13 day'));?>"><? echo date('Y-m-d',strtotime('-13 day'));?></option>
</select>
<select name="senddate" size=1 class=fstyle>
<option value="">请选择</option>
<option value="<? echo date('Y-m-d',time());?>"><? echo date('Y-m-d',time());?></option>
<option value="<? echo date('Y-m-d',strtotime('-1 day'));?>"><? echo date('Y-m-d',strtotime('-1 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-2 day'));?>"><? echo date('Y-m-d',strtotime('-2 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-3 day'));?>"><? echo date('Y-m-d',strtotime('-3 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-4 day'));?>"><? echo date('Y-m-d',strtotime('-4 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-5 day'));?>"><? echo date('Y-m-d',strtotime('-5 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-6 day'));?>"><? echo date('Y-m-d',strtotime('-6 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-7 day'));?>"><? echo date('Y-m-d',strtotime('-7 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-8 day'));?>"><? echo date('Y-m-d',strtotime('-8 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-9 day'));?>"><? echo date('Y-m-d',strtotime('-9 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-10 day'));?>"><? echo date('Y-m-d',strtotime('-10 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-11 day'));?>"><? echo date('Y-m-d',strtotime('-11 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-12 day'));?>"><? echo date('Y-m-d',strtotime('-12 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-13 day'));?>"><? echo date('Y-m-d',strtotime('-13 day'));?></option>
</select>
<? require("connection.php"); ?>
<? require("tools.php"); ?>
<? //require("checkpass.php"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>按时间搜索全站文章</title>
<? if($addedit_subed!="true"){ //********************** ?>
<script language="JavaScript" src="check.js"></script>
<script LANGUAGE="javascript">
<!--
function add_onsubmit(add) {
//if (!checkvalue(add.title,0,0,1,"标题")) return false;
//if (!checkvalue(add.writer,0,0,1,"发布人")) return false;
}
//-->
</SCRIPT>
<? } //*************************************************?>
<style type="text/css">
<!--
body,td,th {font-size: 12px;}
-->
</style></head>
<body bgcolor="#FFFFFF"><? require("top.inc"); ?>
<form method=GET action=renaiask_list.php name=add LANGUAGE=javascript onSubmit="return add_onsubmit(this)">
<div align=center>
<table width=562 border=0 align="center" cellpadding=0 cellspacing=1>
<tr>
<td>
发布人:
<select name="writer" size=1 class=fstyle>
<option value="">请选择</option>
<option value="admin">admin</option>
</select><select name="senddate" size=1 class=fstyle>
<option value="">请选择</option>
<option value="<? echo date('Y-m-d',time());?>"><? echo date('Y-m-d',time());?></option>
<option value="<? echo date('Y-m-d',strtotime('-1 day'));?>"><? echo date('Y-m-d',strtotime('-1 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-2 day'));?>"><? echo date('Y-m-d',strtotime('-2 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-3 day'));?>"><? echo date('Y-m-d',strtotime('-3 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-4 day'));?>"><? echo date('Y-m-d',strtotime('-4 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-5 day'));?>"><? echo date('Y-m-d',strtotime('-5 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-6 day'));?>"><? echo date('Y-m-d',strtotime('-6 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-7 day'));?>"><? echo date('Y-m-d',strtotime('-7 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-8 day'));?>"><? echo date('Y-m-d',strtotime('-8 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-9 day'));?>"><? echo date('Y-m-d',strtotime('-9 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-10 day'));?>"><? echo date('Y-m-d',strtotime('-10 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-11 day'));?>"><? echo date('Y-m-d',strtotime('-11 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-12 day'));?>"><? echo date('Y-m-d',strtotime('-12 day'));?></option>
<option value="<? echo date('Y-m-d',strtotime('-13 day'));?>"><? echo date('Y-m-d',strtotime('-13 day'));?></option>
</select>
<input type=submit value="提交" name=B1 class=fstyle>
</td>
</tr>
</table>
</div>
</form>
<? require("bottom.inc"); ?>
</body>
</html>
<? require("tools.php"); ?>
<? //require("checkpass.php"); ?>
<?
$search = "";
if($writer<>""){
if($search==""){
$search .= " WHERE ";
}else{
$search .= " AND ";
}
$search .= " writer = '" . $writer . "' ";
}
if($senddate<>""){
if($search==""){
$search .= " WHERE ";
}else{
$search .= " AND ";
}
$search .= " senddate = '" . $senddate . "' ";
}
$table="dede_archives";
$sql="select * from " . $table . $search;
//请参考下面代码排序
//$sql="select * from " . $table . $search ." order by dtime DESC";
//echo $sql;exit();
$result=mysql_query($sql);
$pagesize=25; //每页记录条数
$result_num=mysql_num_rows($result);
if($result_num<=0){
if($search==""){
$word="目前还没有记录!";
}else{
$word="没有查到符合条件的记录!";
}
}else{
$maxpage=ceil($result_num/$pagesize); if(is_long($page) or $page==""){
$page=1;
}else{
$page=(int)($page);
}
if($page<1){
$page=1;
}else if( $page>$maxpage){
$page=$maxpage;
}
mysql_data_seek($result,($page-1)*$pagesize);
$n=1;
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css">
<title></title>
</head>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0">
<? require("top.inc"); ?>
<? if($result_num<=0){ ?>
<center><BR><BR><? print($word); ?></center>
<? }else{ ?>
<table width="598" border="0" cellspacing="2" cellpadding="0" align="center">
<tr>
<td>共搜索到<font color="#FF0000"><? print($result_num); ?></font>条符合条件的信息</td>
</tr>
</table>
<table width="600" border="0" cellspacing="1" cellpadding="0" align="center">
<tr align=center bgcolor=#97D0FB>
<td><b>ID</b></td>
<td><b>标题</b></td>
<td><b>发布人</b></td>
<td><b>发表时间</b></td>
</tr>
<? while($row = mysql_fetch_array($result)){ ?>
<tr bgcolor=#EEF8FD>
<td align=center><a href="renaiask_show.php?id=<? print($row["id"]); ?>"><? print(HtmlOut($row["id"])); ?></a></td>
<td align=center><? print(HtmlOut($row["title"])); ?></td>
<td align=center><? print(HtmlOut($row["writer"])); ?></td>
<td align=center><? echo $senddate=date('Y-m-d H:i:s',(HtmlOut($row["senddate"]))); ?></td>
</tr>
<? $n++;if(!($row = mysql_fetch_array($result)) || $n > $pagesize) break; ?>
<tr bgcolor=#D7EFFB>
<td align=center><a href="renaiask_show.php?id=<? print($row["id"]); ?>"><? print(HtmlOut($row["id"])); ?></a></td>
<td align=center><? print(HtmlOut($row["title"])); ?></td>
<td align=center><? print(HtmlOut($row["writer"])); ?></td>
<td align=center><? echo $senddate=date('Y-m-d H:i:s',(HtmlOut($row["senddate"]))); ?>
</td>
</tr>
<? $n++;if($n > $pagesize) break;} ?>
</table>
<? LastNextPage($maxpage,$page,"width=100% ","<p align=center class=font2>"); ?>
<? } ?>
<? require("bottom.inc"); ?>
</body>
</html>
这两个是有区别的,如果不一样,肯定匹配不出来还有就是注意一下时区问题
<option value="<? echo time();?>"></option>
if($writer<>""){
if($search==""){
$search .= " WHERE ";
}else{
$search .= " AND ";
}
$search .= " writer = '" . $writer . "' ";
}
if($senddate<>""){
if($search==""){
$search .= " WHERE ";
}else{
$search .= " AND ";
}
$search .= " senddate = '" . $senddate . "' ";
-----------------------好像$senddate没获取值?
$send=$_GET["senddate"];
}