<?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(!is_login()){
echo "请您登录系统后，再访问该页面！";
	return;
}

//构造查询所有分类的SQL语句
$search_sql = "select * from category order by category_id desc";
//若进行模糊查询，取得模糊查询的关键字keyword
$name = "";
if(isset($_GET["name"])){
	$keyword = trim($_GET["name"]);
	//构造模糊查询的SQL语句
	$search_sql = "select * from category where name like '%$name%'  order by category_id_id desc";
}
//提供进行模糊查询的form表单
?>
<form action="index.php?url=category_search.php" method="post">
<select name="category_id" size="1">
<?php
include_once("functions/database.php");
get_connection();
$result_set = mysql_query("select * from category");
close_connection();
while($row = mysql_fetch_array($result_set)){
?>
	<option   value="<?php echo $row['category_id'];?>"><?php echo $row['name'];?></option>
<?php
}
?>
</select><br/>
<!--请输入关键字：<input type="text" name="keyword" value="<?//php echo $keyword?>">-->
<input type="submit" value="查询">
</form>
<br/>



<?php
include_once("functions/database.php");
include_once("functions/page.php");
if(isset($_GET["id"])){
	$id=$_GET['id'];
}else{
	$id=1;
}

$sql = "select * from category";
get_connection();
//分页的实现
$result_news = mysql_query($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 where category_id= "."'$id'"."order by news_id desc limit $start,$page_size";

$result_set = mysql_query($result_sql);
close_connection();
echo "分类的所有新闻如下：<br/>";
while($row = mysql_fetch_array($result_set)){
	echo "标题：".$row["title"]."<br/>";
	echo "内容 ：".$row["content"]."&nbsp;&nbsp;";
	echo "日期：".$row["publish_time"]."&nbsp;&nbsp;";
	echo "&nbsp;&nbsp;&nbsp;";
	echo "<hr/>";
}
//分页的实现
$url = "index.php?url=category_list.php";
page($total_records,$page_size,$page_current,$url,"");
?>
