PHP+ACCESS 文章管理程序代码

2019-04-09 18:47:08丽君

$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 style="font-size:14px;font-weight:bold">" . $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"
相关文章 大家在看