thinkPHP+mysql+ajax实现的仿百度一下即时搜索效果详解

 where("pid = 0")->order("sort desc")->select(); //遍历省份数据，获取二级城市列表 foreach ($cityList as $key => $value) { $countyList[] = $County->where("pid = ".$value[&＃039;id&＃039;])->order("sort desc")->select(); } //如果url传过来省级编号，就保存，否则就默认山东为要显示的省份 if(!empty($_GET[&＃039;cityid&＃039;])){ $cityid = $_GET[&＃039;cityid&＃039;]; }else{ //6号代码山东的城市编号 $cityid = 6; } //查询此省份编号中的所有城市 $countyList = $County->where("pid = ".$cityid)->order("sort desc")->select(); //查询城市中的所有学校 foreach ($countyList as $key => $value) { $countyList[$key][&＃039;school&＃039;] = $School->where("cid = ".$value[&＃039;id&＃039;])->select(); } //给视图层赋值 $this->assign("cityList",$cityList); $this->assign("countyList",$countyList); //显示视图层 $this->display(); } //根据关键字进行查找 public function get_school_by_key(){ $key = $_POST[&＃039;key&＃039;];//获取关键字 if(empty($key)) $this->ajaxReturn(array("flag"=>0,"data"=>array())); //如果关键字为空，就返回空数组 //查询学校 $School = D("School"); $where[&＃039;name&＃039;] = array("like","%".$key."%"); $schoolList = $School->where($where)->limit("6")->select(); if(empty($schoolList)) $this->ajaxReturn(array("flag"=>0,"data"=>array()));//如果数据为空，也返回空数组 $this->ajaxReturn(array("flag"=>1,"data"=>$schoolList));//返回学校列表 } } 

    
 请选择您所在学校 
 
 
 
 
 
  
  
 
{$county.name}
 
{$school.name}

 /* CSS Document */ * { margin:0; padding:0; } body { background:#FBFBFB; width:100%; } ul { list-style:none; } a { text-decoration:none; } .right ul li a:active { color:#FF5C57; } .left ul li a:active { color:#FF5C57; } .right ul li a:hover { color:#FF5C57; } .left ul li a:hover { color:#FF5C57; } .title { background:#C32D32; height:50px; width:100%; line-height:50px; text-align:center; font-family:Arial, Helvetica, sans-serif; font-size:18px; color:#FFF; } .search-w { text-align:center; width:100%; height:50px; } .search { width:95%; height:30px; text-align:center; margin-top:1%; border:#ccc 1px solid; font-size:14px; background: #FFF url(image/s1.png-600) no-repeat 15% 5px; } .list { width:95%; text-align:left; border:#ccc 1px solid; font-size:14px; margin:0 auto; background:#FFF; position:relative; } .list li { height:35px; width:100%; line-height:35px; border-bottom:#DFDFDF 1px solid; } .list li a{color:#939393; width:100%; height:100%; display:block;} .list li a:hover { color:#ff5c57; } .wraper{ width: 100%; height:100%; } .center{ width:95%; height:100%; } .left { margin-top:5px; width:19.9%; background:#FBFBFB; float:left; border-top:#DFDFDF 1px solid; overflow:hidden; } .left ul { width:100%; height:100%; } .left ul li { height:60px; line-height:60px; border-bottom:#F1F1F1 1px solid; text-align:center; border-right:1px solid #C0C0C0; } .left ul li a { color:#939393; font-weight: bold; height:100%; width:100%; display:block; } .right { margin-top:5px; width:80%; background:#FFF; float:left; border-top:#DFDFDF 1px solid; } .right ul li a { padding-left: 5%; color:#939393; height:100%; width:95%; display:block; } .right ul { width:100%; height:100%; } .right ul li { height:45px; line-height:45px; width:100%; text-align:left; border-bottom:#E8E8E8 1px solid; color:#7C7C7C; } .right ul p{ height:45px; line-height:45px; width:100%; text-align:center; border-bottom:#E8E8E8 1px solid; color:#939393; font-weight: bold; font-size: 18px; }