<script language = "JavaScript">
var onecount;
onecount=0;
subcat = new Array();<?
mysql_connect("localhost","root","");
mysql_select_db( "test" );
$sql = "select * from menu where parent_id != 0";
$result = mysql_query( $sql );
$count = 0;
while($res = mysql_fetch_row($result)){
?>
subcat[<? echo $count; ?>] = new Array("<? echo $res[2]; ?>","<? echo $res[1]; ?>","<? echo $res[0]; ?>");
<?
$count++;
}
echo "onecount=$count";
?>function changelocation(locationid)
{
document.myform.ctype.length = 0; var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.ctype.options[document.myform.ctype.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script><form method="post" name="myform" action="ru_query.php">
<select name="type" onChange="changelocation(document.myform.type.options[document.myform.type.selectedIndex].value)" size="1">
<option selected value="">请指定主分类</option>
<?
$sql = "select * from menu where parent_id = 0";
$result = mysql_query( $sql );
while($res = mysql_fetch_row($result)){
?> <option value="<? echo $res[0]; ?>"><? echo $res[2]; ?></option>
<? } ?>
</select>
<select name="ctype">
<option selected value="">请指定小分类</option>
</select>
<input type="submit" name="Submit" value="搜索">
</form>
#
# 表的结构 `menu`
#CREATE TABLE `menu` (
`id` tinyint(4) NOT NULL auto_increment,
`parent_id` tinyint(4) NOT NULL default '0',
`name` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;#
# 导出表中的数据 `menu`
#INSERT INTO `menu` VALUES (1, 0, '人事管理');
INSERT INTO `menu` VALUES (2, 0, '通讯交流');
INSERT INTO `menu` VALUES (3, 1, '档案管理');
INSERT INTO `menu` VALUES (4, 1, '考勤管理');
INSERT INTO `menu` VALUES (5, 2, '通讯录');
INSERT INTO `menu` VALUES (6, 2, '网络会议');
INSERT INTO `menu` VALUES (7, 3, '新增档案');
INSERT INTO `menu` VALUES (8, 3, '查询档案');
INSERT INTO `menu` VALUES (9, 3, '删除档案');
INSERT INTO `menu` VALUES (10, 5, '新增通讯记录');
INSERT INTO `menu` VALUES (11, 7, '档案新增');
var onecount;
onecount=0;
subcat = new Array();<?
mysql_connect("localhost","root","");
mysql_select_db( "test" );
$sql = "select * from menu where parent_id != 0";
$result = mysql_query( $sql );
$count = 0;
while($res = mysql_fetch_row($result)){
?>
subcat[<? echo $count; ?>] = new Array("<? echo $res[2]; ?>","<? echo $res[1]; ?>","<? echo $res[0]; ?>");
<?
$count++;
}
echo "onecount=$count";
?>function changelocation(locationid)
{
document.myform.ctype.length = 0; var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.ctype.options[document.myform.ctype.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</script><form method="post" name="myform" action="ru_query.php">
<select name="type" onChange="changelocation(document.myform.type.options[document.myform.type.selectedIndex].value)" size="1">
<option selected value="">请指定主分类</option>
<?
$sql = "select * from menu where parent_id = 0";
$result = mysql_query( $sql );
while($res = mysql_fetch_row($result)){
?> <option value="<? echo $res[0]; ?>"><? echo $res[2]; ?></option>
<? } ?>
</select>
<select name="ctype">
<option selected value="">请指定小分类</option>
</select>
<input type="submit" name="Submit" value="搜索">
</form>
#
# 表的结构 `menu`
#CREATE TABLE `menu` (
`id` tinyint(4) NOT NULL auto_increment,
`parent_id` tinyint(4) NOT NULL default '0',
`name` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;#
# 导出表中的数据 `menu`
#INSERT INTO `menu` VALUES (1, 0, '人事管理');
INSERT INTO `menu` VALUES (2, 0, '通讯交流');
INSERT INTO `menu` VALUES (3, 1, '档案管理');
INSERT INTO `menu` VALUES (4, 1, '考勤管理');
INSERT INTO `menu` VALUES (5, 2, '通讯录');
INSERT INTO `menu` VALUES (6, 2, '网络会议');
INSERT INTO `menu` VALUES (7, 3, '新增档案');
INSERT INTO `menu` VALUES (8, 3, '查询档案');
INSERT INTO `menu` VALUES (9, 3, '删除档案');
INSERT INTO `menu` VALUES (10, 5, '新增通讯记录');
INSERT INTO `menu` VALUES (11, 7, '档案新增');
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货