PHP ACCESS記事管理プログラムコード

コードをコピー コードは次のとおりです:

session_start(); //======================== //著者: biyuan //時間: 2006.07 //連絡先: QQ6010707 //======================= = === ?> Biyuan Network PHP ACCESS 記事管理システム equiv="content-type" content="text/html; charset=gb2312" /> margin:0px; >text-align:center; font-family:verdana; td { font-size:12px; padding:4px; font-family:verdana; A:link, A:visited, A:active { color: #005a17; -装飾: なし; } 色: #ff5a00; テキスト装飾: } //============================= = ==== //データベースに接続します //=============================== ===== @$conn = new com("ADODB.Connection"); $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= . realpath("article.mdb")); //================================= = //記事ナビゲーション //================================== functionarticle_menu(){ global $conn; @$sql = "リストから選択"; @$rs = $conn->while(! $rs->Eof) { echo "| Fields[2]->value . "">"フィールド[1]-> 値 . " $rs->MoveNext(); echo "| バックエンド管理 rn"; $rs->Close(); if(@$_SESSION["ARTICLEADMIN"] == "BY_PHP_ARTICLE"){ echo " 管理オプション - カテゴリ管理 記事リスト ログアウト "; } } //================================== //記事リスト:article_list (記事カテゴリID) //================================== 関数article_list($str) { global $conn; @$sql = "記事から id,by_title,by_time,by_count を選択します。 by_class = " . $str . " ID desc で並べ替えます"; $conn ->Execute($sql); if(!$rs->Eof){ echo " rn" . " rn" . " 記事タイトル 記事著者 公開時刻 閲覧数 rn" . " rn"; while(!$ rs ->Eof){ echo " rn" . " フィールド[0]->値 . ""> . $rs->フィールド[1]-> 値 . " " . $rs->フィールド[2]->値 . "

" .date("Y-m-d H:i:s",$rs->フィールド[3]->値) . /td>gt; " . $rs->Fields[4]->value . " rn" . " rn"; $rs - >MoveNext(); } echo " rn"; else { echo " このカテゴリは存在しないか、一時的に記事がありません!"; } $rs->Close(); } //================================== //文章详细：article_look(文章ID) //================================== 関数article_look($str) { グローバル $conn; @$sql = "ID = " の記事から * を選択します。 $str; @$rs = $conn->Execute($sql); @$usql= "記事セットを更新 by_count = (by_count 1) Where id = " . $str; $conn->実行($usql); if(!$rs->Eof){ @$body = $rs->Fields[5]->value; $body = str_replace("[url=file://","",$body/]\","",$body[/url]); echo " rn" " rn " . " " . $rs->Fields[1]->value . " rn" . " rn" . " rn" . " rs->フィールド[2]->値 " | 公開時刻:" . date("Y-m-d H:i:s",$rs->Fields[3]->value) . " | 浏览次数:" . $rs->Fields[4]->value . " rn" . " rn" . " rn" ." rn" " rn" . " 【 返し 】 【 打印 】 【 关闭 ] rn" . " rn" . " rn" . " document.title = "--" 。 $rs->Fields[1]->value 。 ""; rn"; } else { echo " 该文章不存在または已被管理员删除!"; } $rs->Close(); } //============================== === //後台:分类管理 //================================= = function admin_class(){ global $conn; @$sql = "リストから * を選択" @$rs = $conn->Execute($sql); >echo " rn"; while(!$rs->Eof){ echo "类别: Fields[1]->value 。 "" name="class_" 。 $rs->Fields[0]->value 。 "" /> 编号: Fields[2]->value 。 "" name="class_cid_" 。 $rs->Fields[0]->value 。 "" /> Fields[0]->value 。 "';提出する（）;" /> Fields[0]->value 。 "';提出する（）;" /> rn"; $rs->MoveNext(); } echo "类别: rn" . " rn"; //增加一个类别 if(@$_GET[" class"] == "add"){ if(@$_POST["class_name"] == "" || @$_POST["class_cid"] == ""){ echo " 充填写不完整!"; echo " setTimeout("history.back();", 2000); "; exit (); } else { @$sql = "List(by_list,by_cid) Values('" . $_POST["class_name"] . "' , '" . $_POST[ "class_cid"] . "')"; $conn->Execute($sql); echo " 追加成功!"; "JavaScript">setTimeout("window.location.href='?admin=class';", 2000); "; } } //修改一个类别 if(@$_GET["class"] == "編集"){ if(@$_POST["class_" . $_GET["id"]] == "" || @$_POST[ "class_cid_" . $_GET["id"]] == ""){ echo " 充填写不完整!" echo " setTimeout("history.back();", 2000); "; exit(); } else { @$sql = "Update List Set by_list = '" . $_POST["class_" . $_GET["id"]] . "' , by_cid = '" . $_POST["class_cid_" . $_GET["id"]] . "' Where id = " . $_GET["id"]; $conn->Execute($sql); echo " 修改成功!"; echo " setTimeout(\"window.location.href='?admin=class';\", 2000); "; } } //删除一个类别 if(@$_GET["class"] == "del"){ @$sql = "Delete From List Where id = " . $_GET["id"]; $conn->Execute($sql); echo " 删除成功!"; echo " setTimeout(\"window.location.href='?admin=class';\", 100); "; } } //================================== //后台:发表文章(支持HTML) //================================== function admin_insert(){ global $conn; if(@$_GET["innert"] == "add"){ if(@$_POST["title"] == "" || @$_POST["name"] == "" || @$_POST["class"] == "" || @$_POST["body"] == ""){ echo " 填写不完整!"; echo " setTimeout(\"history.back();\", 2000); "; exit(); } else { @$body = $_POST["body"]; $body = str_replace("'", "''", $body); $body = str_replace("\r\n", " ", $body); @$sql = "Insert into article(by_title,by_name,by_time,by_count,by_body,by_class) Values('" . $_POST["title"] . "' , '" . $_POST["name"] . "' , #" . date("Y-m-d G:i:s") . "# , 0 , '" . $body . "' , '" . $_POST["class"] . "')"; $conn->Execute($sql); echo " 添加成功!"; echo " setTimeout(\"window.location.href='?admin=insert';\", 2000); "; } } else { echo " \r\n" . " \r\n" . "文章标题： \r\n" . "文章作者： \r\n" . "文章类别： \r\n"; @$sql = "Select * From List"; @$rs = $conn->Execute($sql); while(!$rs->Eof){ echo " Fields[2]->value . "\">" . $rs->Fields[1]->value . " \r\n"; $rs->MoveNext(); } echo " \r\n" . "文章正文： \r\n" . " \r\n" . " \r\n" . " rn"; } } //================================= = = //バックエンド: 記事リスト //================================== == function admin_list(){ global $conn; @$sql = "ID 説明による記事順序から ID、タイトル別、名前別、時間別、カウント別、クラス別を選択します"; rs = $ conn->Execute($sql); if(!$rs->Eof){ echo " rn" . " rn" . " 記事タイトル 記事カテゴリ 記事著者 公開時間 閲覧数 操作 rn" . " rn"; while(!$rs->Eof){ @$sql = "Select * From List Where by_cid = " . $rs->Fields[5] -&gt ;値; @$crs = $conn->実行($sql); @$cid = $crs->フィールド[1]->値; bgcolor="#FFFFFF">rn" . " Fields[0]->value . $rs->フィールド[1]->値 . " " ;フィールド[2]->値 .$rs->フィールド[3]->$rs ->フィールド[4]->値 . " フィールド[0]-&gt ;値. "">編集 削除 rn" . " rn"; $crs->Close(); $rs->MoveNext(); } echo " rn"; } else { echo " このカテゴリは存在しないか、現在記事がありません!"; >$rs->Close(); //記事を変更 if(@$_GET["list"] == "edit"){ if(@$_GET["edit "] == "true"){ if(@$_POST["title"] == "" || @$_POST["name"] == "" || @$_POST["class"] == "" || @$_POST["body"] == ""){ echo " 不完全!"; echo " setTimeout( "history.back();", 2000); "; exit(); } else { @$body = $_POST[" body"]; $body = str_replace("'", "''", $body); $body = str_replace("rn", " ", $body); $sql = "記事を更新 by_title = '" . $_POST["title"] . "' , by_name = '" . $_POST[ "count" . . " , by_body = '" . $body = '" . $_POST["id"] ; Execute($sql); echo " 変更が成功しました!"; echo " setTimeout("window.location.href= '?admin= list';", 2000); "; } } else { @$sql = "Select * From Article Where id = " . "]; @$rs = $conn->Execute($sql); echo " rn" 。 " fields[0]->value . "" method="post">rn" "記事のタイトル: fields[1]->value . "" /> rn" 。 "記事著者: fields[2]->value . "" /> . "閲覧数: fields[4]->value . "" /> . "記事カテゴリ: rn"; @$sql = "リストから * を選択"; @ $crs = $conn->Execute($sql); while(!$crs->Eof){ echo " Fields[2] ->値 . ""> . $crs->Fields[1]->value . " rn"; $crs->MoveNext(); } $crs->close(); @$body = $rs->Fields[5]->value; $body = str_replace(" ","\r\n",$body); echo " \r\n" . " \r\n" . "document.getElementById(\"class\").selectedIndex = " . $rs->fields[6]->value . " - 1;\r\n" . " \r\n" . "文章正文： " . $body . " \r\n" . " \r\n" . " \r\n" . " \r\n"; } } //删除文章 if(@$_GET["list"] == "del"){ @$sql = "Delete From Article Where id = " . $_GET["id"]; $conn->Execute($sql); echo " 删除成功!"; echo " setTimeout(\"window.location.href='?admin=list';\", 100); "; } } //================================== //权限验证 //================================== function admin_session(){ if(@$_SESSION["ARTICLEADMIN"] != "BY_PHP_ARTICLE"){ echo " 请先登陆!"; echo " setTimeout(\"window.location.href='?admin=login';\", 2000); "; exit(); } } //================================== //后台登陆 //================================== function admin_login(){ if(@$_SESSION["ARTICLEADMIN"] == "BY_PHP_ARTICLE"){ echo " window.location.href='?admin=admin'; "; } else{ echo " \r\n" . " \r\n" . " 管理员登陆 \r\n" . " \r\n" . " \r\n" . " \r\n" . " \r\n" . " \r\n" . " \r\n" . " \r\n"; } } //================================== //登陆验证 //================================== function admin_check(){ if(trim($_POST["adminPass"]) != "admin"){ echo " 错误的密码!"; echo " setTimeout(\"history.back();\", 2000); "; } else { echo " 登陆成功!"; @$_SESSION["ARTICLEADMIN"] = "BY_PHP_ARTICLE"; echo " setTimeout(\"window.location.href='?admin=admin';\", 2000); "; } } //================================== //URL参数列表 //================================== function page_load(){ @$classid = $_GET["classid"]; if($classid != ""){ if(!is_numeric($classid)){ echo " 错误的参数!"; return false; } else { article_list($classid); } } @$artid = $_GET["artid"]; if($artid != ""){ if(!is_numeric($artid)){ echo " 错误的参数!"; return false; } else { article_look($artid); } } @$admin = $_GET["admin"]; if($admin == "login"){ admin_login(); } if($admin == "check"){ admin_check(); } if($admin == "admin"){ admin_session(); echo " 登陆成功!请选择功能菜单进行操作."; } if($admin == "logout"){ session_destroy(); echo " 已成功退出!"; echo " setTimeout(\"window.location.href='?admin=login';\", 2000); "; } if($admin == "class"){ admin_session(); admin_class(); } if($admin == "insert"){ admin_session(); admin_insert(); } if($admin == "list"){ admin_session(); admin_list(); } if($classid == "" && $artid == "" && $admin == ""){ echo " window.location.href='?classid=1'; "; } } ?>

文章分类-> $conn->Close(); ?>