21,891
社区成员
发帖
与我相关
我的任务
分享如何实现在表单提交后，仍然保持菜单项上一次的状态,急急。在线等
要求实现在表单提交后，仍然保持菜单项上一次的状态。我的部分源代码如下，望高手指教，只有60分了，很急
<?
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>
<h3 align=center>手机及配件
<?
$query=" select to_char(sysdate,'yyyy-mm-')||'$SDAY' from dual ";
ora_parse($cur1,$query);
ora_exec($cur1);
$sj=ora_getcolumn($cur1,0);
echo '('.$sj.')' ;
?>
</h3>
<p> </p>
<table width="100%" border="1" align=center cellspacing="0" bordercolor="#000000" bordercolordark="#FFFFFF" cellpadding="1">
<tr>
<td bgcolor="#DDEEFF" height="22" colspan="12">ÊÖ»úÏúÊÛÇé¿ö:<? echo "$sname" ;?> </td>
</tr>
<tr>
<td align=center rowspan="2">Æ·ÅÆ</td>
<td align=center rowspan="2">»úÐÍ</td>
<td align=center rowspan="2">ÉÏÈÕ¿â´æ</td>
<td align=center rowspan="2">½ñÈÕÈë¿â</td>
<td colspan="4" align=center>ÏúÊÛÁ¿</td>
<td rowspan="2"> ÔÂÀÛ¼ÆÏúÊÛÁ¿ </td>
<td align=center rowspan="2">¿â´æºÏ¼Æ</td>
<td align=center rowspan="2">ÉÏÔ¿â´æ</td>
<td rowspan="2">±¾ÔÂÈë¿âÀÛ¼Æ</td>
<tr><td align=center>ÏúÊÛ</td><td align=center>ÔùËÍ</td><td align=center>ÆäËû</td><td align=center>С¼Æ</td> </tr>
<?
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>
<h3 align=center>手机及配件
<?
$query=" select to_char(sysdate,'yyyy-mm-')||'$SDAY' from dual ";
ora_parse($cur1,$query);
ora_exec($cur1);
$sj=ora_getcolumn($cur1,0);
echo '('.$sj.')' ;
?>
</h3>
<p> </p>
<table width="100%" border="1" align=center cellspacing="0" bordercolor="#000000" bordercolordark="#FFFFFF" cellpadding="1">
<tr>
<td bgcolor="#DDEEFF" height="22" colspan="12">ÊÖ»úÏúÊÛÇé¿ö:<? echo "$sname" ;?> </td>
</tr>
<tr>
<td align=center rowspan="2">Æ·ÅÆ</td>
<td align=center rowspan="2">»úÐÍ</td>
<td align=center rowspan="2">ÉÏÈÕ¿â´æ</td>
<td align=center rowspan="2">½ñÈÕÈë¿â</td>
<td colspan="4" align=center>ÏúÊÛÁ¿</td>
<td rowspan="2"> ÔÂÀÛ¼ÆÏúÊÛÁ¿ </td>
<td align=center rowspan="2">¿â´æºÏ¼Æ</td>
<td align=center rowspan="2">ÉÏÔ¿â´æ</td>
<td rowspan="2">±¾ÔÂÈë¿âÀÛ¼Æ</td>
<tr><td align=center>ÏúÊÛ</td><td align=center>ÔùËÍ</td><td align=center>ÆäËû</td><td align=center>С¼Æ</td> </tr>
...全文
请发表友善的回复…
发表回复
wf8010 2003-09-12
- 打赏
- 举报
<? 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="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'); ?>
手机品牌和手机机型是两个动态变化的选择列表框，其中机型的值随品牌的值在变化，已经实现，主要是手机的机型太多，每一次选了品牌和机型并且提交后都回到第一个状态，造成录入数据的很不方便，望高手指教，以实现需求。
