![这里写图片描述](https://img-blog.csdn.net/20170628151844096?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbTBfMzgwMjczNTg=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
sorturl.php
<?php
$id=isset($_GET['id'])?$_GET['id']:0;
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 where pid='.$id)->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($data);
?>
sort.php
<?php
$id=isset($_GET['id'])?$_GET['id']:0;
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 where pid='.$id)->fetchAll(PDO::FETCH_ASSOC);
?>
<select name="" class="box">
<option value="">请选择</option>
<?php foreach($data as $k => $v){ ?>
<option value="<?= $v['id'] ?>"><?= $v['name'] ?></option>
<?php } ?>
</select>
<script src="jquery.1.12.min.js"></script>
<script>
$(function(){
$(document).on('change','.box',function(){
var obj=$(this);
var id=obj.val();
$.ajax({
type:'get',
url:'sorturl.php',
data:{id:id},
dataType:'json',
success:function(res){
if(res==''){
obj.nextAll().remove();
return false;
}
var str='<select name="" class="box"><option value="">请选择</option>';
$.each(res,function(k,v){
str+='<option value="'+v.id+'">'+v.name+'</option>';
});
str+='</select>';
obj.nextAll().remove();
obj.after(str);
}
})
});
})
</script>