PHP+MySQL实现二级联动下拉列表

PHP+MySQL实现二级联动下拉列表

1.Javascript在下拉列表的各个对象

2.案例代码

Liandong.php

$link=mysql_connect("localhost","root","12345678") or die("Could not connect：".mysql_error());

mysql_select_db("phpquery") or die("Could not select database or database haven't created");

//获取大类别

$queryCol="select*from tb_firstcategory order by id";

mysql_query("set names utf-8");

$result1=mysql_query($queryCol) or die("Query failed:".mysql_error());

$firstcategories=array();

while($row1=mysql_fetch_array($result1)){

$firstcategories[]=$row1;

}

mysql_free_result($result1);

//获取小类别

$querySecondCat="select*from tb_secondcategory order by fid desc";

mysql_query("set names utf-8");

if(!($result2=mysql_query($querySecondCat))){

die("Cound not query tb_secondcategory list");

}

$secondcategories=array();

while($row2=mysql_fetch_array($result2)){

$secondcategories[]=$row2;

}

mysql_free_result($result2);

?>

选择：

==请选择大类别==

$num=count($firstcategories);

for($i=0;$i<$num;$i++){

?>

}

?>

==选择小类别==