1、在控制器页面：
成都创新互联-成都网站建设公司，专注成都做网站、网站制作、网站营销推广，国际域名空间，雅安服务器托管，网站托管、服务器租用有关企业网站制作方案、改版、费用等问题，请联系成都创新互联。
_method);die;
$Name = $_GET['data'];
if(!preg_match("/^[A-Za-z]+$/",$Name)){
echo "输入有误";die;
}
if(__EXT__ == ''){
$type="html";
}else{
$type=__EXT__;
}
switch ($this->_method){
case 'get': // get请求处理代码
if (__EXT__ == 'html'){
$html = $this->sel($Name);
$this->response($html,'html');
//echo "html";
}elseif(__EXT__ == 'xml'){
$xml = $this->sel($Name);
$this->response($xml,'xml');
}elseif(__EXT__ == 'json'){
$json = $this->sel($Name);
$this->response($json,'json');
}
break;
case 'put': // put请求处理代码
break;
case 'post': // post请求处理代码
break;
}
}
public function sel($name){
//print_r($name);die;
$sheng = M('sheng'); //实例化表
$city = M('city');
$xian = M('xian');
if($name=="china"){
$data=$sheng->select();
return $data;
}else{
$s_id =$sheng->getfieldbypyname($name,'id'); //获取查询省id
//print_r($s_id);die;
//判断获取省id是否为空，如果不为空查询获取省的下级的关联id的相关数据
if(!$s_id==""){
$c_id['p_id']=$s_id;
$datas = $city->where($c_id)->select();
//print_r($datas);die;
return $datas;
}else{
$city_id =$city->getfieldbypyname($name,'id'); //获取市id getFieldBy 根据字段查询并返回某个字段的值 例如，getFieldByName
//print_r($city_id);die;
if(!$city_id==""){
$x_id['p_id']=$city_id;
$data1 = $xian->where($x_id)->select();
//print_r($data1);
return $data1;
}else{
$xian_id = $city_id =$xian->getfieldbypyname($name,'id');
//print_r($xian_id);die;
if(!$xian_id==""){
$cx_id['id']=$xian_id;
//print_r($cx_id);die;
$data2 = $xian->where($cx_id)->select();
//print_r($data2);die;
return $data2;
}else{
echo "没有该地区！";
}
}
}
}
}
}2、配置文件：
'配置值' /* 数据库设置 */ 'DB_TYPE' => 'MySQL', // 数据库类型 'DB_HOST' => '127.0.0.1', // 服务器地址 'DB_NAME' => 'news', // 数据库名 'DB_USER' => 'root', // 用户名 'DB_PWD' => '', // 密码 'DB_PORT' => '3306', // 端口 'URL_ROUTER_ON' => true, //开启路由 'URL_ROUTE_RULES'=>array( 'Index/:data' => array('Index/index', 'status=1'), ), ); ?>
