php+js实现二级联动下拉菜单(结合mysql数据库)_JS二级联动下拉列表 PHP实现

var optionArray = new Array();

$grade_sql = "select distinct grade_id from subjects";

$grade_result = $dbconn -> get_result($grade_sql);

while($grade_row = mysql_fetch_assoc($grade_result)){

$grade_id = $grade_row['grade_id'];

?>

optionArray[<?php echo $grade_id;?>] = new Array();

}

?>

$subject_sql = "select * from subjects order by grade_id";

$subject_result = $dbconn -> get_result($subject_sql);

$start_pos = 0;

$start_grade = 0;

while($subject_row = mysql_fetch_assoc($subject_result)){

$grade_id = $subject_row['grade_id'];

$subject_id = $subject_row['id'];

$name = $subject_row['name'];

if($start_grade != $grade_id){

$start_pos = 0;

$start_grade = $grade_id;

}

?>

optionArray[<?php echo $grade_id;?>][<?php echo $start_pos;?>] = new Option("<?php echo $name;?>", "<?php echo $subject_id;?>");

$start_pos++;

}

?>

function redirec(x){

var temp = document.frm.subject_id;

for (i=0;i

temp.options[i]=new Option(optionArray[x][i].text,optionArray[x][i].value);

}

temp.options[0].selected=true;

}

请选择年级

while($row = mysql_fetch_assoc($result)){

$grade_i