最简单实用的php文章系统,自己编辑

最新推荐文章于 2022-08-29 18:10:24 发布

loveifa

最新推荐文章于 2022-08-29 18:10:24 发布

阅读量2.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： php

本文链接：https://blog.youkuaiyun.com/loveifa/article/details/8143590

php 专栏收录该内容

25 篇文章

订阅专栏

本文介绍了一个简单的新闻发布系统的实现方式，包括数据库设计及核心功能的PHP代码。系统支持新闻的增删改查，并集成了FCKeditor富文本编辑器以方便内容编辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE TABLE IF NOT EXISTS `newslist` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `typename` varchar(55) CHARACTER SET utf8 NOT NULL,
  `title` varchar(55) CHARACTER SET utf8 NOT NULL,
  `litpic` varchar(55) CHARACTER SET utf8 NOT NULL,
  `description` varchar(55) CHARACTER SET utf8 NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `time` int(11) NOT NULL,
  UNIQUE KEY `nid` (`nid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

//addnews.php

<?php 
include("../sys/conn.php");
include("../sys/mysql.class.php");

include("head.php"); 
 include("../fckeditor/fckeditor.php");
 
 
if($_POST[submit]){
	if(empty($_GET[nid])){
		$nowtime=date("U");
		$res->fn_insert('newslist','nid,typename,title,litpic,description,content,time',"NULL,'$_POST[typename]','$_POST[title]','$_POST[litpic]','$_POST[description]','$_POST[content]','$nowtime'");
		$res->fn_tiaozhuan('发布成功','am_news.php');
	}else{
		$nowtime=date("U");
		$res->fn_sql("update newslist set `title` = '$_POST[title]',`litpic`='$_POST[litpic]',`description`='$_POST[description]',`content`='$_POST[content]' where nid = '$_GET[nid]'");
		$res->fn_tiaozhuan('发布成功','am_news.php');
	}
	
} 
?>
<h1><?php if(empty($_GET[nid])){echo "添加文章";}else{$news=$res->fn_select("select * from newslist where nid = '$_GET[nid]'");echo "修改文章";}?></h1>
<form action="" method="post">
文章标题:<input type="text" name="title" value="<?=$news[title]?>" /><br />
文章栏目:<select name="typename">
<option value="<?=$news[typename]?>"><?=$news[typename]?></option>
<option value="">====以下是单页栏目====</option>
<option value="平台原理">平台原理</option>
<option value="政策法规">政策法规</option>
<option value="费用">费用</option>
<option value="专家顾问">专家顾问</option>
<option value="媒体报道">媒体报道</option>
<option value="关于我们">关于我们</option>
<option value="关于理财">关于理财</option>
<option value="贷款说明">贷款说明</option>
<option value="">====以下是文章栏目====</option>
<option value="网站公告">网站公告</option>
<option value="百信贷故事">百信贷故事</option>
<option value="使用技巧">使用技巧</option>

</select><br />
缩略图：<input type="text" name="litpic" value="<?=$news[litpic]?>" /><br />
描述：<input type="text" name="description" size="40" value="<?=$news[description]?>" /><br />
文章内容:<br />
<?php
$sbasepath=$_SERVER['PHP_SELF'];
$sbasepath=dirname($sbasepath).'/';
$fck= new FCKeditor('content');
$fck->BsePath = $sbasepath;
$fck->Value = $news[content];
$fck->Width = '700';
$fck->Height = '350';
$fck->Create();
?><br />
<input type="submit" name="submit" value="提交" />	


</form>

//am_news.php

<?php 
include("../sys/conn.php");
include("../sys/mysql.class.php");
include("head.php"); 

 
?>
<style >
td{ background:#CCCCCC}

</style>
<script language="javascript" src="/js/jquery.js"></script>
<script language="javascript">
function zhankai(id){
	$(".my"+id).toggle(200);
}

</script>
<table bgcolor="#FFFFFF" width="600">
<tr bgcolor="#999999">
<td width="100" style="background-color: #999999">栏目名称</td>
<td style="background-color:#999999"></td>
<td width="100" style="background-color:#999999">操作</td>
</tr>


<tr style="background-color:#CCCCCC">
<td>平台原理</td>
<td></td>
<td><a href="addnews.php?nid=4">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>政策法规</td>
<td></td>
<td><a href="addnews.php?nid=5">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>费用</td>
<td></td>
<td><a href="addnews.php?nid=6">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>专家顾问</td>
<td></td>
<td><a href="addnews.php?nid=7">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>媒体报道</td>
<td></td>
<td><a href="addnews.php?nid=8">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>关于我们</td>
<td></td>
<td><a href="addnews.php?nid=10">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>关于理财</td>
<td></td>
<td><a href="addnews.php?nid=11">修改</a></td>
</tr>
<tr style="background-color:#CCCCCC">
<td>贷款说明</td>
<td></td>
<td><a href="addnews.php?nid=12">修改</a></td>
</tr>
 



<tr bgcolor="#CCCCCC">
<td>网站公告</td>
<td><a href="addnews.php">添加新闻</a></td>
<td onclick="zhankai('11');">展开(收起)</td>
</tr>
<?php
$q_news =$res->fn_sql("select * from newslist where typename = '网站公告' order by nid desc");
while($r_news =mysql_fetch_array($q_news)){
?>
<tr  style="display:none" class="my11">
<td style="background-color:#FFFFCC">序号：<?=$r_news[nid]?></td>
<td style="background-color:#FFFFCC"><?=$r_news[title]?></td>
<td style="background-color:#FFFFCC"><a href="addnews.php?nid=<?=$r_news[nid]?>">修改</a> / <a href="/sys/delete.php?table=newslist&field=nid&id=<?=$r_news[nid]?>&url=/admin/am_news.php">删除</a></td>
</tr>
<?
}
?>

<tr bgcolor="#CCCCCC">
<td>百信贷故事</td>
<td><a href="addnews.php">添加新闻</a></td>
<td onclick="zhankai('12');">展开(收起)</td>
</tr>
<?php
$q_news =$res->fn_sql("select * from newslist where typename = '百信贷故事' order by nid desc");
while($r_news =mysql_fetch_array($q_news)){
?>
<tr style="display:none" class="my12">
<td style="background-color:#FFFFCC">序号：<?=$r_news[nid]?></td>
<td style="background-color:#FFFFCC"><?=$r_news[title]?></td>
<td style="background-color:#FFFFCC"><a href="addnews.php?nid=<?=$r_news[nid]?>">修改</a> / <a href="/sys/delete.php?table=newslist&field=nid&id=<?=$r_news[nid]?>&url=/admin/am_news.php">删除</a></td>
</tr>
<?
}
?>

<tr bgcolor="#CCCCCC">
<td>使用技巧</td>
<td><a href="addnews.php">添加新闻</a></td>
<td onclick="zhankai('13');">展开(收起)</td>
</tr>
<?php
$q_news =$res->fn_sql("select * from newslist where typename = '使用技巧' order by nid desc");
while($r_news =mysql_fetch_array($q_news)){
?>
<tr style="display:none" class="my13">
<td style="background-color:#FFFFCC">序号：<?=$r_news[nid]?></td>
<td style="background-color:#FFFFCC"><?=$r_news[title]?></td>
<td style="background-color:#FFFFCC"><a href="addnews.php?nid=<?=$r_news[nid]?>">修改</a> / <a href="/sys/delete.php?table=newslist&field=nid&id=<?=$r_news[nid]?>&url=/admin/am_news.php">删除</a></td>
</tr>
<?
}
?>
</table>