Beispiel #1
0
	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\"}");
	    }
	}
Beispiel #2
0
    //搜索
    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');
		}
		*/