網站管理，文件名：guanli.php
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" background="image/b-graingr2.jpg">
<table width="775" border="0">
<tr>
<td width="101" height="463" valign="top">
<p><img src="image/piao.gif" width="103" height="60"></p>
<p><img src="image/a.gif" width="100" height="35"></p>
<p><a href="muban.php"><img src="image/b.gif" width="100" height="35" border="0"></a></p>
<p><img src="image/c.gif" width="100" height="35"></p>
<p><img src="image/d.gif" width="100" height="35"></p>
<p><img src="image/e.gif" width="100" height="35"></p>
<p><img src="image/f.gif" width="100" height="35"></p>
</td>
<td width="663" height="463" valign="top">
<table width="95%" border="0" align="center" height="234">
<tr>
<td height="43">
<div align="center"><b><font color="#480000" size="6">頁面管理</font></b></div>
</td>
</tr>
<tr valign="top">
<td height="267">
<?php
// 程序開始
$db = mysql_connect("localhost", "root");
mysql_select_db("study",$db);
// 判斷是不是修改文件
if ($submit) {
$sql = "UPDATE wenzhang SET timu=$timu,zuozhe=$zuozhe,
laiyuan=$laiyuan,textt=$textt WHERE id=$id";
// 向數據庫發出SQL命令
$result = mysql_query($sql);
// 文章生成
$t = date("Y-m-d h:i:s");
$muoban1 = fopen("muoban1.txt","r");
$muoban2 = fopen("muoban2.txt","r");
$muoban3 = fopen("muoban3.txt","r");
$qita = "<p><table width="75%" border="0" align="center">
<tr>
<td class=p9>
<div align="center">作者：<font color="#306800">$zuozhe</font> 來源：<font color="#306800">$laiyuan</font>
時間：<font color="#336600">$t</font> </div>
</td>
</tr>
</table></p>";
$muoban4=fread($muoban1,1000);
$muoban5=fread($muoban2,1000);
$muoban6=fread($muoban3,1000);
fclose($muoban1);
fclose($muoban2);
fclose($muoban3);
$main="$muoban4 $timu $qita $muoban5 $textt $muoban6";
// 文章生成
$ttt=".html";
$n=$id.$ttt;
$f = fopen($n,"w");
fwrite($f,$main);
fclose($f);
echo "記錄修改成功！<p>";
}
// 我們是否進入編輯修改狀態
if ($id) {
// 我們是在編輯修改狀態，因些選擇一條記錄
$sql = "SELECT * FROM wenzhang WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$timu = $myrow["timu"];
$zuozhe = $myrow["zuozhe"];
$laiyuan = $myrow["laiyuan"];
$textt = $myrow["textt"];
// 顯示id，供用戶編輯修改
$fom1="<form method="post" action="$PATH_INFO">
<input type=hidden name="id" value="$id">
<table width="97%" border="0" align="center">
<tr>
<td width="53">標題：</td>
<td colspan="3">
<input type="text" name="timu" value=" $timu " size="50">
</td>
</tr>
<tr>
<td width="53" height="28">作者：</td>
<td width="154" height="28">
<input type="text" name="zuozhe" value=" $zuozhe " size="20">
</td>
<td width="59" height="28">來源：</td>
<td width="456" height="28">
<input type="text" name="laiyuan" value=" $laiyuan " size="20">
</td>
</tr>
<tr>
<td width="53">正文：</td>
<td colspan="3">
<textarea name="textt" cols="60" rows="10">$textt</textarea>
</td>
</tr>
<tr>
<td width="53"> </td>
<td colspan="3">
<input type="Submit" name="submit" value="輸入信息">
</td>
</tr>
</table>
</form>";
echo $fom1;
}
if (!$id) {
// 如果不是修改狀態，則顯示員工列表
$result = mysql_query("SELECT * FROM wenzhang",$db);
printf("<ul>");
while ($myrow = mysql_fetch_array($result)) {
printf("<li><a href="%s.html">%s</a> n",
$myrow["id"], $myrow["timu"]);
printf("<a href="%s?id=%s">(修改)</a><br></li>", $PATH_INFO, $myrow["id"]);
}
printf("</ul>"); }
// 程序結束
?>
</td>
</tr>
<tr>
<td height="32">
<div align="right"><a href="input.php"><img src="image/add.gif" width="80" height="43" border="0"></a></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
