PHP+MYSQL新闻系统开发之admin_news_add.php和admin_news_list.php

来源：互联网发布：开源cms系统免费编辑：程序博客网时间：2024/06/03 09:40

1. 后台添加内容页文件admin_news_add.php 修正版

<?phpinclude_once ('admin_global.php');$r=$db->Get_user_shell_check($uid, $shell);if(isset($_POST[into_news])){     $db->query("INSERT INTO `p_newsbase` (`id`, `cid`, `title`, `author`, `date_time`) " .     "VALUES (NULL, '$_POST[cid]', '$_POST[title]', '$_POST[author]', '".mktime()."')");     $last_id=$db->insert_id();     $db->query("INSERT INTO `p_newscontent` (`nid`, `keyword`, `content`, `remark`) " ."VALUES ($last_id, '$_POST[keywrod]', '$_POST[content]', '')");$db->Get_admin_msg("admin_news_add.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=MADEhref="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" onsubmit="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)) {      echo "<option value=\"$row[id]\">$row[name]</option>";        $query_son=mysql_query("select * from p_newsclass where f_id='$row[id]'");while ($row_son=mysql_fetch_array($query_son)) {    echo "<option value=\"$row_son[id]\">   ┗$row_son[name]</option>";    }}    ?>  </select>    </td></tr>   <tr>   <td width=80>新闻标题</td>  <td>  <input type="text" name="title" size=50>  </select>    </td>    </tr>       <tr>   <td width=80>新闻作者</td>  <td>  <input type="text" name="author" size=20>    </td>    </tr>       <tr>   <td width=80>新闻关键字</td>  <td>  <input type="text" name="keywrod" size=80>    </td>    </tr>       <tr>    <td width=80>新闻内容</td>  <td>  <textarea id="edited" name="content" style="width:95%;height:280px;"></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>

2. PHP后台管理系统内容列表页admin_news_list.php修正版

<?phpinclude_once ('admin_global.php');$r=$db->Get_user_shell_check($uid, $shell);$query=$db->findall("p_newsclass");while ($row=$db->fetch_array($query)){$news_class_arr[$row[id]]==$row[name];}  if(isset($_GET[del])){  mysql_query("DELETE FROM `p_newsbase` WHERE `id` = '$_GET[del]' LIMIT 1;");  mysql_query("DELETE FROM `p_newscontent` WHERE `nid` = '$_GET[del]' LIMIT 1;");  $db->Get_admin_msg("admin_news_list.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" mce_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 width='100'>新闻分类</th><th>新闻标题</th><th width='100'>作者</th><th width='100'>日期</th><th width='100'>操作</th></tr><tr><?php     $result = mysql_query("select id from p_newsbase");     $total = mysql_num_rows($result);     pageft($total,20);     if ($firstcount < 0) $firstcount = 0;     $query = $db->findall("p_newsbase limit  $firstcount, $displaypg");     while ($row = $db->fetch_array($query)){     ?>     <td><?php echo $news_class_arr[$row[cid]]?></td><td><?php echo $row[title]?></td><td><?php echo $row[author]?></td> <td><?php echo date('Y-m-d H:i',$row[date_time])?></td><td><a href="?del=<?php echo $row[id]?>">删除</a>/<a href="admin_news_edit.php?id=<?php echo $row[id]?>">修改</a></td></tr><?php}?><tr><th colspan="5"><?php echo $pagenav;?></th></tr></table><br></BODY></HTML>