index_ac.php

没用的东西？ 国外php免费程序,相册 留言板 等

<?php
global $news,$archive,$gallery,$page;

if($news>0){
	$sql = "select * from news where nShow=1 order by nCreated desc limit 0,$news";
	$result=$this->db->query($sql);
	unset($news);
	while($row=$this->db->fetch_array($result)){
		$id=$row['ID'];
		$nTitle=$row['nTitle'];
		$nContent=$row['nContent'];
		$nCreated=date('Y-m-d h:i:s',$row['nCreated']);
		$nUpdated=date('Y-m-d h:i:s',$row['nUpdated']);
		$news[]=array($id,$nTitle,$nContent,$nCreated,$nUpdated);
	}
	if(!isset($news)) $news='';
	$this->set('news',$news);
}

if($archive=1){
	$sql = "select nCreated from news where nShow=1 group by from_unixtime(nCreated,'%Y-%M')";
	$result=$this->db->query($sql);
	unset($archive);
	while($row=$this->db->fetch_array($result)){
		$nCreated=date('Y-M',$row['nCreated']);
		$nArchive=date('Ym',$row['nCreated']);
		$archive[]=array($nCreated,$nArchive);
	}
	if(!isset($archive)) $archive='';
	$this->set('archive',$archive);
}

if($gallery>0){
	$sql = "select * from gallery where gShow=1 order by gCreated desc limit 0,$gallery";
	$result=$this->db->query($sql);
	unset($gallery);
	while($row=$this->db->fetch_array($result)){
		$id=$row['ID'];
		$gName=$row['gName'];
		$gImage=$row['gImage'];
		$gCreated=date('Y-m-d h:i:s',$row['gCreated']);
		$gUpdated=date('Y-m-d h:i:s',$row['gUpdated']);
		$gallery[]=array($id,$gName,$gImage,$gCreated,$gUpdated);
	}
	if(!isset($gallery)) $gallery='';
	$this->set('gallery',$gallery);
}

if(isset($page) and is_array($page)){
	$page=join($page,',');
	$result=$this->db->query("select * from page where id in($page)");
	unset($page);
	while($row=$this->db->fetch_array($result)){
		$title=$row['pTitle'];
		$kws=$row['pKeywords'];
		$dsc=$row['pDescription'];
		$cnt=$row['pContent'];
		$cms[]=array($title,$kws,$dsc,$cnt);
	}
	if(isset($cms)) $this->set('cms',$cms);
}
?>