?? exa10-2.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">留言內(nèi)容</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="發(fā)布信息" 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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -