<?php
	@header("Content-type: text/html; charset=utf-8"); 
	@require_once("../libs/smarty/MySmarty.class.php");
	@require_once("../libs/Mysqlconn.class.php");
@require_once("../libs/fangzhuru.class.php");

	$conn=new Mysqlconn();
	$smarty=new MySmarty();
	$id=$_GET['id'];
	$smarty->assign("id",$id);

	$syssql="select * from system_tab where system_id=1";
	$sysarr=array();
	$sysarr=$conn->doSelect($syssql);
	$smarty->assign("system",$sysarr);

	$clasql="select * from class_tab where class_pid=2 order by class_id desc";
	$claarr=array();
	$claarr=$conn->doSelect($clasql);
	$smarty->assign("class",$claarr);

	$newsql="select * from news_tab where news_cid=".$id." order by news_id desc ";
	$newsarr=array();
	$newsarr=$conn->doSelect($newsql);
	$smarty->assign("news",$newsarr);	

	//将查询结果赋值给一个变量，待前台页面调用
	$countlist=@count($newsarr);
	$pagesize=8;
	$pagenum=@ceil($countlist/$pagesize);
	$smarty->assign("pagenum",$pagenum);


	for($b=0;$b<$pagenum;$b++){
		$nowpage=($b+1);
		$smarty->assign("nowpage",$nowpage);
		$sqlstr=$newsql." limit ".($nowpage-1)*$pagesize.",".$pagesize."";
		$array=array();
		$array=$conn->doSelect($sqlstr);
		$smarty->assign("news",$array);	
	}
	$smarty->display('../VIEW/templates/case.tpl');
	
			
	


?>