看一下这段代码怎么修改
程序员文章站
2022-05-09 16:58:04
...
//执行正常搜索
///*
if (isset($goods_param['class'])) {
$condition['gc_id_'.$goods_param['class']['depth']] = $goods_param['class']['gc_id'];
}
//*/
if (intval($_GET['b_id']) > 0) {
$condition['brand_id'] = intval($_GET['b_id']);
}
if ($_GET['keyword'] != '') {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
if (intval($_GET['area_id']) > 0) {
$condition['areaid_1'] = intval($_GET['area_id']);
}
if ($_GET['type'] == 1) {
$condition['is_own_shop'] = 1;
}
if ($_GET['gift'] == 1) {
$condition['have_gift'] = 1;
}
if (isset($goods_param['goodsid_array'])){
$condition['goods_id'] = array('in', $goods_param['goodsid_array']);
}
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fields, $order, self::PAGESIZE);
}
现在的问题是第一个if中$condition这个是不是只查询一个条件gc_id,我想让他同时查询gc_id和gc_id1的,怎么修改啊大神们,我菜鸟一个,刚刚开始学习呀
在哪看架构啊?我这个是用的shopnc的那个商城系统
///*
if (isset($goods_param['class'])) {
$condition['gc_id_'.$goods_param['class']['depth']] = $goods_param['class']['gc_id'];
}
//*/
if (intval($_GET['b_id']) > 0) {
$condition['brand_id'] = intval($_GET['b_id']);
}
if ($_GET['keyword'] != '') {
$condition['goods_name|goods_jingle'] = array('like', '%' . $_GET['keyword'] . '%');
}
if (intval($_GET['area_id']) > 0) {
$condition['areaid_1'] = intval($_GET['area_id']);
}
if ($_GET['type'] == 1) {
$condition['is_own_shop'] = 1;
}
if ($_GET['gift'] == 1) {
$condition['have_gift'] = 1;
}
if (isset($goods_param['goodsid_array'])){
$condition['goods_id'] = array('in', $goods_param['goodsid_array']);
}
$goods_list = $model_goods->getGoodsListByColorDistinct($condition, $fields, $order, self::PAGESIZE);
}
现在的问题是第一个if中$condition这个是不是只查询一个条件gc_id,我想让他同时查询gc_id和gc_id1的,怎么修改啊大神们,我菜鸟一个,刚刚开始学习呀
回复讨论(解决方案)
没人么、?来帮我一下,谢谢百分百结贴
这个要看架构中怎么组合的$condition,这样看看不出来啊
这句话什么意思、?
$condition['gc_id_'.$goods_param['class']['depth']] = $goods_param['class']['gc_id'];
这个要看架构中怎么组合的$condition,这样看看不出来啊
在哪看架构啊?我这个是用的shopnc的那个商城系统
因为不同的架构里面的处理组合where条件是不同的,所以需要看底层的where处理,不过我感觉一个开源产品应该会有对应的操作
http://wenku.baidu.com/link?url=Wak60lv0ReREdfCBMNFvsRmM0kFpUIwumfydaw0VKvnbM6APvSibwXSnmlQcxM_Xa0YqIgQitFahgwbr_5GsheP1f4FKT-46mXTLYRVs0EO
这里24、25页