如何用PHP动态生成与数据库关联的下拉菜单选项 当鼠标移动到特定对象上时触发onmouseover事件。当鼠标按键松开时触发onmouseup事件当鼠标从特定的对象上移开时触发onmouseout事件 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select应该用onChange事件楼主的问题应该用Ajax来解决。 可以去了解一下JQuery或prototype这样的AJAX框架,里面封装了很多的效果和方法,可以给你在开发AJAX时带来很多的方便,像这些效果,巧妙的结合使用,会让你带来很多意想不到的结果! 越说越离谱 AJAX都上来了把所有的2级选项都生成好了 display=noneonChang="2.style=''";足够LZ用的了 明明很简单的问题非要复杂化 DHTML能做很多事 我最近正好做这样的联动菜单,把部分代码发给你。这个事2个select菜单,不是3个的。 仅供你参考<html></body><form name="PN_Review_Search" method="post"> <?php GetModelSelectList( $PRDBConn , "PN_Review_Search" ) ;?></form></body></html><?php//連動するのSelectメミューfunction GetModelSelectList( $Conn , $FORMNAME ){ $SQL_01 =" SELECT DISTINCT PRODUCTID FROM MN_PROJECT"; $RS_01 = db_select($Conn, $SQL_01); $i = 0; $strRes_01 = "<SELECT name=\"lbl_PROJECTINDEX\" onChange=\"redirect(this.options.selectedIndex)\" >\n"; $strRes_01 .= "<OPTION SELECTED VALUE=\"\"></OPTION>\n" ; $modelHash = hash(); foreach ($RS_01 AS $ROW_01){ $modelHash[$ROW_01["PRODUCTID"]] = hash(); } foreach ($RS_01 AS $ROW_01){ $tmp = ""; ( $ROW_01["PRODUCTID"] == 1 ) && $tmp = "docomo"; ( $ROW_01["PRODUCTID"] == 4 ) && $tmp = "softbank"; //$strRes .= "<OPTION VALUE=\"". ++$i ."\">". $ROW_01["PRODUCTID"]. "</OPTION>\n"; $strRes_01 .= "<OPTION VALUE=\"". ++$i ."\">". $tmp . "</OPTION>\n"; } $strRes_01 .= "</SELECT>\n"; $SQL_02 ="SELECT DISTINCT PRODUCTID,PROJECTID,COMMONNAME,DSPNO FROM MN_PROJECT ORDER BY PRODUCTID, DSPNO DESC ";// $SQL_02 ="SELECT DISTINCT PROJECTID,COMMONNAME,DSPNO,PRODUCTID FROM MN_PROJECT ORDER BY PRODUCTID, DSPNO DESC "; $RS_02 = db_select($Conn, $SQL_02); $strRes_02 .= "<select name=\"lbl_PROJECTID\" >\n"; $strRes_02 .= "<OPTION SELECTED VALUE=\"\"></OPTION>\n" ; foreach ($RS_02 AS $ROW_02){ $modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["PROJECTID"] = $ROW_02["PROJECTID"]; $modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["COMMONNAME"] = $ROW_02["COMMONNAME"] ;// $modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["DSPNO"] = $ROW_02["DSPNO"]; $strRes_02 .= "<OPTION VALUE=\"".$ROW_02["PROJECTID"]."\">".$ROW_02["COMMONNAME"]."</OPTION>\n" ; } $strRes_02 .= "</select>\n"; echo $strRes_02 ; echo $strRes_01 ;?><script><?php $cnt = count($modelHash)+1;echo "var group=new Array($cnt);\n";echo "group[0]=new Array();\n";echo "group[0][0]=new Option(\"\",\"\");\n";$i = 1;foreach ($modelHash AS $modelRS){ echo "group[$i]=new Array();\n"; echo "group[$i][0]=new Option(\"\",\"\");\n"; $j = 1; foreach ($modelRS AS $modelROW){ echo "group[$i][$j] = new Option(\"". $modelROW["COMMONNAME"] ."\", \"". $modelROW["PROJECTID"] . "\");\n"; $j++; } $i++;}?>function redirect_init(){//全件表示 var obj=document.<?php echo $FORMNAME;?>.lbl_PROJECTID; for (m=obj.options.length-1;m>0;m--){ obj.options[m]=null } <?php $i=0; echo "obj.options[0] = new Option(\"\",\"\");\n"; foreach ($RS_02 AS $ROW_02){ echo "\tobj.options[$i+1]=new Option(\"".$ROW_02["COMMONNAME"]."\",\"".$ROW_02["PROJECTID"]."\");\n"; $i++; } ?> obj.options[0].selected=true }function redirect(x){//機種を分かれて表示 if (x == 0) { redirect_init(); return; } var obj=document.<?php echo $FORMNAME;?>.lbl_PROJECTID; for (m=obj.options.length-1;m>0;m--){ obj.options[m]=null } for (i=0;i<group[x].length;i++){ obj.options[i]=new Option(group[x][i].text,group[x][i].value) } obj.options[0].selected=true}</script><?php}?> 给楼主推荐一篇文章是关于select菜单的http://www.javascriptkit.com/javatutors/selectcontent.shtml php获取手机归属地....你们用的是什么方法 需求网站制作 win7下 phpmyadmin 无法登陆 关于_session 变量输出问题 大伙儿能推荐一个比较好的免费空间吗? 菜鸟问题,超菜——PHP读取文本文件相关(内详!高手登录!) php连MySQL数据库 ASP.NET 还是PHP ? 这个用php咋写啊,怎么写都错 PHP加密的思路。 js高手都来:数组生成无限级目录树,只差一个算法即可和CSDN完全一样! 一个显示问题?
这个事2个select菜单,不是3个的。 仅供你参考
<html>
</body><form name="PN_Review_Search" method="post">
<?php GetModelSelectList( $PRDBConn , "PN_Review_Search" ) ;?>
</form>
</body>
</html>
<?php//連動するのSelectメミュー
function GetModelSelectList( $Conn , $FORMNAME )
{ $SQL_01 =" SELECT DISTINCT PRODUCTID FROM MN_PROJECT";
$RS_01 = db_select($Conn, $SQL_01);
$i = 0;
$strRes_01 = "<SELECT name=\"lbl_PROJECTINDEX\" onChange=\"redirect(this.options.selectedIndex)\" >\n";
$strRes_01 .= "<OPTION SELECTED VALUE=\"\"></OPTION>\n" ;
$modelHash = hash();
foreach ($RS_01 AS $ROW_01){
$modelHash[$ROW_01["PRODUCTID"]] = hash();
}
foreach ($RS_01 AS $ROW_01){
$tmp = "";
( $ROW_01["PRODUCTID"] == 1 ) && $tmp = "docomo";
( $ROW_01["PRODUCTID"] == 4 ) && $tmp = "softbank";
//$strRes .= "<OPTION VALUE=\"". ++$i ."\">". $ROW_01["PRODUCTID"]. "</OPTION>\n";
$strRes_01 .= "<OPTION VALUE=\"". ++$i ."\">". $tmp . "</OPTION>\n";
}
$strRes_01 .= "</SELECT>\n";
$SQL_02 ="SELECT DISTINCT PRODUCTID,PROJECTID,COMMONNAME,DSPNO FROM MN_PROJECT ORDER BY PRODUCTID, DSPNO DESC ";
// $SQL_02 ="SELECT DISTINCT PROJECTID,COMMONNAME,DSPNO,PRODUCTID FROM MN_PROJECT ORDER BY PRODUCTID, DSPNO DESC ";
$RS_02 = db_select($Conn, $SQL_02); $strRes_02 .= "<select name=\"lbl_PROJECTID\" >\n";
$strRes_02 .= "<OPTION SELECTED VALUE=\"\"></OPTION>\n" ; foreach ($RS_02 AS $ROW_02){
$modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["PROJECTID"] = $ROW_02["PROJECTID"];
$modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["COMMONNAME"] = $ROW_02["COMMONNAME"] ;
// $modelHash[$ROW_02["PRODUCTID"]][$ROW_02["PROJECTID"]]["DSPNO"] = $ROW_02["DSPNO"];
$strRes_02 .= "<OPTION VALUE=\"".$ROW_02["PROJECTID"]."\">".$ROW_02["COMMONNAME"]."</OPTION>\n" ;
}
$strRes_02 .= "</select>\n";
echo $strRes_02 ;
echo $strRes_01 ;?>
<script><?php
$cnt = count($modelHash)+1;
echo "var group=new Array($cnt);\n";
echo "group[0]=new Array();\n";
echo "group[0][0]=new Option(\"\",\"\");\n";
$i = 1;
foreach ($modelHash AS $modelRS){
echo "group[$i]=new Array();\n";
echo "group[$i][0]=new Option(\"\",\"\");\n";
$j = 1;
foreach ($modelRS AS $modelROW){
echo "group[$i][$j] = new Option(\"". $modelROW["COMMONNAME"] ."\", \"". $modelROW["PROJECTID"] . "\");\n";
$j++;
}
$i++;
}?>function redirect_init(){
//全件表示
var obj=document.<?php echo $FORMNAME;?>.lbl_PROJECTID;
for (m=obj.options.length-1;m>0;m--){
obj.options[m]=null
}
<?php
$i=0;
echo "obj.options[0] = new Option(\"\",\"\");\n";
foreach ($RS_02 AS $ROW_02){
echo "\tobj.options[$i+1]=new Option(\"".$ROW_02["COMMONNAME"]."\",\"".$ROW_02["PROJECTID"]."\");\n";
$i++;
} ?>
obj.options[0].selected=true
}function redirect(x){
//機種を分かれて表示
if (x == 0) {
redirect_init();
return;
}
var obj=document.<?php echo $FORMNAME;?>.lbl_PROJECTID;
for (m=obj.options.length-1;m>0;m--){
obj.options[m]=null
}
for (i=0;i<group[x].length;i++){
obj.options[i]=new Option(group[x][i].text,group[x][i].value)
}
obj.options[0].selected=true
}</script>
<?php}?>
是关于select菜单的
http://www.javascriptkit.com/javatutors/selectcontent.shtml