数据库SQL:-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 10 月 04 日 04:17
-- 服务器版本: 5.0.90
-- PHP 版本: 5.2.14SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;--
-- 数据库: `novel`
---- ----------------------------------------------------------
-- 表的结构 `ok`
--CREATE TABLE IF NOT EXISTS `ok` (
`xiangming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
`cunming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
`zuming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ok`
--INSERT INTO `ok` (`xiangming`, `cunming`, `zuming`) VALUES
('雷池乡', '雷港村', '合作组'),
('雷池乡', '雷港村', '拉拉组');-------------------------------------网页------------------------------------------------------------<?php
$link=mysql_connect("localhost","xypi20","a16812343") or die("数据库服务器连接错误".mysql_error());
mysql_select_db("novel",$link) or die("数据库访问错误".mysql_error());
mysql_query("set character set gb2312");
mysql_query("set names gb2312");
?>
<html>
<head>
<title>下拉框连动</title>
</head>
<body>
<script language="JavaScript">
//二级菜单数组
var subcat = new Array();
<?php
$i=0;
$sql="select * from ok";
$query=mysql_query($sql,$link);
while($arr=mysql_fetch_array($query))
{
echo "subcat[".$i++."] = new Array('".$arr["xiangming"]."','".$arr["cunming"]."');\n";
// 乡编号 //村名
}
?>
//三级菜单数组
var subcat2 = new Array();
<?php
$i=0;
$sql="select * from ok";
$query=mysql_query($sql,$link);
while($arr=mysql_fetch_array($query))
{
echo "subcat2[".$i++."] = new Array('".$arr["cunming"]."','".$arr["zuming"]."');\n";
} //村编号 //组名
?>
function changeselect1(locationid)
{
document.form1.s2.length = 0;
document.form1.s2.options[0] = new Option('请选择村名','');
for (i=0; i<subcat.length; i++)
{
if (subcat[i][0] == locationid)
{
document.form1.s2.options[document.form1.s2.length] = new Option(subcat[i][1], subcat[i][1]);
}
}
}
function changeselect2(locationid)
{
document.form1.s3.length = 0;
document.form1.s3.options[0] = new Option('请选择组名','');
for (i=0; i<subcat2.length; i++)
{
if (subcat2[i][0] == locationid)
{
document.form1.s3.options[document.form1.s3.length] = new Option(subcat2[i][1], subcat2[i][1]);
}
}
}
</script>三级联动演示:<BR>
<form name="form1" method="post" action="">
<select name="s1" onChange="changeselect1(this.value)">
<option>--请选择--</option>
<option value="雷池乡">雷池乡</option></select>
<select name="s2" onChange="changeselect2(this.value)">
<option>--请选择--</option>
</select>
<select name="s3">
<option>--请选择--</option>
</select>
<input type="submit" name="Submit" value="登录" />
<?php $name=$_POST["s1"];
$nname=$_POST["s2"];
$sf=$_POST["s3"];
echo $name;
echo $nname;
echo $sf;
?>
</form>
</body>
</html>现在出现2个 雷池乡 应该只有1个 怎么去除重复值啊 跪求啦
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 10 月 04 日 04:17
-- 服务器版本: 5.0.90
-- PHP 版本: 5.2.14SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;--
-- 数据库: `novel`
---- ----------------------------------------------------------
-- 表的结构 `ok`
--CREATE TABLE IF NOT EXISTS `ok` (
`xiangming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
`cunming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
`zuming` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;--
-- 转存表中的数据 `ok`
--INSERT INTO `ok` (`xiangming`, `cunming`, `zuming`) VALUES
('雷池乡', '雷港村', '合作组'),
('雷池乡', '雷港村', '拉拉组');-------------------------------------网页------------------------------------------------------------<?php
$link=mysql_connect("localhost","xypi20","a16812343") or die("数据库服务器连接错误".mysql_error());
mysql_select_db("novel",$link) or die("数据库访问错误".mysql_error());
mysql_query("set character set gb2312");
mysql_query("set names gb2312");
?>
<html>
<head>
<title>下拉框连动</title>
</head>
<body>
<script language="JavaScript">
//二级菜单数组
var subcat = new Array();
<?php
$i=0;
$sql="select * from ok";
$query=mysql_query($sql,$link);
while($arr=mysql_fetch_array($query))
{
echo "subcat[".$i++."] = new Array('".$arr["xiangming"]."','".$arr["cunming"]."');\n";
// 乡编号 //村名
}
?>
//三级菜单数组
var subcat2 = new Array();
<?php
$i=0;
$sql="select * from ok";
$query=mysql_query($sql,$link);
while($arr=mysql_fetch_array($query))
{
echo "subcat2[".$i++."] = new Array('".$arr["cunming"]."','".$arr["zuming"]."');\n";
} //村编号 //组名
?>
function changeselect1(locationid)
{
document.form1.s2.length = 0;
document.form1.s2.options[0] = new Option('请选择村名','');
for (i=0; i<subcat.length; i++)
{
if (subcat[i][0] == locationid)
{
document.form1.s2.options[document.form1.s2.length] = new Option(subcat[i][1], subcat[i][1]);
}
}
}
function changeselect2(locationid)
{
document.form1.s3.length = 0;
document.form1.s3.options[0] = new Option('请选择组名','');
for (i=0; i<subcat2.length; i++)
{
if (subcat2[i][0] == locationid)
{
document.form1.s3.options[document.form1.s3.length] = new Option(subcat2[i][1], subcat2[i][1]);
}
}
}
</script>三级联动演示:<BR>
<form name="form1" method="post" action="">
<select name="s1" onChange="changeselect1(this.value)">
<option>--请选择--</option>
<option value="雷池乡">雷池乡</option></select>
<select name="s2" onChange="changeselect2(this.value)">
<option>--请选择--</option>
</select>
<select name="s3">
<option>--请选择--</option>
</select>
<input type="submit" name="Submit" value="登录" />
<?php $name=$_POST["s1"];
$nname=$_POST["s2"];
$sf=$_POST["s3"];
echo $name;
echo $nname;
echo $sf;
?>
</form>
</body>
</html>现在出现2个 雷池乡 应该只有1个 怎么去除重复值啊 跪求啦
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货