function search($familyOrShop){ if(isset($_POST['familyOrShop'])&& $_POST['familyOrShop'] !=null){ $sql="select A.*,B.name as proName,C.name as cityName,D.name as areaName from {$this->model->pre}help A LEFT JOIN province B ON A.province=B.code LEFT JOIN city C ON A.city=c.code LEFT JOIN area D ON A.area=D.code where familyOrShop Like '%".$familyOrShop."%'"; } $result=mysql_query($sql); 这是M里面的查询方法 //模糊查询 function search(){ $familyOrShop=$_POST['familyOrShop']; model('help')->search($familyOrShop); } 这是控制器调用了那个方法<div class="page_menu"> 搜索: <input name="familyOrShop" id="familyOrShop" value="<?php echo $_GET[familyOrShop] ?>" /> <input type="button" class="button_small" onclick= ""value="搜索" />
if(isset($_POST['familyOrShop'])&& $_POST['familyOrShop'] !=null){
$sql="select A.*,B.name as proName,C.name as cityName,D.name as areaName from {$this->model->pre}help A LEFT JOIN province B ON A.province=B.code LEFT JOIN city C ON A.city=c.code LEFT JOIN area D ON A.area=D.code where familyOrShop Like '%".$familyOrShop."%'";
}
$result=mysql_query($sql);
这是M里面的查询方法
//模糊查询
function search(){
$familyOrShop=$_POST['familyOrShop'];
model('help')->search($familyOrShop);
}
这是控制器调用了那个方法<div class="page_menu">
搜索:
<input name="familyOrShop" id="familyOrShop" value="<?php echo $_GET[familyOrShop] ?>" />
<input type="button" class="button_small" onclick= ""value="搜索" />
location.href = 'http://localhost/Index/do'; //index是控制器 do是方法
}class IndexAction extends Action{
function do(){
//调用M方法
}
}
<select id="condition" name="condition">
<option value="1">模糊搜索</option>
<option value="2">精确搜索</option>
</select>
<button type="submit" >
查询
</button>
</form>controllor中:
$condition = $_POST['condition'];
$condition = in_array($condition, array(1, 2)) ? $condition : 1;
$array_condition_search = array(
1 => " LIKE '%{$rolename}%'", //模糊搜索
2 => "= '{$rolename}'"
);
$where .= " AND name {$array_condition_search[$condition]}";
就是改变where的条件,判断就是了
那么你的框架就提供有 ajax 功能,按他的范例摹写一下就可以了
这里加个js 然后通过ajax传输