二级联动 子菜单 下拉菜单 COMBOBOX 下拉列表框
<html> www.shengfang.org
<HEAD>
<title>例子</title> www.shengfang.org
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<?php www.shengfang.org
require_once('./adodb/ADOdb-errorhandler.inc.php');
require_once("./adodb/ADOdb.inc.php");
require_once('./adodb/tohtml.inc.php');
$conn = &ADONewConnection('mysql'); # create a connection
$conn->PConnect('localhost','root','123','bill');# connect to MySQL, agora db
$id=18; www.shengfang.org
$recordSet = &$conn->Execute('select departmentname,departmentid from departments where companyid = '.$id); www.shengfang.org
#print $recordSet->GetMenu("sdfsd","",false);
#rs2html($recordSet);
echo '<Script LANGUAGE=JavaScript>';
echo "var y=new Array();";
$i=0;
while (!$recordSet->EOF)
{ www.shengfang.org
#$smenu[] = $recordSet->fields[0];
$s=$recordSet->fields[0];
echo "y[$i]='$s';";
$i=$i+1;
$recordSet->MoveNext();
}
echo "</script>"; $id=18; www.shengfang.org
$recordSet = &$conn->Execute('select companyname,companyid from companys');
#print $recordSet->GetMenu("sdfsd","",false);
#rs2html($recordSet);
echo '<Script LANGUAGE=JavaScript>';
echo "var companyname=new Array();";
echo "var companyid=new Array();";
$i=0;
while (!$recordSet->EOF)
{ www.shengfang.org
#$smenu[] = $recordSet->fields[0];
$s=$recordSet->fields[0];
echo "companyname[$i]='$s';";
$s=$recordSet->fields[1];
echo "companyid[$i]='$s';";
$i=$i+1;
$recordSet->MoveNext();
} www.shengfang.org
echo "</script>";
?>
<SCRIPT LANGUAGE="JavaScript">
function qwer2()
{
with (document)
{ www.shengfang.org
for(i=all("mmenu").options.length;i>=0;i--)
{
all("mmenu").options.remove(i); //需要清除原有的项目
}
for(i=0;i<companyname.length;i++)
{
obj1=document.createElement("option");
obj1.text=companyname[i];
obj1.value=companyid[i];
all("mmenu").options.add(obj1);
}
} www.shengfang.org
}
function qwer()
{ www.shengfang.org
with (document)
{
for(i=all("smenu").options.length;i>=0;i--)
{
all("smenu").options.remove(i); //需要清除原有的项目
}
for(i=0;i<y.length;i++)
{ www.shengfang.org
obj=document.createElement("option");
obj.text=y[i];
all("smenu").options.add(obj);
}
}
}
</script> </script><select name="mmenu" onChange="javascript:qwer(1)">
</select>
<SCRIPT LANGUAGE="JavaScript">
qwer2();
</script>
<select name="smenu"> //子菜单设计
</select> www.shengfang.org
<input name='sf' >
</html>
字体：大 中 小 |
2005年10月26日16:18星期三 [Dev开发] 
