top
Loading...
一個個人網頁自動化生成系統(6)
網站管理,文件名: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>

北斗有巢氏 有巢氏北斗