PHP+ACCESS 文章管理程序代码_php教程-查字典教程网

复制代码代码如下:

<?php

session_start();

//==========================

//作者：biyuan

//时间：2006.07

//联系：QQ6010707

//==========================

<html>

<head>

<title>碧原网络PHP+ACCESS文章管理系统</title>

body {

margin:0px;

text-align:center;

font-size:12px;

font-family:verdana;

}

td {

font-size:12px;

height:28px;

padding:4px;

font-family:verdana;

}

A:link,

A:visited,

A:active {

color: #005a17; text-decoration: none;

}

A:hover {

color: #ff5a00; text-decoration: underline;

}

</style>

</head>

<body>

<?php

//==================================

//连接数据库

//==================================

@$conn = new com("ADODB.Connection");

$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("article.mdb"));

//==================================

//文章导航

//==================================

function article_menu(){

global $conn;

@$sql = "Select * From List";

@$rs = $conn->Execute($sql);

while(!$rs->Eof){

echo "|<a href="?classid=" . $rs->Fields[2]->value . "">" . $rs->Fields[1]->value . "</a>";

$rs->MoveNext();

}

echo "|<a href="?admin=login">后台管理</a>rn";

$rs->Close();

if(@$_SESSION["ARTICLEADMIN"] == "BY_PHP_ARTICLE"){

echo "<br />管理选项->|<a href="?admin=class">分类管理</a>|<a href="?admin=insert">发表文章</a>|<a href="?admin=list">文章列表</a>|<a href="?admin=logout">退出登陆</a>";

}

//==================================

//文章列表：article_list(文章分类ID)

//==================================

function article_list($str){

global $conn;

@$sql = "Select id,by_title,by_name,by_time,by_count From Article Where by_class = " . $str . " Order By id desc";

@$rs = $conn->Execute($sql);

if(!$rs->Eof){

echo "<table border="0" cellspacing="1" cellpadding="0" bgcolor="#cccccc">rn"

. " <tr bgcolor="#F3F3F3" align="center">rn"

. " <td>文章标题</td><td>文章作者</td><td>发表时间</td><td>浏览次数</td>rn"

. " </tr>rn";

while(!$rs->Eof){

echo " <tr bgcolor="#FFFFFF">rn"

. " <td><a href="?artid=" . $rs->Fields[0]->value . "">" . $rs->Fields[1]->value . "</a></td><td>" . $rs->Fields[2]->value . "</td><td>" . date("Y-m-d H:i:s",$rs->Fields[3]->value) . "</td><td>" . $rs->Fields[4]->value . "</td>rn"

. " </tr>rn";

$rs->MoveNext();

}

echo "</table>rn";

}

else {

echo "<br />该分类不存在或暂时没有任何文章!";

}

$rs->Close();

}

//==================================

//文章详细：article_look(文章ID)

//==================================

function article_look($str){

global $conn;

@$sql = "Select * From Article Where id = " . $str;

@$rs = $conn->Execute($sql);

@$usql= "Update Article Set by_count = (by_count + 1) Where id = " . $str;

$conn->Execute($usql);

if(!$rs->Eof){

@$body = $rs->Fields[5]->value;

$body = str_replace("[url=file://%22,%22%22,$body/]","",$body[/url]);

echo "<table border="0" width="60%" cellspacing="1" cellpadding="0" bgcolor="#cccccc">rn"

. " <tr bgcolor="#F3F3F3" align="center">rn"

. " <td>" . $rs->Fields[1]->value . "</td>rn"

. " </tr>rn"

. " <tr bgcolor="#F3F3F3" align="center">rn"

. " <td>文章作者:" . $rs->Fields[2]->value . "|发表时间:" . date("Y-m-d H:i:s",$rs->Fields[3]->value) . "|浏览次数:" . $rs->Fields[4]->value . "</td>rn"

. " </tr>rn"

. " <tr bgcolor="#FFFFFF">rn"

. " <td>" . $body . "</td>rn"

. " </tr>rn"

. " <tr bgcolor="#F3F3F3">rn"

. " <td align="right">【 <a href="javascript:history.back();">返回</a> 】【 <a href="javascript:print();">打印</a> 】【 <a href="javascript:close();">关闭</a> 】</td>rn"

. " </tr>rn"

. " </table>rn"

. " <script language="JavaScript">document.title += "--" . $rs->Fields[1]->value . "";</script>rn";

}

else {

echo "<br />该文章不存在或已被管理员删除!";

}

$rs->Close();

}

//==================================

//后台:分类管理

//==================================

function admin_class(){

global $conn;

@$sql = "Select * From List";

@$rs = $conn->Execute($sql);

echo "<form action="" method="post" name="frm">rn";

while(!$rs->Eof){

echo "类别:<input type="text" value="" . $rs->Fields[1]->value . "" name="class_" . $rs->Fields[0]->value . "" />编号:<input type="text" value="" . $rs->Fields[2]->value . "" name="class_cid_" . $rs->Fields[0]->value . "" /><input type="button" value="修改" onclick="frm.action='?admin=class&class=edit&id=" . $rs->Fields[0]->value . "';submit();" /><input type="button" value="删除" onclick="frm.action='?admin=class&class=del&id=" . $rs->Fields[0]->value . "';submit();" /><br />rn";

$rs->MoveNext();

}

echo "类别:<input type="text" name="class_name" />编号:<input type="text" name="class_cid" /><input type="button" value="增加" onclick="frm.action='?admin=class&class=add';submit();" /><input type="button" value="闲置" disabled />rn"

. "</form>rn";

//增加一个类别

if(@$_GET["class"] == "add"){

if(@$_POST["class_name"] == "" || @$_POST["class_cid"] == ""){

echo "<br />填写不完整!";

echo "<script language="JavaScript">setTimeout("history.back();", 2000);</script>";

exit();

}

else {

@$sql = "Insert into List(by_list,by_cid) Values('" . $_POST["class_name"] . "' , '" . $_POST["class_cid"] . "')";

$conn->Execute($sql);

echo "<br />添加成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=class';", 2000);</script>";

}

//修改一个类别

if(@$_GET["class"] == "edit"){

if(@$_POST["class_" . $_GET["id"]] == "" || @$_POST["class_cid_" . $_GET["id"]] == ""){

echo "<br />填写不完整!";

echo "<script language="JavaScript">setTimeout("history.back();", 2000);</script>";

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 "<br />修改成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=class';", 2000);</script>";

}

//删除一个类别

if(@$_GET["class"] == "del"){

@$sql = "Delete From List Where id = " . $_GET["id"];

$conn->Execute($sql);

echo "<br />删除成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=class';", 100);</script>";

}

//==================================

//后台:发表文章(支持HTML)

//==================================

function admin_insert(){

global $conn;

if(@$_GET["innert"] == "add"){

if(@$_POST["title"] == "" || @$_POST["name"] == "" || @$_POST["class"] == "" || @$_POST["body"] == ""){

echo "<br />填写不完整!";

echo "<script language="JavaScript">setTimeout("history.back();", 2000);</script>";

exit();

}

else {

@$body = $_POST["body"];

$body = str_replace("'", "''", $body);

$body = str_replace("rn", "<br />", $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 "<br />添加成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=insert';", 2000);</script>";

}

else {

echo "<div>rn"

. "<form action="?admin=insert&innert=add" method="post">rn"

. "文章标题：<input type="text" name="title" /><br />rn"

. "文章作者：<input type="text" name="name" /><br />rn"

. "文章类别：<select name="class">rn";

@$sql = "Select * From List";

@$rs = $conn->Execute($sql);

while(!$rs->Eof){

echo "<option value="" . $rs->Fields[2]->value . "">" . $rs->Fields[1]->value . "</option>rn";

$rs->MoveNext();

}

echo "</select><br />rn"

. "文章正文：<textarea cols="70" rows="14" name="body"></textarea><br />rn"

. "<center><input type="submit" value="提交" /><input type="reset" value="重置" /></center>rn"

. "</form>rn"

. "</div>rn";

}

//==================================

//后台:文章列表

//==================================

function admin_list(){

global $conn;

@$sql = "Select id,by_title,by_name,by_time,by_count,by_class From Article Order By id desc";

@$rs = $conn->Execute($sql);

if(!$rs->Eof){

echo "<table border="0" cellspacing="1" cellpadding="0" bgcolor="#cccccc">rn"

. " <tr bgcolor="#F3F3F3" align="center">rn"

. " <td>文章标题</td><td>文章分类<td>文章作者</td><td>发表时间</td><td>浏览次数</td><td>操作</td>rn"

. " </tr>rn";

while(!$rs->Eof){

@$sql = "Select * From List Where by_cid = " . $rs->Fields[5]->value;

@$crs = $conn->Execute($sql);

@$cid = $crs->Fields[1]->value;

echo " <tr bgcolor="#FFFFFF">rn"

. " <td><a href="?artid=" . $rs->Fields[0]->value . "">" . $rs->Fields[1]->value . "</a></td><td>" . $cid . "</td><td>" . $rs->Fields[2]->value . "</td><td>" . $rs->Fields[3]->value . "</td><td>" . $rs->Fields[4]->value . "</td><td><a href="?admin=list&list=edit&id=" . $rs->Fields[0]->value . "">编辑</a>|<a href="?admin=list&list=del&id=" . $rs->Fields[0]->value . "">删除</a></td>rn"

. " </tr>rn";

$crs->Close();

$rs->MoveNext();

}

echo "</table>rn";

}

else {

echo "<br />该分类不存在或暂时没有任何文章!";

}

$rs->Close();

//修改文章

if(@$_GET["list"] == "edit"){

if(@$_GET["edit"] == "true"){

if(@$_POST["title"] == "" || @$_POST["name"] == "" || @$_POST["class"] == "" || @$_POST["body"] == ""){

echo "<br />填写不完整!";

echo "<script language="JavaScript">setTimeout("history.back();", 2000);</script>";

exit();

}

else {

@$body = $_POST["body"];

$body = str_replace("'", "''", $body);

$body = str_replace("rn", "<br />", $body);

@$sql = "Update article Set by_title = '" . $_POST["title"] . "' , by_name = '" . $_POST["name"] . "' , by_count = " . $_POST["count"] . " , by_body = '" . $body . "' , by_class = '" . $_POST["class"] . "' Where id = " . $_GET["id"];

$conn->Execute($sql);

echo "<br />修改成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=list';", 2000);</script>";

}

else {

@$sql = "Select * From Article Where id = " . $_GET["id"];

@$rs = $conn->Execute($sql);

echo "<div>rn"

. "<form action="?admin=list&list=edit&edit=true&id=" . $rs->fields[0]->value . "" method="post">rn"

. "文章标题：<input type="text" name="title" value="" . $rs->fields[1]->value . "" /><br />rn"

. "文章作者：<input type="text" name="name" value="" . $rs->fields[2]->value . "" /><br />rn"

. "浏览次数：<input type="text" name="count" value="" . $rs->fields[4]->value . "" /><br />rn"

. "文章类别：<select name="class" id="class">rn";

@$sql = "Select * From List";

@$crs = $conn->Execute($sql);

while(!$crs->Eof){

echo "<option value="" . $crs->Fields[2]->value . "">" . $crs->Fields[1]->value . "</option>rn";

$crs->MoveNext();

}

$crs->close();

@$body = $rs->Fields[5]->value;

$body = str_replace("<br />","rn",$body);

echo "</select><br />rn"

. "<script language="JavaScript">rn"

. "document.getElementById("class").selectedIndex = " . $rs->fields[6]->value . " - 1;rn"

. "</script>rn"

. "文章正文：<textarea cols="70" rows="14" name="body">" . $body . "</textarea><br />rn"

. "<center><input type="submit" value="提交" /><input type="reset" value="重置" /></center>rn"

. "</form>rn"

. "</div>rn";

}

//删除文章

if(@$_GET["list"] == "del"){

@$sql = "Delete From Article Where id = " . $_GET["id"];

$conn->Execute($sql);

echo "<br />删除成功!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=list';", 100);</script>";

}

//==================================

//权限验证

//==================================

function admin_session(){

if(@$_SESSION["ARTICLEADMIN"] != "BY_PHP_ARTICLE"){

echo "<br />请先登陆!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=login';", 2000);</script>";

exit();

}

//==================================

//后台登陆

//==================================

function admin_login(){

if(@$_SESSION["ARTICLEADMIN"] == "BY_PHP_ARTICLE"){

echo "<script language="JavaScript">window.location.href='?admin=admin';</script>";

}

else{

echo "<table border="0" cellspacing="1" cellpadding="0" bgcolor="#cccccc">rn"

. " <tr bgcolor="#F3F3F3" align="center">rn"

. " <td><strong>管理员登陆</strong></td>rn"

. " </tr>rn"

. " <tr bgcolor="#FFFFFF">rn"

. " <form method="post" action="?admin=check">rn"

. " <td><input type="password" name="adminPass" /><input type="submit" value="确定" /></td>rn"

. " </form>rn"

. " </tr>rn"

. "</table>rn";

}

//==================================

//登陆验证

//==================================

function admin_check(){

if(trim($_POST["adminPass"]) != "admin"){

echo "<br />错误的密码!";

echo "<script language="JavaScript">setTimeout("history.back();", 2000);</script>";

}

else {

echo "<br />登陆成功!";

@$_SESSION["ARTICLEADMIN"] = "BY_PHP_ARTICLE";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=admin';", 2000);</script>";

}

//==================================

//URL参数列表

//==================================

function page_load(){

@$classid = $_GET["classid"];

if($classid != ""){

if(!is_numeric($classid)){

echo "<br />错误的参数!";

return false;

}

else {

article_list($classid);

}

@$artid = $_GET["artid"];

if($artid != ""){

if(!is_numeric($artid)){

echo "<br />错误的参数!";

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 "<br />登陆成功!请选择功能菜单进行操作.";

}

if($admin == "logout"){

session_destroy();

echo "<br />已成功退出!";

echo "<script language="JavaScript">setTimeout("window.location.href='?admin=login';", 2000);</script>";

}

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 "<script language="JavaScript">window.location.href='?classid=1';</script>";

}

<div>

</div>

<?=page_load();?>

<?php

$conn->Close();

</body>

</html>