分类代码:
//jimphei's code
function brandcat_list($cat_id = 0, $selected = 0, $re_type = true)
{
$result=array();
static $res = NULL;
if (isset($_POST['brand_name']))
{
if(strtoupper(EC_CHARSET) == 'GBK')
{
$keyword = iconv("UTF-8", "gb2312", $_POST['brand_name']);
}
else
{
$keyword = $_POST['brand_name'];
}
$sql = "SELECT * FROM ".$GLOBALS['ecs']->table('brand')." WHERE brand_name like '%{$keyword}%' ORDER BY sort_order ASC";
}
else
{
$sql = "SELECT * FROM ".$GLOBALS['ecs']->table('brand')." where parent_id=$cat_id ORDER BY sort_order ASC";
}
$res=$GLOBALS['db']->query($sql);
while($row=$GLOBALS['db']->fetchRow($res))
{
//print_r($row);
$brand_logo = empty($row['brand_logo']) ? '' :
'
';
$site_url = empty($row['site_url']) ? 'N/A' : ''.$row['site_url'].'';
$row['brand_logo'] = $brand_logo;
$row['site_url'] = $site_url;
for($i=0;$i<$row['level'];$i++)
{
$row['margin'].=' ';
}
$result[]=$row;
//$result[]['child']=
}
foreach($result as $k=>$v)
{
$result[$k]['child']=brandcat_list($v['brand_id']);
}
if($re_type)
{
$options='';
$pid='';
foreach($result as $k=>$v)
{
$pid=$v['brand_id'];
if($selected==$v['brand_id'])
{
$selected='selected="selected"';
}
if($v['brand_id']==$pid)
{
$options.='';
}
$options.='';
}
}
return $result;
}
//jimphei's code
function list_arr($arr)
{
$result=array();
foreach($arr as $k=>$v)
{
$row['brand_id']=$v['brand_id'];
$row['brand_name']=$v['brand_name'];
$row['brand_logo']=$v['brand_logo'];
$row['site_url']=$v['site_url'];
$row['margin']=$v['margin'];
$row['parent_id']=$v['parent_id'];
$row['level']=$v['level'];
$row['brand_desc']=$v['brand_desc'];
$row['is_show']=$v['is_show'];
$row['sort_order']=$v['sort_order'];
$result[]=$row;
if(!empty($v['child']))
{
$result=array_merge($result,list_arr($v['child']));
}
}
return $result;
}
//jimhei's code
function get_brand_optons($selected=0,$arr)
{
$result='';
foreach($arr as $k=>$v)
{
$sel='';
if($selected==$v['brand_id'])
{
$sel="selected=\"selected\"";
}
$result.="";
if(!empty($v['child']))
{
$result.=get_brand_optons($selected,$v['child']);
}
}
return $result;
}
正文完