1、在控制器页面:
<?PHP //本类由系统自动生成,仅供测试用途 namespaceHome\Controller; useThink\Controller\RestController; classIndexControllerextendsRestController{ //显示页面 publicfunctionindex(){ //print_r($this->_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; } } publicfunctionsel($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');//获取市idgetFieldBy根据字段查询并返回某个字段的值例如,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、配置文件:
<?PHP returnarray( //'配置项'=>'配置值' /*数据库设置*/ 'DB_TYPE'=>'@R_301_198@',//数据库类型 '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'),),); ?>