add.php

BBWPS 宾馆管理系统 php+mysql

<?
/*
[BBWPS!] (C)2006-2010 小蜜蜂版权所有.
This is NOT a freeware, use is subject to license terms
时间：2007年12月
描述：添加城市
*/
require("../../class/template_class.php");
require("../../config.php");
require("../../class/mysql_class.php");
require("../../function/fun.php");
require("../../function/language.php");
require("../../function/checkModuleSession.php");
require("../../function/func_global.php");
$p=new Template("../template");
$DB=new DB($hostname,$username , $password ,$database,true);
$_BBWPSSESSION=isLogin("../../session/");
$action = $_REQUEST["action"];
if($_BBWPSSESSION){
	if($action=="addone"){
		$cname=$_POST['province'];
		if(!$cname){
			MsgError("省份不为空");
		}
		if($cname!=""){
			$query="insert into `".$prefix."city` (cname,csort,cparent) values ('".$cname."',1,-1)";
			$result=$DB->query($query,false);
			fun($language['tjia'],add);
		}
	}
	elseif($action=="addtwo"){
		$cname=$_POST['city'];
		if(!$cname){
			MsgError("城市不能为空");
		}
		if($cname!=""){
			$cparent=$_POST['cp'];
			$query="insert into `".$prefix."city` (cname,csort,cparent) values ('".$cname."',2,'".$cparent."')";
			$result=$DB->query($query,false);
			fun($language['tjia'],add);
		}
	}
	$p->set_file("add_handle","add.html");
	$query="select* from `".$prefix."city` where csort='1'";
	$result=$DB->query($query,1);
	$p->set_block("add_handle","op","r");
	$p->set_var("r","");
	while($row=$DB->fetch_array($result)){
		$p->set_var(array("CID"=> $row['CID'],"cname"=> $row['cname']));
		$p->parse("r","op",true);
	}
	$p->parse("output","add_handle",true);
	$p->p("output");
}