select 传值

最新推荐文章于 2023-12-22 21:41:52 发布

lukylfm

最新推荐文章于 2023-12-22 21:41:52 发布

阅读量1.1k

点赞数

文章标签： sql include border user action function

<? include("../include/opendb.php");
$sql="select username from user group by username order by id desc";
$rs=execute($sql);$row=numrows($rs);
?>
<script>
function selectsubmit(form){
var username="<?echo $username;?>";
window.location="a_controlmag.php?active=up&mselt="+mselt+"&username="+username;
}
</script>
<body><form name="form" method="post" action="">
<table width="100%" border="1" align="center">
<tr><td width="10%">username</td><td width="30%">modify</td></tr>
<?while($row = fetcharray($rs)){?>
<tr><td><?=$row[username]?></td>
<?$sql1="select username from user where username = $row[username] ";
$rs1=execute($sql1);$row1=numrows($rs1);
?>
<td>
<input type="hidden" name="username" value="<?echo $row[username] ;?>">
<select name="mselt" id="select" onchange="selectsubmit(this.form);">
<option value="0" <?if($row1=="0"){echo "selected";}?>>closed</option>
<option value="1" <?if($row1=="1"){echo "selected";}?>>opened</option>
</select></td>
</tr><?}?></table></form></body>
请问点击选择框后如何得到mselt和username的值