php access代码,PHP+ACCESS 文章管理程序代码

心已赠人 2022-11-18 04:38 148阅读 0赞

session\_start();

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

//作者：biyuan

//时间：2006.07

//联系：QQ6010707

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

碧原网络PHP+ACCESS文章管理系统

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;

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

//连接数据库

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

@$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 "| Fields\[2\]->value . "\\">" . $rs->Fields\[1\]->value . " ";

$rs->MoveNext();

echo "| 后台管理\\r\\n";

$rs->Close();

if(@$\_SESSION\["ARTICLEADMIN"\] == "BY\_PHP\_ARTICLE")\{

echo "  
管理选项-> | 分类管理 | 发表文章 | 文章列表 | 退出登陆";

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

//文章列表：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 "

. "

\\r\\n"

. "

文章标题文章作者发表时间浏览次数\\r\\n"

. "

\\r\\n";

while(!$rs->Eof)\{

echo "

\\r\\n"

. "

Fields\[0\]->value . "\\">" . $rs->Fields\[1\]->value . "" . $rs->Fields\[2\]->value . "" . date("Y-m-d H:i:s",$rs->Fields\[3\]->value) . "" . $rs->Fields\[4\]->value . "\\r\\n"

. "

\\r\\n";

$rs->MoveNext();

echo "

\\r\\n";

else \{

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

$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 "

. "

\\r\\n"

. "

" . $rs->Fields\[1\]->value . "\\r\\n"

. "

\\r\\n"

. "

\\r\\n"

. "

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

. "

\\r\\n"

. "

\\r\\n"

. "

" . $body . "\\r\\n"

. "

\\r\\n"

. "

\\r\\n"

. "

【 返 回 】  【 打 印 】  【 关 闭 】\\r\\n"

. "

\\r\\n"

. "

\\r\\n"

. " \\r\\n";

else \{

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

$rs->Close();

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

//后台:分类管理

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

function admin\_class()\{

global $conn;

@$sql = "Select \* From List";

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

echo "

\\r\\n";

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 . "';submit();\\" /> Fields\[0\]->value . "';submit();\\" />  
\\r\\n";

$rs->MoveNext();

echo "类别: 编号:  \\r\\n"

. "

\\r\\n";

//增加一个类别

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

if(@$\_POST\["class\_name"\] == "" || @$\_POST\["class\_cid"\] == "")\{

echo "  
填写不完整!";

echo "";

exit();

else \{

@$sql = "Insert into List(by\_list,by\_cid) Values('" . $\_POST\["class\_name"\] . "' , '" . $\_POST\["class\_cid"\] . "')";

$conn->Execute($sql);

echo "  
添加成功!";

echo "";

//修改一个类别

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

if(@$\_POST\["class\_" . $\_GET\["id"\]\] == "" || @$\_POST\["class\_cid\_" . $\_GET\["id"\]\] == "")\{

echo "  
填写不完整!";

echo "";

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 "";

//删除一个类别

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

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

$conn->Execute($sql);

echo "  
删除成功!";

echo "";

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

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

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

function admin\_insert()\{

global $conn;

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

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

echo "  
填写不完整!";

echo "";

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 "";

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"

. "

\\r\\n";

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

//后台:文章列表

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

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 "

. "

\\r\\n"

. "

文章标题文章分类文章作者发表时间浏览次数操作\\r\\n"

. "

\\r\\n";

while(!$rs->Eof)\{

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

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

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

echo "

\\r\\n"

. "

Fields\[0\]->value . "\\">" . $rs->Fields\[1\]->value . "" . $cid . "" . $rs->Fields\[2\]->value . "" . $rs->Fields\[3\]->value . "" . $rs->Fields\[4\]->value . " Fields\[0\]->value . "\\">编辑 |  Fields\[0\]->value . "\\">删除\\r\\n"

. "

\\r\\n";

$crs->Close();

$rs->MoveNext();

echo "

\\r\\n";

else \{

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

$rs->Close();

//修改文章

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

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

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

echo "  
填写不完整!";

echo "";

exit();

else \{

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

$body = str\_replace("'", "''", $body);

$body = str\_replace("\\r\\n", "  
", $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 "  
修改成功!";

echo "";

else \{

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

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

echo "

\\r\\n"

. "

fields\[0\]->value . "\\" method=\\"post\\">\\r\\n"

. "文章标题：fields\[1\]->value . "\\" />  
\\r\\n"

. "文章作者：fields\[2\]->value . "\\" />  
\\r\\n"

. "浏览次数：fields\[4\]->value . "\\" />  
\\r\\n"

. "文章类别：\\r\\n";

@$sql = "Select \* From List";

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

while(!$crs->Eof)\{

echo "Fields\[2\]->value . "\\">" . $crs->Fields\[1\]->value . "\\r\\n";

$crs->MoveNext();

$crs->close();

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

$body = str\_replace("  
","\\r\\n",$body);

echo "  
\\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 "";

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

//权限验证

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

function admin\_session()\{

if(@$\_SESSION\["ARTICLEADMIN"\] != "BY\_PHP\_ARTICLE")\{

echo "  
请先登陆!";

echo "";

exit();

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

//后台登陆

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

function admin\_login()\{

if(@$\_SESSION\["ARTICLEADMIN"\] == "BY\_PHP\_ARTICLE")\{

echo "";

else\{

echo "

. "

\\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 "";

else \{

echo "  
登陆成功!";

@$\_SESSION\["ARTICLEADMIN"\] = "BY\_PHP\_ARTICLE";

echo "";

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

//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 "";

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 "";

文章分类-> =article\_menu();?>

=page\_load();?>

$conn->Close();

php access代码,PHP+ACCESS 文章管理程序代码

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 PHP 信息采集程序代码 PHP

相关 PHP调用dede文章代码,dede怎么调用全站的最新文章

相关打开php编写第一个程序,第一个php程序(示例代码)

相关 mysql 读取access_PHP读取ACCESS数据到MYSQL的代码

相关 php 执行程序代码,php 异步执行脚本程序代码

相关 php access代码,PHP+ACCESS 文章管理程序代码

相关 php文章管理系统删除界面,php如何实现删除文章

相关 java程序代码_Java程序代码

相关 PHP程序空行注释及代码统计

相关小程序文章样式之代码高亮