您当前的位置: 首页 » PHP/Perl编程 » 刚写的省市县三级联动
刚写的省市县三级联动
论坛链接
<?php
//include("../include/config.php");
mysql_connect("localhost","root","××××");
mysql_select_db("test2");
mysql_query("set names gbk");
@extract($HTTP_GET_VARS, EXTR_SKIP);
?>
<select name='pid' size='1' onchange="window.open('test.php?pid='+this.options[this.selectedIndex].value,'_self')">
<option value="" selected>= 请选择 =</option>
<?php
$result = mysql_query ("SELECT * FROM province ORDER BY province");
while ($list = @mysql_fetch_row ($result)) {
if ($pid == $list[0]) {
echo "<option value='$list[0]' selected>$list[1]</option>";
} else {
echo "<option value='$list[0]'>$list[1]</option>";
}
}
?>
</select>
<select name='city' size='1' onchange="window.open('test.php?pid=<?="$pid";?>&city='+this.options[this.selectedIndex].value,'_self')">
<option value="" selected>= 请选择 =</option>
<?php
if (!empty($pid)) {
$result = mysql_query ("SELECT * FROM city WHERE pid='$pid' ORDER BY city");
while ($list = @mysql_fetch_row ($result)) {
if ($city == $list[2]) {
echo "<option value='$list[2]' selected>$list[2]</option>";
} else {
echo "<option value='$list[2]'>$list[2]</option>";
}
}
}
?>
</select>
<select name='area' size='1'>
<option value="" selected>= 请选择 =</option>
<?php
if (!empty($pid)) {
$result = mysql_query ("SELECT * FROM area WHERE city='$city' ORDER BY name");
while ($list = @mysql_fetch_row ($result)) {
if ($area == $list[0]) {
echo "<option value='$list[0]' selected>$list[3]</option>";
} else {
echo "<option value='$list[0]'>$list[3]</option>";
}
}
}
?>
</select>
//include("../include/config.php");
mysql_connect("localhost","root","××××");
mysql_select_db("test2");
mysql_query("set names gbk");
@extract($HTTP_GET_VARS, EXTR_SKIP);
?>
<select name='pid' size='1' onchange="window.open('test.php?pid='+this.options[this.selectedIndex].value,'_self')">
<option value="" selected>= 请选择 =</option>
<?php
$result = mysql_query ("SELECT * FROM province ORDER BY province");
while ($list = @mysql_fetch_row ($result)) {
if ($pid == $list[0]) {
echo "<option value='$list[0]' selected>$list[1]</option>";
} else {
echo "<option value='$list[0]'>$list[1]</option>";
}
}
?>
</select>
<select name='city' size='1' onchange="window.open('test.php?pid=<?="$pid";?>&city='+this.options[this.selectedIndex].value,'_self')">
<option value="" selected>= 请选择 =</option>
<?php
if (!empty($pid)) {
$result = mysql_query ("SELECT * FROM city WHERE pid='$pid' ORDER BY city");
while ($list = @mysql_fetch_row ($result)) {
if ($city == $list[2]) {
echo "<option value='$list[2]' selected>$list[2]</option>";
} else {
echo "<option value='$list[2]'>$list[2]</option>";
}
}
}
?>
</select>
<select name='area' size='1'>
<option value="" selected>= 请选择 =</option>
<?php
if (!empty($pid)) {
$result = mysql_query ("SELECT * FROM area WHERE city='$city' ORDER BY name");
while ($list = @mysql_fetch_row ($result)) {
if ($area == $list[0]) {
echo "<option value='$list[0]' selected>$list[3]</option>";
} else {
echo "<option value='$list[0]'>$list[3]</option>";
}
}
}
?>
</select>