//PHP部分:
//取得下拉联动数据
require("conn.php");
$result=mysql_query("SELECT * FROM units LEFT JOIN users ON (users.unit=units.unid)");
$mx=mysql_num_rows($result);
for ($i=0;$i
$r=mysql_fetch_array($result);
$uname=$r['uname'];
$unid =$r['unid'];
$usname=$r['username'];
$usid=$r['userid'];
if ($lasun!=$uname) {
$java1=$java1 . ""$uname",";
$java2=$java2 . ""$unid",";
$lasun=$uname;
if ($i>0) {
$java3=$java3 . "],[";
$java4=$java4 . "],[";
}
} else {
$java3=$java3 . ",";
$java4=$java4 . ",";
}
$java3= $java3 . ""$usname"";
$java4= $java4 . ""$usid"";
}
$java1="[" . substr_replace($java1,"",-1) . "]n";
$java2="[" . substr_replace($java2,"",-1) . "]n";
$java3="[[" . $java3 . "]]n";
$java4="[[" . $java4 . "]]n";
//javascript部分
?>
<script> <br />
var fMenu = <?=$java1?> <br />
var fValue = <?=$java2?> <br />
var sMenu = <?=$java3?> <br />
var sValue = <?=$java4?> <br />
<br />
var oWhere = document.all.tar; <br />
var ofMenu = document.createElement("<SELECT name='unid'>"); <br />
var osMenu = document.createElement("<SELECT name='usid'>"); <br />
with(oWhere)appendChild(ofMenu),appendChild(osMenu); <br />
<br />
createMainOptions(); <br />
createSubOptions(0); <br />
<br />
ofMenu.onchange = function() {createSubOptions(this.selectedIndex);}; <br />
<br />
function createMainOptions() { <br />
for(var i=0;i<fMenu.length;i++)ofMenu.options[i] = new Option(fMenu[i],fValue[i]); <br />
} <br />
function createSubOptions(j) { <br />
with(osMenu) { <br />
length=0; <br />
for(var i=0;i<sMenu[j].length;i++)osMenu.options[i] = new Option(sMenu[j][i],sValue[j][i]); <br />
} <br />
} <br />
<br />
function checkuser() { <br />
if (document.forms[1].elements[1].value=="") { alert("没有选择用户"); return false; } <br />
} <br />
</script>