// 程式開始
$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 = "
作者：$zuozhe 來源：$laiyuan
時間：$t
|
";
$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 "記錄修改成功！";
} // 我們是否進入編輯修改狀態
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="";
echo $fom1;
}
if (!$id) {
// 如果不是修改狀態，則顯示員工列表
$result = mysql_query("SELECT * FROM wenzhang",$db);
printf("
");
while ($myrow = mysql_fetch_array($result)) {
printf("
- %s n",
$myrow["id"], $myrow["timu"]); printf("(修改)
", $PATH_INFO, $myrow["id"]);
}
printf("
"); }
// 程式結束
?>
|
