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\">\r\n"
. " <tr bgcolor=\"#F3F3F3\" align=\"center\">\r\n"
. " <td>文章标题</td><td>文章分类<td>文章作者</td><td>发表时间</td><td>浏览次数</td><td>操作</td>\r\n"
. " </tr>\r\n";
while(!$rs->Eof){
@$sql = "Select * From List Where by_cid = " . $rs->Fields->value;
@$crs = $conn->Execute($sql);
@$cid = $crs->Fields->value;
echo " <tr bgcolor=\"#FFFFFF\">\r\n"
. " <td><a href=\"?artid=" . $rs->Fields[0]->value . "\">" . $rs->Fields->value . "</a></td><td>" . $cid . "</td><td>" . $rs->Fields->value . "</td><td>" . $rs->Fields->value . "</td><td>" . $rs->Fields->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>\r\n"
. " </tr>\r\n";
$crs->Close();
$rs->MoveNext();
}
echo "</table>\r\n";
}
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("\r\n", "<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 style=\"width:590px;text-align:left\">\r\n"
. "<form action=\"?admin=list&list=edit&edit=true&id=" . $rs->fields[0]->value . "\" method=\"post\">\r\n"
. "文章标题：<input type=\"text\" name=\"title\" value=\"" . $rs->fields->value . "\" /><br />\r\n"
. "文章作者：<input type=\"text\" name=\"name\" value=\"" . $rs->fields->value . "\" /><br />\r\n"
. "浏览次数：<input type=\"text\" name=\"count\" value=\"" . $rs->fields->value . "\" /><br />\r\n"
. "文章类别：<select name=\"class\" id=\"class\">\r\n";
@$sql = "Select * From List";
@$