php商城多条件筛选,php - 电商网站中的多条件筛选需求

用的thinkphp框架

$search=urldecode(I("search"));

$this->assign('search',$search);

if(!empty($_POST)){

//$condition = array();

$condition['goods_name']=array("like","%$search%");

//I('brand') ? $condition['brand_id'] = I('brand') : false;

if(I('brand')){

$condition['brand_id']=

}

//$condition['brand_id'] =80;

//I('func') ? $condition['func'] = I('func') : false;

//I('price') ? $condition['shop_price'] = I('price') : false;

var_dump($condition);

//$gList = M('Goods')->where($condition)->select();

//echo "

";

//var_dump($gList);

//echo "

";

}

我这样写的但是 并不能多条件多 多选查询 求大神 讲讲sql怎么写 最好tp的sql写法