高人救命啊,在线等。关于下拉列框问题,
要求实现在表单提交后,仍然保持菜单项上一次的状态。我的部分源代码如下,望高手指教<? if($plan==$plorder) $aaa="selected" ;?>
<td align="center">手机品牌 <select size="1" name="plan" ONCHANGE ="insert(form1.plan,form1.type,IdArr,TextArr)">
<? echo "<option value='$plorder' $h1>$plname</option>";?>
</select>
</td>
<? if($type==$tyorder) $bbb="selected" ;?>
<td align="center">手机机型 <select size="1" name="type">
<? echo "<option value='$tyorder' $h2>$tyname</option>";?>
</select>
<? selectarr1('form1.plan'); ?>
手机品牌和手机机型是两个动态变化的选择列表框,其中机型的值随品牌的值在变化,已经实现,主要是手机的机型太多,每一次选了品牌和机型并且提交后都回到第一个状态,造成录入数据的很不方便,望高手指教,以实现需求。我试了很多方法,好象都不行,
<?
require("../Include/userfunctions.php3");
require("../Include/DBConnect.php3");
MustLogin();
$cur=ora_open($conn);
$cur1=ora_open($conn);
$query=" select mobile_id from sf_mobile_type ";
$query.= " where mobile_plan='$plan' and mobile_order='$type' ";
ora_parse($cur,$query);
ora_exec ($cur);
while(ora_Fetch($cur)){
$mblid=ora_getcolumn($cur,0) ;
}
if($submit1=="添加") {
$query=" select a.mobile_name,b.mobile_name,a.mobile_order,b.mobile_order from sf_mobile_plan a ,";
$query.= "sf_mobile_type b where b.mobile_id='$mblid' and b.mobile_plan=a.mobile_order ";
ora_parse($cur,$query);
ora_exec ($cur);
$plname= ora_getcolumn($cur,0) ;
$tyname=ora_getcolumn($cur,1) ;
$plorder=ora_getcolumn($cur,2) ;
$tyorder=ora_getcolumn($cur,3) ;
}
//
$query=" select ID,NAME FROM SF_MOBILE_SELL_TYPE where ID='$global_user_id' " ;
ora_parse($cur,$query);
ora_exec ($cur);
while(ora_Fetch($cur)){
$sid=ora_getcolumn($cur,0);
$sname=ora_getcolumn($cur,1);
}
if($global_user_id=='579111')
$indept='1';
else $indept='2';
if($submit1=="添加")
{
//echo $mblid ;
//echo '('.$plan.')';
//echo $type;
//echo '('.$indept.')';
$query=" select count(*) from sf_mobile_sell_type where id='$global_user_id' ";
ora_parse($cur,$query);
ora_exec($cur);
if(ora_getcolumn($cur,0)==1)
{
if($numb==0){echo "<font color=red>对不起,请输入数量</font>"; }
else{
$query=" insert into SF_MOBILE_SELL_RECORD(ID,MOBILE_ID,NOW_IN_DEPT,OPER_TYPE,CREATE_DATE,NUM) ";
$query.=" values('$sid','$mblid','$indept', '$oper' , to_char(sysdate,'yyyy-')||'$SMONTH-'||'$SDAY','$numb')" ;
//echo $query;
ora_parse($cur,$query);
ora_exec ($cur);
}
}
else echo "<font color=red>对不起,您无权限录入!</font>";
}
if($submit2=="删除")
{
$query=" delete from SF_MOBILE_SELL_RECORD where " ;
$query.= " id='$global_user_id' and mobile_id='$mblid' and oper_type='$oper' ";
$query.=" and create_date=to_char(sysdate,'yyyy-')||'$SMONTH-'||'$SDAY' and num=$numb ";
// echo $query;
ora_parse($cur,$query);
ora_exec ($cur);
}
?>
<html>
<body>
<form name=form1 action="<? echo $PHP_SELF ;?>" method=post>
<tr>
<? if($plan==$plorder) $aaa="selected" ;?>
<td align="center">手机品牌 <select size="1" name="plan" ONCHANGE ="insert(form1.plan,form1.type,IdArr,TextArr)">
<? echo "<option value='$plorder' $h1>$plname</option>";?>
</select>
</td>
<? if($type==$tyorder) $bbb="selected" ;?>
<td align="center">手机机型 <select size="1" name="type">
<? echo "<option value='$tyorder' $h2>$tyname</option>";?>
</select>
<? selectarr1('form1.plan'); ?>
<td align="center"> 月份 <select size="1" name="SMONTH">
<?
$query="select to_char(sysdate,'mm') from dual";
ora_parse($cur,$query);
ora_exec ($cur);
$mm=ora_getcolumn($cur,0);
$M=$mm;?>
<option selected value=<? echo $M;?>><? echo $M ;?></option>
<?
$query="select to_char(sysdate-2,'mm') from dual";
ora_parse($cur,$query);
ora_exec ($cur);
$mm1=ora_getcolumn($cur,0);
$M1=$mm1;
?>
<option value= <? echo $M1;?>><? echo $M1 ;?></option>
</select>
<td align="center">日期 <select size="1" name="SDAY">
<?
$query="select to_char(sysdate,'dd') from dual";
ora_parse($cur,$query);
ora_exec ($cur);
$dd=ora_getcolumn($cur,0);
$D=$dd;?>
<option value=<? echo $D;?>><? echo $D ;?></option>
<?
$query="select to_char(sysdate-1,'dd') from dual";
ora_parse($cur,$query);
ora_exec ($cur);
$dd1=ora_getcolumn($cur,0);
$D1=$dd1;
?>
<option value= <? echo $D1;?>><? echo $D1 ;?></option>
<?
$query="select to_char(sysdate-2,'dd') from dual";
ora_parse($cur,$query);
ora_exec ($cur);
$dd2=ora_getcolumn($cur,0);
$D2=$dd2;
?>
<option value=<? echo $D2; ?>><? echo $D2 ;?></option>
</select>
</td> <p><td align="center"> 方式 <select size="1" name="oper" >
<option value="1">入库</option>
<option value="2">出库</option>
<option value="3">销售</option>
<option value="4">赠送</option>
<option value="5">其他</option>
</select> </td>
<td align="center">数量
<input type="text" name="numb" size=8>
<input type="hidden" name="h1" value=<? echo $aaa ;?>>
<input type="hidden" name="h2" value=<? echo $bbb ;?>>
<input type="submit" name="submit1" value="添加" >
<input type="submit" name="submit2" value="删除">
<input type="submit" name="submit3" value="查询">
</tr>
<p></p>
<p></p>
.
.
.
.
.
.
.
.