|
网站管理，文件名：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>
| 
