public function search () { if(!empty($_REQUEST['keyword'])) { if(EC_CHARSET == 'utf-8'){ //$keyword = empty($_GET['keyword']) ? '': gbktoutf8(trim($_GET['keyword'])); $keyword = empty($_GET['keyword']) ? '': urldecode(trim($_GET['keyword'])); }else{ //$keyword = empty($_GET['keyword']) ? '': utf8togbk(trim($_GET['keyword'])); $keyword = empty($_GET['keyword']) ? '': urldecode(trim($_GET['keyword'])); $keyword = mb_convert_encoding($keyword,'gbk','utf-8'); } $page = !empty($_REQUEST['page']) ? intval(trim($_REQUEST['page'])) : 1; $page_size = !empty($_REQUEST['page_size']) ? intval(trim($_REQUEST['page_size'])) : 3; //计算查询结果条数 $sql_count = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods') . " where goods_name like '%$keyword%' and `is_on_sale`=1 and `is_delete`=0 "; $record_count = $GLOBALS['db']->getOne($sql_count); $list = array(); if($record_count>0) { $pager = get_pager('goods_list.php', $_GET, $record_count, $page, $page_size); $arr = zy_search($keyword, $page, $page_size, $record_count); if(!empty($arr)) { $list['goods'] = $arr; $list['pager'] = $pager; }else { $list['status'] = rpcLang('goods.php', 'no_data'); } } jsonExitSearch($list); } else { $msg = rpcLang('goods.php', 'no_keyword'); jsonExit("{\"status\":\"$msg\"}"); } }
//搜索 if(!empty($_REQUEST['keyword'])) { $keyword = gbktoutf8(trim($_REQUEST['keyword'])); $page = !empty($_REQUEST['page']) ? intval(trim($_REQUEST['page'])) : 1; $page_size = !empty($_REQUEST['page_size']) ? intval(trim($_REQUEST['page_size'])) : 3; //计算查询结果条数 $sql_count = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods') . " where goods_name like '%$keyword%' "; $record_count = $GLOBALS['db']->getOne($sql_count); $list = array(); if($record_count>0) { $pager = get_pager('goods_list.php', array('act' => $act), $record_count, $page, $page_size); $arr = zy_search($keyword, $page, $page_size, $record_count); if(!empty($arr)) { $list['goods'] = $arr; $list['pager'] = $pager; }else { $list['status'] = rpcLang('goods.php', 'no_data'); } } /* else { $list['status'] = rpcLang('goods.php', 'no_data'); } */