@$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);
