gallery_ac.php

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

<?php
global $pageNum,$page;
$cate=g('cate');

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);
}
			
switch($cate){
	case "view":
		$id=g('id');
		if($id){
			$sql = "select * from gallery where gShow=1 and id=$id";
			$result=$this->db->query($sql);
			if($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);
				$this->set('gallery',$gallery);
				$this->run('viewGallery');
			}
			else{
				echo "<script>alert('Picture No. not found.');location.href='gallery.php';</script>";exit;
			}
		}
		else{header('location:gallery.php');exit;}
	break;
	default:
		$page[]=$pageNum;
		if(g('page')){$page[]=intval(g('page'));}else{$page[]=1;}
		$sql="select count(id) as amount from gallery where gShow=1";
		$result=$this->db->query($sql);
		$row=$this->db->fetch_array($result);
		$amount = $row['amount'];
		if($amount){
			if($amount % $page[0]){$page[]=(int)($amount/$page[0])+1;}else{$page[]=$amount/$page[0];}
			$page[]=$amount;
		}
		else{$page[]=0;$page[]=0;}
		
		$sql = "select * from gallery where gShow=1 order by gCreated desc limit ".($page[1]-1)*$page[0].",".$page[0];
		$result=$this->db->query($sql);
		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);
		}
		$this->set('page',$page);
		if(isset($gallery)) $this->set('gallery',$gallery);
		$this->run('gallery');
	break;
}
?>