POST['Endtime']!="") $where = " AND OPERATE_TIME>=to_date('".<?php if(
___FCKpd___0
菜单级联:
<script language="JavaScript"> function change_couty_list() { if(document.form1.sel_devwr_county_countyid.options[0].selected==true) { document.form1.sel_devwr_linecenter_lid.length=0; //清空select option opt = document.createElement("option"); opt.text="选择全部"; opt.value="ALL"; document.form1.sel_devwr_linecenter_lid.add(opt); } else { document.form1.sel_devwr_linecenter_lid.length=0; count_contyidsel=document.form1.sel_devwr_county_countyid.length; var str_contyid=""; for(i=1;i<count_contyidsel;i++) { if(document.form1.sel_devwr_county_countyid.options[i].selected==true) { str_contyid+=document.form1.sel_devwr_county_countyid.options[i].value+","; } } str_contyid=str_contyid.substr(0,str_contyid.length-1); frame_lid.location.href = "Devwr_Countyid_select.php?contyidlist=" + str_contyid; } } </script>
//----------------------------------------------------------------
传值:
<script language="javascript"> function show_info(){ countyid_select=document.getElementById("sel_devwr_county_countyid").value; lid_select=document.getElementById("sel_devwr_linecenter_lid").value; // alert(1); userid=document.getElementById("userid").value; // alert(2); accesslevel=document.getElementById("accesslevel").value; // alert(3); countyid=document.getElementById("countyid").value; // alert(4); lid=document.getElementById("lid").value; // alert(5); str="userid="+userid+"&accesslevel="+accesslevel+"&countyid="+countyid+"&lid="+lid+"&countyid_select="+countyid_select+"&lid_select="+lid_select; var s=Math.random(); document.getElementById("info").src="Devwr_Finished_List.php?s="+s+"&"+str; // alert(6); //alert(document.getElementById("info").src); // alert(7); document.getElementById("datalist").style.display="inline"; // alert(123); } </script>
传值:
隐藏传值:
<?PHP require_once("../conn.php");//连接数据库 $stmt=ociparse($conn,$strsql); ociexecute($stmt); while(ocifetchinto($stmt,$result)) //通过循环读取数据内容 { ?> <tr bgcolor="#FFFFFF"> <td align="center" nowrap><?=$result["0"]?></td> <td align="center" nowrap><?=$result["1"]?></td> <td align="center" nowrap><?=$result["2"]?></td> <td align="center" nowrap><?=$result["3"]?></td> <td align="center" nowrap><?=$result["4"]?></td> <td align="center" nowrap><?=$result["5"]?></td> <td style="display:none" align="center" nowrap><?=$result["6"]?></td> <td style="display:none" align="center" nowrap><?=$result["7"]?></td> <td align="center" nowrap> <a href="#" onClick="myupdate('Devwr_Update.php?userid=<?=$result["0"]?>&devid=<?=$result["2"]?>&devtype=<?=$result["3"]?> &countyid=<?=$result["6"]?>&lid=<?=$result["7"]?>');"> 修改</a> <a href="#" onClick="del('Devwr_Dele.php?&devid=<?=$result["2"]?>');" >删除</a> </td> </tr> <?PHP } //上面字段一次是style="display:none"://userid//username//deviceno//devtype//countyname//address//countyid//lid //关闭对数据库的连接 ocilogoff($conn); ?>
//--------------------------------------------------------------------------
POST['chaxun']=="查 询") { if (<input type="hidden" id="devid" name="devid" value="<?=$devid?>"> <input type="hidden" id="devtype" name="devtype" value="<?=$devtype?>"> <input type="hidden" id="userid" name="userid" value="<?=$userid?>"> <input type="hidden" id="countyid" name="countyid" value="<?=$countyid?>"> <input type="hidden" id="lid" name="lid" value="<?=$lid?>">
___FCKpd___0
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8
___FCKpd___0
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8
POST['Starttime']."', 'yyyy-mm-dd')"; if (
___FCKpd___0
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8
POST['Endtime']!="") $where.=" AND OPERATE_TIME<=to_date('".
___FCKpd___0
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8
POST['Endtime']."', 'yyyy-mm-dd')"; if(
___FCKpd___0
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8
POST['OPERATE']!="0") { $where.=" and OPERATE_TYPE='$OPERATE'" ; } if($account!="") { $where.=" and account='$account' "; } $where.=" and yyq_bh='$yyq_bh' and department='$department' and rownum<=1000 "; $sql = "select ACCOUNT,DEPARTMENT,decode(OPERATE_TYPE,'1','修改','2','删除','3','添加','其他'),CONTENT,OPERATE_TIME from system_log WHERE OPERATE_TYPE IS NOT NULL".$where; $stmt = OCIParse($conn, $sql); if(!$stmt) { echo "Oracle Connect Error"; exit; } OCIExecute($stmt); $temp=0; while(OCIFetchInto($stmt,$total_rows)) { $temp++; ?> <tr bgcolor="white"> <td align="center" nowrap><?=$total_rows[0]?></td> <td align="center" nowrap><?=$total_rows[1]?></td> <td align="center" nowrap><?=$total_rows[2]?></td> <td nowrap width="350"><?=$total_rows[3]?></td> <td nowrap align="center"><?=$total_rows[4]?></td> </tr> <?php } OCIFreeStatement($stmt); OCILogoff($conn); if ($temp==0) echo "<script language=javascript>alert('没有满足条件的日志记录!');</script>"; } ?>
菜单级联:
___FCKpd___1
___FCKpd___2
___FCKpd___3
___FCKpd___4
___FCKpd___5
传值:
隐藏传值:
___FCKpd___6
___FCKpd___7
___FCKpd___8