二级联动
数据表
静态
< div class = "layui-form-item" >
< label for = "username" class = "layui-form-label" >
< span class = "x-red" > * < / span> 商品分类< / label>
< div class = "layui-input-inline" >
< select name= "pid" id= "pid" >
< option value = "" > 请选择分类< / option>
{ foreach $sql as $vo}
< option> value = "{$vo.id}" > { $vo. class } < / option>
{ / foreach}
< / select>
< select name= "class" id= "class1" >
< option value = "0" > 请选择< / option>
< / select>
< / div>
< / div>
jQuery
< script>
$ ( function ( ) {
$ ( "#pid" ) . change ( function ( ) {
var pid= $ ( '#pid' ) . val ( ) ;
$ ( "#class1" ) . empty ( ) ;
$. ajax ( {
async : true ,
type: "post" ,
url: "{:url('Commlist/ceshi')}" ,
data: { spid: pid} ,
dataType: "json" ,
success: function ( data) {
console. log ( data) ;
var i;
for ( i = 0 ; i < data. length; i++ ) {
$ ( "#class1" ) . append ( "<option value='" + data[ i] . pid+ "'>" + data[ i] . class + "</option>" ) ;
}
}
} ) ;
} ) ;
} )
< / script>
控制器
public function brandadd ( )
{
$db= db ( 'class' ) - > where ( 'pid' , 0 ) - > select ( ) ;
$id= input ( 'spid' ) ;
$time= db ( 'class' ) - > where ( 'pid' , $id) - > select ( ) ;
$this - > assign ( 'sql' , $db) ;
$this - > assign ( 'sqll' , $time) ;
return $this - > fetch ( 'commodity/brand/brandadd' ) ;
}
public function ceshi ( )
{
$id= input ( 'spid' ) ;
$time= db ( 'class' ) - > where ( 'pid' , $id) - > select ( ) ;
return $time;
}
二级分类
数据表
静态
< div class = "layui-form-item" >
< label for = "username" class = "layui-form-label" >
< span class = "x-red" > * < / span> 上级分类< / label>
< select name= "topclass" required= "" style= "margin-top: 10px;" >
< option value= "0" > 上级分类< / option>
{ foreach $class_list as $v}
< option value= "{$v.id}" > { $v. name} < / option>
{ foreach $v. item as $vs}
< option value= "{$vs.id}" > ——{ $vs. name} < / option>
{ / foreach}
{ / foreach}
< / select>
< / div>
控制器
$class_list= db ( 'topclass' ) - > field ( array ( 'id' , 'name' ) ) - > where ( array ( 'pid' => 0 ) ) - > select ( ) ;
foreach ( $class_list as $k=> $v) {
$time= db ( 'topclass' ) - > where ( array ( 'pid' => $v[ 'id' ] ) ) - > select ( ) ;
$class_list[ $k] [ 'item' ] = $time;
}
$this - > assign ( 'class_list' , $class_list) ;