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

📄 liuyan.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 order by ID limit ";
		   if(empty($_GET['start']))
		{
		    $start = 0;
		  
		$query=$query.$start.",".$limit;				
		}
		else
		{
		 $query=$query.$_GET[start].",".$limit;        
		}


		$connect = @mysql_connect("localhost", "root", "");
		mysql_select_db("NoteBook", $connect);	
		$result = mysql_query($query);
		$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" ?>'">
                                <IMG SRC='./images/file_edit.gif' alt="修改" BORDER='0' WIDTH='13' HEIGHT='11'>
		                <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">
      <TR>
        <TD WIDTH="250" ALIGN="LEFT">
        <BR>
        <INPUT TYPE="button" VALUE="发表留言" NAME="newuser" ONCLICK="JavaScript:window.location='CreateNoteBook.htm'"
        STYLE="color: rgb(0,0,255); FONT-FAMILY: 宋体; FONT-SIZE: 9pt"> </td>
      </TR>
<?

if( $start!= 0)
{
$diff=$_GET[start]-$limit;

}
$bbb=$_GET[start]+$limit;

?>
	<a href="liuyan.php?start=<?echo $diff?>">上一页</a>
	<a href="liuyan.php?start=<?echo $bbb?>">下一页</a>
    </DIV>

  <FORM NAME="search" METHOD="POST" ACTION="SearchNoteBook.php">
    <P ALIGN="center">
      留言者：<INPUT TYPE="text" NAME="searchUserName" SIZE="12">
      留言日期：<INPUT TYPE="text" NAME="searchDate" SIZE="12">
      <INPUT TYPE="submit" VALUE="开始查找" NAME="B2">
    </P>
  </FORM>

</BODY>
</HTML>

⌨️ 快捷键说明

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