⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 searchnotebook.php

📁 很好用的PHP留言本
💻 PHP
字号:
🔍 
<HTML>
<HEAD>
	<STYLE>
	   A {TEXT-DECORATION: none; TEXT-TRANSFORM: none}
	   A:hover {COLOR: red; TEXT-DECORATION: underline}
	</STYLE>
	<TITLE>查询结果</TITLE>
</HEAD>

<BODY BACKGROUND="./images/backgr8.gif">

  <P ALIGN="center">
  <BR>
    <FONT FACE="黑体" SIZE="6">查询结果</FONT>
  <BR> </P>

    <DIV ALIGN="center">
    <CENTER>
      <TABLE BORDER="1" WIDTH="800" STYLE="FONT-FAMILY:宋体; FONT-SIZE:9PT">
        <TR>
          <TH WIDTH="60" ALIGN="CENTER">号码 </TH>
          <TH WIDTH="100" ALIGN="CENTER">用户名</TH>
          <TH WIDTH="120" ALIGN="CENTER">留言时间</TH>
          <TH WIDTH="420" ALIGN="CENTER">留言内容</TH>
          <TH WIDTH="100" ALIGN="CENTER">操作</TH>
        </TR>
      </TABLE>
    </CENTER>
    </DIV>

    <?
        
                   $limit=5;
                   $query="select * from NoteBook where UserName='".$_POST[searchUserName]."' order by ID limit ";
 		  $query_date="select * from NoteBook where Date='".$_POST[searchDate]."' order by ID limit ";
	          $query_bind="select * from NoteBook where UserName='".$_POST[searchUserName]."'  and Date='".$_POST[searchDate]."' order by ID limit ";
		  if(empty($Start))
		{
		   $Start = 0;		  
		   $query=$query.$Start.",".$limit;				
                   $query_date=$query_date.$Start.",".$limit;
		   $query_bind=$query_bind.$Start.",".$limit;
		}
		else
		{
		 $query=$query.$_GET[Start].",".$limit;        
		 $query_date=$query_date.$GET[Start].",".$limit;
		 $query_bind=$query_bind.$GET[Start].",".$limit;
		}
		$connect = @mysql_connect("localhost", "root", "");
		mysql_select_db("NoteBook", $connect);
	
		if($_POST[searchUserName]!=NULL&&$_POST[searchDate]!=NULL)
		{
		$result =@mysql_query($query_bind);
                }

                elseif($_POST[searchDate]!=NULL)
		{
		 $result=@mysql_query($query_date);

                }
		elseif($_POST[searchUserName]!=NULL)
                {			
		$result=@mysql_query($query);

		}
		

		
		else
		{
			echo "您没有输入任何查询信息";
                }

		$rows = @mysql_num_rows($result);		

		for($i=0; $i<$rows; $i++)
		{
			@mysql_data_seek($result, $i);
			$data = @mysql_fetch_array($result);
			$id = $data[ID];
			$name = $data[UserName];
			$date = $data[Date];
			$content = $data[Content];

    ?>

		    <DIV ALIGN="center">
		    <CENTER>
		      <TABLE BORDER="0" WIDTH="800" STYLE="FONT-FAMILY:宋体; FONT-SIZE:9PT">
		        <TR>
		            <TD WIDTH="60" ALIGN="CENTER"> <?echo "$id";?> </TD>
		            <TD WIDTH="100" ALIGN="CENTER"> <?echo "$name";?> </TD>
		            <TD WIDTH="120" ALIGN="CENTER"> <?echo "$date";?> </TD>
		            <TD WIDTH="420" ALIGN="CENTER"> <?echo "$content";?> </TD>
		            <TD WIDTH="100" ALIGN="CENTER">
		                <A ONCLICK="JavaScript:window.location='EditNoteBook.php?id=<? echo "$id" ?>'">123</a>
                <A ONCLICK="JavaScript:window.location='DeleteNoteBook.php?id=<? echo "$id" ?>'">
		                <IMG SRC='./images/file_delete.gif' alt="delete" BORDER='0' WIDTH='13' HEIGHT='11'>
		            </TD>
		        </TR>
		      </TABLE>
		    </CENTER>
		    </DIV>

    <?
		}
		mysql_close($connect);
    ?>

    <DIV ALIGN="left">
<?
if($Start!=0)
{
$diff=$Start-$limit;
}
$sum=$Start+$limit;
?>
        <a href = "SearchNoteBook.php?Start=<?echo $diff?>">上一页</a>
	<a href = "SearchNoteBook.php?Start=<?echo $sum?>">下一页</a>
    </DIV>
<br><br>
      <div align=center><a href = "liuyan.php">回到主目录</a></div>

</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -