一个个人页面自动化生成系统（3）

网站管理，文件名：guanli.php
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<?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="http://edu.chinaz.com/Get/Program/Php/image/add.gif" width="80" height="43" border="0"></a></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

关键词： 一个个人页面自动化生成系统（3）