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

📄 exa10-2.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>

    <?
		$connect = @mysql_connect("localhost", "root", "");
		mysql_select_db("NoteBook", $connect);
		$query = "select * from NoteBook";
		$result = mysql_query($query);
		$rows = @mysql_num_rows($result);
		$a_row = @mysql_affected_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="删除" 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>
    </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 + -