21,886
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE IF NOT EXISTS `www.dianxin.com`.`dx_gd_type` (
`t_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID\n' ,
`t_name` VARCHAR(120) NULL COMMENT '购物名称分类\n' ,
`t_family_id` varchar(11) NOT NULL DEFAULT '00000000' COMMENT ' 父ID,顶级分类默认为0\n' ,
`t_orders` SMALLINT(5) NULL COMMENT '购物分类排序\n' ,
`t_remark` varchar(50) NULL COMMENT '备注\n' ,
PRIMARY KEY (`t_id`) )
ENGINE = MyISAM DEFAULT CHARSET=utf8
COMMENT = '点心购物类型表\n';
10 代表衣服
20 代表数码
30 代表家具
二级分类
1001 代表男式衣服
1002 代表女式衣服
三级分类
100201 代表女式内衣
100202 代表女式……
$r = array();
foreach($ar as $v) {
$k = "r['" . join("']['", str_split(array_shift($v), 2)) ."']['value']";
eval("\$$k = \$v;");
}
function func($ar) {
if(! is_array($ar)) return;
foreach($ar as $key=>$item) {
echo '<dl>';
foreach($item as $k=>$t)
if($k == 'value') {
echo "<dt>$key</dt>";
foreach($t as $v) echo "<dd>$v</dd>";
}else func($t);
echo '</dl>';
}
}
<?php
array (
10 =>
array (
'value' =>
array (
't_id' => '4092',
't_name' => '女装',
't_family_id' => '10',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4099',
't_name' => '上装',
't_family_id' => '1001',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4123',
't_name' => 'T恤/卫衣',
't_family_id' => '100101',
't_orders' => NULL,
't_remark' => NULL,
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4124',
't_name' => '针织衫/毛衣',
't_family_id' => '100102',
't_orders' => NULL,
't_remark' => NULL,
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4125',
't_name' => '衬衫/雪纺衫',
't_family_id' => '100103',
't_orders' => NULL,
't_remark' => NULL,
),
),
'04' =>
array (
'value' =>
array (
't_id' => '4126',
't_name' => '小西服/小外套',
't_family_id' => '100104',
't_orders' => NULL,
't_remark' => NULL,
),
),
'05' =>
array (
'value' =>
array (
't_id' => '4127',
't_name' => '风衣/呢大衣',
't_family_id' => '100105',
't_orders' => NULL,
't_remark' => NULL,
),
),
'06' =>
array (
'value' =>
array (
't_id' => '4128',
't_name' => '背心/吊带衫',
't_family_id' => '100106',
't_orders' => NULL,
't_remark' => NULL,
),
),
'07' =>
array (
'value' =>
array (
't_id' => '4129',
't_name' => '马甲',
't_family_id' => '100107',
't_orders' => NULL,
't_remark' => NULL,
),
),
'08' =>
array (
'value' =>
array (
't_id' => '4130',
't_name' => '棉衣/棉服',
't_family_id' => '100108',
't_orders' => NULL,
't_remark' => NULL,
),
),
'09' =>
array (
'value' =>
array (
't_id' => '4131',
't_name' => '羽绒服',
't_family_id' => '100109',
't_orders' => NULL,
't_remark' => NULL,
),
),
10 =>
array (
'value' =>
array (
't_id' => '4132',
't_name' => '皮衣/皮草',
't_family_id' => '100110',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4100',
't_name' => '下装',
't_family_id' => '1002',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4133',
't_name' => '裤子',
't_family_id' => '100201',
't_orders' => NULL,
't_remark' => NULL,
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4134',
't_name' => '牛仔裤',
't_family_id' => '100202',
't_orders' => NULL,
't_remark' => NULL,
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4135',
't_name' => '裤袜/丝袜/打底裤',
't_family_id' => '100203',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4101',
't_name' => '裙',
't_family_id' => '1003',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4136',
't_name' => '连衣裙',
't_family_id' => '100301',
't_orders' => NULL,
't_remark' => NULL,
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4137',
't_name' => '半身裙',
't_family_id' => '100302',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
),
20 =>
array (
'value' =>
array (
't_id' => '4093',
't_name' => '男装',
't_family_id' => '20',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4102',
't_name' => '上装',
't_family_id' => '2001',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4138',
't_name' => 'T恤',
't_family_id' => '200101',
't_orders' => NULL,
't_remark' => NULL,
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4139',
't_name' => '衬衫',
't_family_id' => '200102',
't_orders' => NULL,
't_remark' => NULL,
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4140',
't_name' => '外套',
't_family_id' => '200103',
't_orders' => NULL,
't_remark' => NULL,
),
),
'04' =>
array (
'value' =>
array (
't_id' => '4141',
't_name' => 'POLO衫',
't_family_id' => '200104',
't_orders' => NULL,
't_remark' => NULL,
),
),
'05' =>
array (
'value' =>
array (
't_id' => '4142',
't_name' => '针织衫/毛衣',
't_family_id' => '200105',
't_orders' => NULL,
't_remark' => NULL,
),
),
'06' =>
array (
'value' =>
array (
't_id' => '4143',
't_name' => '卫衣',
't_family_id' => '200106',
't_orders' => NULL,
't_remark' => NULL,
),
),
'07' =>
array (
'value' =>
array (
't_id' => '4144',
't_name' => '羽绒服',
't_family_id' => '200107',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4103',
't_name' => '下装',
't_family_id' => '2002',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4145',
't_name' => '裤子',
't_family_id' => '200201',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4104',
't_name' => '配件',
't_family_id' => '2003',
't_orders' => NULL,
't_remark' => NULL,
),
'01' =>
array (
'value' =>
array (
't_id' => '4146',
't_name' => '男鞋',
't_family_id' => '200301',
't_orders' => NULL,
't_remark' => NULL,
),
),
'02' =>
array (
'value' =>
array (
't_id' => '4147',
't_name' => '运动鞋',
't_family_id' => '200302',
't_orders' => NULL,
't_remark' => NULL,
),
),
'03' =>
array (
'value' =>
array (
't_id' => '4148',
't_name' => '箱包票夹',
't_family_id' => '200303',
't_orders' => NULL,
't_remark' => NULL,
),
),
),
),
)
?>
public function func($arr,$count,$beforcount,$spList){
foreach($arr as $key => $val){
if( $key == 'value') {
if($count==1){
$html .= '<div class="right_nav" id="menu_'.$val["t_family_id"].'">';
} else if($count==2 ){
$html .= '<dt class="lef"><h1>'.$val["t_name"].'</h1></dt><dd>';
} else if( $count==3 ){
$html .= '<a href="">'.$val["t_name"].'</a>';
}
$spList = array_merge($spList, array($html));
array_shift($arr);
} else {
$beforcount = $count;
$count++;
$this->func($val,$count,$beforcount,$spList);
}
}
if(count($arr)==0){
$s_html = '';
foreach($spList as $key => $val){
$s_html = $s_html.$val;
}
echo "<pre>";print_r($spList);exit();
}
}