sort.php
<?php
header('content-type:text/html;charset=utf-8');
$pdo=new PDO('mysql:host=localhost;dbname=laravelinfo;','root','root');
$pdo->exec('set names utf8');
$data=$pdo->query('select * from sort')->fetchAll(PDO::FETCH_ASSOC);
function getSort($data,$pid=0,$level=''){
static $arr=array();
foreach($data as $k => $v){
//如果该分类pid=0
if($v['pid']==$pid){
$v['level']=$level;
$arr[]=$v;
getSort($data,$v['id'],$level.'-------');
// print_r($arr);die;
}
}
return $arr;
}
$info=getSort($data);
// print_r($info);die;
?>
<select name="" id="">
<?php foreach($info as $k => $v){ ?>
<option value=""><?= $v['level'] ?><?= $v['name'] ?></option>
<?php } ?>
</select>
1 — 0
2 — 1
3 — 2
4 — 3
function oneSort($data,$pid=0){
$arr=[];
foreach($data as $k => $v){
if($v['pid']==$pid){
$v['child']= getSort($data,$v['id']);
$arr[]=$v;
// print_r($arr);die; pid:0 1 2 3 //id=4
}
}
return $arr;
}
function getSort($data,$pid=0){
static $arr=[];
foreach($data as $k => $v){
//如果该分类pid=0
if($v['parent_id']==$pid){
$arr[]=$v;
$v['child']= getSort($data,$v['id']);
print_r($arr);die; //pid: 0 1 2 3 //id [1 2 3 4]
}
}
return $arr;
}