PHP多条件搜索ShopNc实例

if (trim($_GET['keyword']) != '') {
//echo $_GET['search_type']; exit();
switch ($_GET['search_type']) {
case 0:
$where['goods_id'] = array('like', '%' . trim($_GET['keyword']) . '%');
break;
case 1:
$where['goods_name'] = array('like', '%' . trim($_GET['keyword']) . '%');
break;
case 2:
$where['goods_serial'] = intval($_GET['keyword']);
break;
}
}
$goods_list = $model_goods->where($where)->page(8)->order('goods_addtime DESC')->select();

<form method="get" action="">
<input type="hidden" name="act" value="goods_public" />
<input type="hidden" name="op" value="goodsOp" />
<select name="search_type" id="">
<option value="0">商品ID</option>
<option value="1">商品名称</option>
<option value="2">商品货号</option>
</select>
<tr>
<td></td>
<td class="w160">
<input type="text" class="text" name="keyword" value="<?php echo $_GET['keyword']; ?>"/>
</td>
<td class="tc w70">
<label class="submit-border">
<input type="submit" class="submit" value="搜索" />
</label>
</td>
</tr>
</form>