作者lycapei (pei)
看板PHP
标题[请益] PHP与JS的二层关联式选单
时间Fri Aug 13 15:59:41 2010
写了一个会从资料库抓出数值
再塞入二层关联式的测试程式
但是只抓得到第一个的资料
之後的都不行
想请问一下问题在哪...
谢谢
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5" />
<title>无标题文件</title>
</head>
<body>
<?
if($_POST[place]){
echo $_POST[place];
}
else{
?>
<FORM action="purchase.php" method="post" name=doublecombo>
<SELECT name=example onchange=redirect(this.options.selectedIndex) size=1>
<?php
$sqllink =mysql_connect("localhost","帐号","密码");
mysql_query('SET NAMES big5');//资料库传过来的语言设成big5
$action="select * from college order by sn ";
$result=mysql_db_query("oga_purchase",$action,$sqllink);
while($sqlresult=mysql_fetch_array($result)){
echo "<option>".$sqlresult[name]."</option>";
}
?>
</SELECT>
<SELECT name=place size=1>
<?php
$sqllink =mysql_connect("localhost","帐号","密码");
mysql_query('SET NAMES big5');//资料库传过来的语言设成big5
$action="select * from college order by sn ";
$result=mysql_db_query("oga_purchase",$action,$sqllink);
$sqlresult=mysql_fetch_array($result);
$first=$sqlresult[name];
/*以上先捞出资料库中大项目的第一笔*/
$sqllink =mysql_connect("localhost","帐号","密码");
mysql_query('SET NAMES big5');//资料库传过来的语言设成big5
$action="select * from collegeunit where belong='{$first}' order by sn ";
$result=mysql_db_query("oga_purchase",$action,$sqllink);
while($sqlresult=mysql_fetch_array($result)){
echo "<option>".$sqlresult[name]."</option>";
}
?>
</SELECT>
<SCRIPT language=JavaScript>
var groups=document.doublecombo.example.options.length
var group=new Array(groups)
for (i=0; i<groups; i++)
group[i]=new Array()
</SCRIPT>
<?php
echo "<SCRIPT language=JavaScript>";
$sqllink =mysql_connect("localhost","帐号","密码");
mysql_query('SET NAMES big5');//资料库传过来的语言设成big5
$action="select * from college order by sn ";
$result=mysql_db_query("oga_purchase",$action,$sqllink);
$i=0;
$j=0;
while($sqlresult=mysql_fetch_array($result)){
$sqllink2 =mysql_connect("localhost","帐号","密码");
mysql_query('SET NAMES big5');//资料库传过来的语言设成big5
$action2="select * from collegeunit where belong='{$sqlresult[name]}' order
by sn ";
$result2=mysql_db_query("oga_purchase",$action2,$sqllink2);
while($sqlresult2=mysql_fetch_array($result2)){
echo "group[$i][$j]=new Option('$sqlresult2[name]');";
$j++;
}
$i++;
}
echo "</script>";
$j=0;
?>
<SCRIPT language=JavaScript>
var temp=document.doublecombo.place
function redirect(x){
for (m=temp.options.length-1;m>0;m--)
temp.options[m]=null
for (i=0;i<group[x].length;i++){
temp.options[i]=new Option(group[x][i].text,group[x][i].value)
}
temp.options[0].selected=true
}
</SCRIPT>
<input name="送出" type="submit" value="送出" />
</FORM>
<?php
} //还没选
?>
</body>
</html>
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.115.228.177