<?php
include_once("functions/database.php");
$news_id = $_GET["news_id"];
//构造3条SQL语句
$sql_news_update = "update news set clicked=clicked+1 where news_id=$news_id";
$sql_news_detail = "select * from news where news_id=$news_id";
$sql_review_query = "select * from review where news_id=$news_id and state='已审核'";
//执行3条SQL语句
get_connection();
mysql_query($sql_news_update);
$result_news = mysql_query($sql_news_detail);
$result_review = mysql_query($sql_review_query);
//取出结果集中新闻条数
$count_news = mysql_numRows($result_news);
//取出结果集中该新闻"已审核"的评论条数
$count_review = mysql_numRows($result_review);
if($count_news==0){
	echo "该新闻不存在或已被删除！";
	exit;
}
//根据新闻信息中的user_id查询对应的用户信息
$news = mysql_fetch_array($result_news);
$user_id = $news["user_id"];
$sql_user = "select * from usersfornews where user_id=$user_id";
$result_user = mysql_query($sql_user);
$user = mysql_fetch_array($result_user);
//根据新闻信息中的category_id查询对应的新闻类别信息
$category_id = $news["category_id"];
$sql_category = "select * from ccategory where category_id=$category_id";
$result_category = mysql_query($sql_category);
$category = mysql_fetch_array($result_category);
close_connection();
mysql_free_result($result_user);
mysql_free_result($result_category);
mysql_free_result($result_news);
mysql_free_result($result_review);
//关键字加粗斜体显示
$title = $news['title'];
$content = $news['content'];
if(isset($_GET["keyword"])){
	$keyword = $_GET["keyword"];
	$replacement = "<b><i>".$keyword."</b></i>";
	$title = str_replace($keyword,$replacement,$title);
	$content = str_replace($keyword,$replacement,$content);
}
//显示新闻详细信息
?>
<table>
<tr><td width="80">标题：</td><td><?php echo $title;?></td></tr>
<?php
//include("fckeditor/fckeditor.php");//这条代码很重要欧，不然fckeditor编辑器不能正常浏览上传的图片了!
//$oFCKeditor->BasePath = 'fckeditor/';  // 这条代码很重要欧，不然fckeditor编辑器不能正常浏览上传的图片了!
?>
<tr><td width="80">内容：</td><td><?php echo $content;?></td></tr>
<tr><td width="80">附件：</td><td><a href="download.php?attachment=<?php echo urlencode($news['attachment']);?>"><?php echo $news['attachment'];?></a></td></tr>
<tr><td width="80">发布者：</td><td><?php echo $user['name'];?></td></tr>
<tr><td width="80">类别：</td><td><?php echo $category['name'];?></td></tr>
<tr><td width="80">发布时间：</td><td><?php echo $news['publish_time'];?></td></tr>
<tr><td width="80">点击次数：</td><td><?php echo $news['clicked'];?></td></tr>
</table>
<?php
//显示查看评论超链接
if($count_review>0){
	echo "<a href='index.php?url=review_news_list.php&news_id=".$news['news_id']."'>共有".$count_review."条评论</a><br/>";
}else{
	echo "该新闻暂无评论！<br/>";
}
?>
<br/>
<form action="review_save.php" method="post">
添加评论：<textarea name="content" cols="50" rows="5"></textarea><br/>
<input type="hidden" name="news_id" value="<?php echo $news['news_id'];?>">
<input type="submit" value="评论">
</form>
