ThinkPHP多字段匹配模糊查询

<?php （一）模糊查询的多字段之间关系为AND public function findWithInput() { $SellerLocation = D('SellerLocation'); $input = I('input'); if (!$input) { $this->ajaxReturn(array('result' => 'false', 'data' => 'Unable to get your input parameters'), 'JSON');//无法获取用户输入参数 } else { //多字段之间是AND关系 $where['store_name & street & province & city & county & town & specific_address'] = array('like', "%$input%"); $list = $SellerLocation->where($where)->fetchSql(true)->select();//只返回SQL语句，并不进行真实查询 //生成SQL语句为：SELECT * FROM `maigade_seller_location` WHERE ( (`store_name` LIKE '19%') AND (`street` LIKE '19%') AND (`province` LIKE '19%') AND (`city` LIKE '19%') AND (`county` LIKE '19%') AND (`town` LIKE '19%') AND (`specific_address` LIKE '19%') ) if ($list != null) { $this->ajaxReturn(array('result' => 'success', 'data' => $list), 'JSON'); } elseif ($list == null) { $this->ajaxReturn(array('result' => 'false', 'data' => 'According to the information you have entered is not found in the vicinity of the shop'), 'JSON'); } else { $this->ajaxReturn(array('result' => 'false', 'data' => 'Select store error'), 'JSON'); } } } (二)模糊查询的多字段之间关系为OR public function findWithInput() { $SellerLocation = D('SellerLocation'); $input = I('input'); if (!$input) { $this->ajaxReturn(array('result' => 'false', 'data' => 'Unable to get your input parameters'), 'JSON');//无法获取用户输入参数 } else { //多字段之间是OR关系 $where['store_name | street | province | city | county | town | specific_address'] = array('like', "%$input%"); $list = $SellerLocation->where($where)->fetchSql(true)->select();//只返回SQL语句，并不进行真实查询 //生成SQL语句为：SELECT * FROM `maigade_seller_location` WHERE ( `store_name` LIKE '19%' OR `street` LIKE '19%' OR `province` LIKE '19%' OR `city` LIKE '19%' OR `county` LIKE '19%' OR `town` LIKE '19%' OR `specific_address` LIKE '19%' ) if ($list != null) { $this->ajaxReturn(array('result' => 'success', 'data' => $list), 'JSON'); } elseif ($list == null) { $this->ajaxReturn(array('result' => 'false', 'data' => 'According to the information you have entered is not found in the vicinity of the shop'), 'JSON'); } else { $this->ajaxReturn(array('result' => 'false', 'data' => 'Select store error'), 'JSON'); } } }