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>
<?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 οnclick="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 οnclick="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 οnclick="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>