作者:别禳莴觞芯_737 | 来源:互联网 | 2023-09-09 07:29
Controller:publicfunctionactionWorkadd(){$sqlselect*fromwork;$dataYii::$app-db-createC
Controller:
public function actionWorkadd()
{
$sql="select * from work";
$data=Yii::$app->db->createCommand($sql)->queryAll();
//print_r($data);die;
$option=nolimit($data,0); //调用递归方法
//print_r($option);die;
return $this->renderPartial('workadd',['res'=>$option]);
}
function nolimit($data,$p_id=0,$level=0){
//加static防止覆盖上一次的
static $arr=array();
foreach($data as $v){
if($v['p_id']==$p_id){
$v['level']=$level;
$arr[]=$v;
$option=nolimit($data,$v['w_ids'],$level+1);
}
}
//返回数据
return $arr;
}
view:
样式:
![](https://img-blog.csdn.net/20160525075637016?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)
数据库样式:
![](https://img-blog.csdn.net/20160525080012064?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQv/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center)