刚写的省市县三级联动 - 站长论坛

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- [url]http://www.phpmyadmin.net[/url]
--
-- 主机: localhost
-- 生成日期: 2007 年 05 月 10 日 22:56
-- 服务器版本: 6.0.0
-- PHP 版本: 5.2.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `test2`
--
-- --------------------------------------------------------
--
-- 表的结构 `area`
--
CREATE TABLE `area` (
`aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` varchar(10) NOT NULL,
`city` varchar(20) NOT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;
--
-- 导出表中的数据 `area`
--
INSERT INTO `area` (`aid`, `pid`, `city`, `name`) VALUES
(1, '1', '广州市', '新抚区'),
(2, '1', '广州市', '东洲区'),
(3, '1', '清远市', 'test0'),
(4, '2', '南宁市', 'test');
-- --------------------------------------------------------
--
-- 表的结构 `city`
--
CREATE TABLE `city` (
`cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) NOT NULL,
`city` varchar(20) NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ;
--
-- 导出表中的数据 `city`
--
INSERT INTO `city` (`cid`, `pid`, `city`) VALUES
(1, 1, '广州市'),
(2, 1, '清远市'),
(3, 2, '南宁市');
-- --------------------------------------------------------
--
-- 表的结构 `province`
--
CREATE TABLE `province` (
`pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`province` varchar(20) NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=3 ;
--
-- 导出表中的数据 `province`
--
INSERT INTO `province` (`pid`, `province`) VALUES
(1, '广东省'),
(2, '广西省');

复制代码

<?php
//include("../include/config.php");
mysql_connect("localhost","root","××××");
mysql_select_db("test2");
mysql_query("set names gbk");
@extract($HTTP_GET_VARS, EXTR_SKIP);
?>
= 请选择 =
<?php
$result = mysql_query ("SELECT * FROM province ORDER BY province");
while ($list = @mysql_fetch_row ($result)) {
if ($pid == $list[0]) {
echo "$list[1]";
} else {
echo "$list[1]";
}
}
?>
&city='+this.options[this.selectedIndex].value,'_self')">
= 请选择 =
<?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 "$list[2]";
} else {
echo "$list[2]";
}
}
}
?>
= 请选择 =
<?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 "$list[3]";
} else {
echo "$list[3]";
}
}
}
?>

复制代码