<?php
include_once("functions/database.php");
include_once("functions/page.php");
include_once("functions/is_login.php");
if (!session_id()){//这里使用session_id()判断是否已经开启了Session
	session_start();
}
//显示文件上传的状态信息
if(isset($_GET["message"])){
	echo $_GET["message"]."<br/>";
}
//鏋勯犳煡璇㈡墍鏈夋柊闂荤殑SQL璇彞
$search_sql = "select * from news order by news_id desc";
//鑻ヨ繘琛屾ā绯婃煡璇紝鍙栧緱妯＄硦鏌ヨ鐨勫叧閿瓧keyword
$keyword = "";
if(isset($_GET["keyword"])){
	$keyword = trim($_GET["keyword"]);
	//鏋勯犳ā绯婃煡璇㈡柊闂荤殑SQL璇彞
	$search_sql = "select * from news where title like '%$keyword%' or content like '%$keyword%' order by news_id desc";
}
//鎻愪緵杩涜妯＄硦鏌ヨ鐨刦orm琛ㄥ崟
?>
<form action="index.php?url=news_list.php" method="get">
璇疯緭鍏ュ叧閿瓧锛<input type="text" name="keyword" value="<?php echo $keyword?>">
<input type="submit" value="鎼滅储">
</form>
<br/>
<table>
<?php
get_connection();
//鍒嗛〉鐨勫疄鐜
$result_news = mysql_query($search_sql);
$total_records = mysql_num_rows($result_news);
$page_size = 3;
if(isset($_GET["page_current"])){
	$page_current = $_GET["page_current"];
}else{
	$page_current=1;
}
$start = ($page_current-1)*$page_size;
$result_sql = "select * from news order by news_id desc limit $start,$page_size";
if(isset($_GET["keyword"])){
	$keyword = $_GET["keyword"];
	//鏋勯犳ā绯婃煡璇㈡柊闂荤殑SQL璇彞
	$result_sql = "select * from news where title like '%$keyword%' or content like '%$keyword%' order by news_id desc limit $start,$page_size";
}
$result_set = mysql_query($result_sql);
close_connection();

if(mysql_num_rows($result_set)==0){
	exit("鏆傛棤璁板綍锛");
}
while($row = mysql_fetch_array($result_set)){
?>
<tr>
<td>
	<a href="index.php?url=news_detail.php&keyword=<?php echo $keyword?>&news_id=<?php echo $row['news_id']?>"><?php echo mb_strcut($row['title'],0,40,"gbk")?></a>
</td>
<?php
if(is_login()){
?>
<td>
	<a href="index.php?url=news_edit.php&news_id=<?php echo $row['news_id']?>">缂栬緫</a>
</td>
<td>
	<a href="index.php?url=news_delete.php&news_id=<?php echo $row['news_id']?>" onclick="return confirm('纭畾鍒犻櫎鍚楋紵');">鍒犻櫎</a>
</td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
<?php
$url = $_SERVER["PHP_SELF"];
page($total_records,$page_size,$page_current,$url,$keyword);
?>
