新闻发布系统后台(未完待续)

最新推荐文章于 2021-03-29 13:56:53 发布

小昨

最新推荐文章于 2021-03-29 13:56:53 发布

阅读量948

点赞数

本文链接：https://blog.csdn.net/zrzlliuxiao/article/details/8205475

版权

模拟新闻发布系统后台(未完待续...)
包含的php文件:logo index connectmysql admin insert add_news window menu等
logo
<body>
<center>
<h1 style="background-color:#FF0">欢迎使用news后台管理系统</h1>
<a href="index.php" target="_new">前台展示</a>
</center>
</body>
--
index(smarty模板)
<?php
include("connectmysql.php");
include("../libs/Smarty.class.php");
$array_new = array();
$q = "select * from new order by news_date desc limit 5";
$result = mysql_query($q);
while($row = mysql_fetch_assoc($result)){
$array_new[] = $row;
}
$smarty = new Smarty();
$smarty->reInitSmarty("../demo/templates","../demo/templates_c","../demo/configs","../demo/cache");
$smarty->assign("array_new",$array_new);
$smarty->display('index.tpl');
?>
--
connectmysql(连接数据库)
<?php
mysql_connect('localhost','root','');
mysql_select_db('news');
mysql_query("set names utf8");
?>
--
admin (整体布局)
<frameset rows="20%,*" border="none" style="background-color:
#9FF">
<frame src="logo.php" />
    <frameset cols="20%,*" border="none" >
    <frame src="menu.php" name="logo" bordercolor=""/>
        <frame src="window.php" name="win" />
    </frameset>
</frameset>
--
insert (新闻添加)
<?php
include("connectmysql.php");
$q = "insert into new(title,content,news_date,news_cate_id) values('".$_POST["title"]."','".$_POST["content"]."',now(),".$_POST["c_id"].")";
mysql_query($q);
if(mysql_affected_rows()>0) echo "新闻添加成功！";
?>
<hr />
<a href="add_news.php" target="win">返回继续添加新闻</a>
--
add_news (内容添加)
<body>
<form action="insert.php" method="post" target="win">
请输入新闻的title：<input type="text" name="title" />
请选择新闻类型:<select name="c_id"><option value="1">体育</option><option value="2">娱乐</option></select>
<br />
请输入新闻的content：<br />
<textarea cols="60" rows="15" name="content"></textarea>
<input type="submit" value="提交" />
</form>
--
menu(菜单栏)
<body>
<ul>
<li><a href="add_news.php" target="win">添加新闻</a></li>
<li><a href="update_news.php" target="win">修改新闻</a></li>
<li><a href="delete_news.php" target="win">删除新闻</a></li>
</ul>
</body>
--
index.tpl
<body>
<div class="list-div">
<{section name=new loop=$array_new}>
<ul>
<{if $array_new[new].news_cate_id eq 1}>
<li><a href="show_news.php?id=<{$array_new[new].id}>"><{$array_new[new].title}></a></li>
<{/if}>

</ul>
<{/section}>
<a href="">更多...</a>
</div>
<div class="list-div">
<{section name=new loop=$array_new}>
<ul>
<{if $array_new[new].news_cate_id eq 2}>
<li><a href="show_news.php?id=<{$array_new[new].id}>"><{$array_new[new].title}></a></li>
<{/if}>
</ul>
<{/section}>
</div>
</body>