1.后台更新与删除文件admin_news_class.php <?php include_once ('admin_global.php'); $r=$db->Get_user_shell_check($uid, $shell); if(isset($_POST[into_class])){ $db->query("INSERT INTO `news_php100`.`p_newsclass` (`id`, `f_id`, `name`, `keywrod`, `remark`)" . " VALUES (NULL, '$_POST[f_id]', '$_POST[name]', '', '')"); $db->Get_admin_msg("admin_news_class.php","已成功添加分类"); } if(!empty($_Get[del])){ $db->query("DELETE FROM `p_newsclass` WHERE `id` = '$_GET[del]' LIMIT 1;"); $db->Get_admin_msg("admin_news_class.php","删除成功"); } if(!isset($_POST[update_class])){ $db->query("update `p_newsclass` set `name`='$_POST[name]' WHERE `id` = '$_POST[id]' LIMIT 1;"); $db->Get_admin_msg("admin_news_class.php","更新成功"); } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>后台管理</TITLE> <META http-equiv=Content-Type content="text/html; charset=gb2312"> <META content=Alan name=Author><LINK rev=MADE href="mailto:haowubai@hotmail.com"><LINK href="images/private.css" mce_href="images/private.css" type=text/css rel=stylesheet> <META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD> <BODY> <TABLE class=navi cellSpacing=1 align=center border=0> <TBODY> <TR> <TH>后台 >> 新闻分类</TH></TR></TBODY></TABLE><BR> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">添加分类</th> </tr> <form action="" method="post" > <tr> <td colspan="2" align="center" height='30'> <select name="f_id"> <option value="0">添加大类</option> <?php $query=$db->findall("p_newsclass where f_id=0"); while ($row=$db->fetch_array($query)) { $news_class_arr[$row[id]]=$row[name]; echo "<option value=/"$row[id]/">$row[name]</option>"; } ?> </select> <input type="text" name="name" value="" /> <input type="submit" name="into_class" value=" 添加分类 "/> </td> </form> </tr> </table> <br> <table border=0 cellspacing=1 align=center class=form> <tr> <th>系统分类</th> </tr> <?php foreach($news_class_arr as $id=>$val){ ?> <tr> <form action="" method="post"> <td> <input type="hidden" name="id" value="<?php echo $id?>" /> <input type="text" name="name" value="<?php echo $val?>"/> <input type="submit" name="update_class" value="更新"/> <input type="button" value="删除" οnclick="location.href='?del=<?php echo $id?>'"/> </form> <?php $query_fid=$db->findall("p_newsclass where f_id=$id"); while ($row_fid=$db->fetch_array($query_fid)) { ?> <form action="" method="post"> ┗<input type="hidden" name="id" value="<?php echo $row_fid[id]?>" /> <input type="text" name="name" value="<?php echo $row_fid[name]?>"/> <input type="submit" name="update_class" value="更新"/> <input type="button" value="删除" οnclick="location.href='?del=<?php echo $row_fid[id]?>'"/> </form> <?php } ?> </td> </tr> <?php } ?> </table> </BODY></HTML> 2.后台更新文件admin_news_edit.php <?php include_once ('admin_global.php'); $r=$db->Get_user_shell_check($uid, $shell); if(isset($_POST[into_news])){ $db->query("update `p_newsbase` set title='$_POST[title]' where id='$_POST[id]'"); $db->Get_admin_msg("admin_news_add.php","添加成功"); } if(!empty($_GET[id])){ $sql="select * from p_newsbase as a, p-newscontent as b where a.id=b.nid and a.id='$_GET[id]'"; $query=mysql_query($sql); $row_news=mysql_fetch_array($query); } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>后台管理</TITLE> <META http-equiv=Content-Type content="text/html; charset=gb2312"> <META content=Alan name=Author><LINK rev=MADE href="mailto:haowubai@hotmail.com"><LINK href="images/private.css" mce_href="images/private.css" type=text/css rel=stylesheet> <META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD> <BODY> <TABLE class=navi cellSpacing=1 align=center border=0> <TBODY> <TR> <TH>后台 >> 添加新闻</TH></TR></TBODY></TABLE><BR> <table border=0 cellspacing=1 align=center class=form> <tr> <th colspan="2">添加分类</th> </tr> <form action="" method="post" οnsubmit="syncTextarea()" > <tr> <td width=80>新闻分类</td> <td> <select name="cid"> <option value="0">添加大类</option> <?php $query=mysql_query("select * from p_newsclass where f_id=0"); while ($row=mysql_fetch_array($query)){ $selected=$row[id]==$row_news[cid] ? "selected" : NULL; echo "<option value=/"$row[id]/" $selected>$row[name]</option>"; $query_son=mysql_query("select * from p_newsclass wher f_id='$row[id]'"); while ($row_son=mysql_fetch_array($query_son)){ $selected= $row_son[id]==$row_news[cid] ? "selected" : NULL; echo "<option value=/"$row_son[id]/" $selected> $row_son[name]</option>"; } } ?> </select> </td></tr> <tr> <td width=80>新闻标题</td> <td> <input type="text" name="title" size=50 value="<?php echo $row_news[title]?>"> </select> </td> </tr> <tr> <td width=80>新闻作者</td> <td> <input type="text" name="author" size=20 value="<?php echo $row_news[author]?>"> </td> </tr> <tr> <td width=80>新闻关键字</td> <td> <input type="text" name="keywrod" size=80 value="<?php echo $row_news[keywrod]?>"> </td> </tr> <tr> <td width=80>新闻内容</td> <td> <textarea id="edited" name="content" style="width:95%;height:280px;"><?php echo $row_news[content]?></textarea> <script language="javascript" type="text/javascript" src="edit/whizzywig.js"></script> <script type="text/javascript">buttonPath = "edit/images/";makeWhizzyWig("edited", "all");</script> </td> </tr> <tr> <td width=80></td> <td> <input type="submit" name="into_news" style="height:30px;" value="添加新闻"> </td> </tr> </form> </table> <br> </BODY></HTML>