⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 topic_que2.php

📁 Oracle源码:Oracle 数据库管理与应用系统开发代码
💻 PHP
字号:
<? 
require "inc/check.php";
require "inc/func.php";
require "inc/error.php";
//check_login();
?>
<html>
<head>
<script language="JavaScript">
function loadframes()
{
parent.leftFrame.location.href="menu2.php"
}
</script>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px; scrollbar-face-color: ffffff; scrollbar-shadow-color: C1C1BB; scrollbar-highlight-color: C1C1BB; scrollbar-3dlight-color: EBEBE4; scrollbar-darkshadow-color: EBEBE4; scrollbar-track-color: F4F4F0; scrollbar-arrow-color: CACAB7
}
P {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
INPUT {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FONT {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
SELECT {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
OPTION {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TEXTAREA {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FORM {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TD {
	FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
A:link {
	TEXT-DECORATION: none
}
A:visited {
	TEXT-DECORATION: none
}
A:hover {
	TEXT-DECORATION: underline
}
A:active {
	FONT-SIZE: 12px; TEXT-DECORATION: none
}
.border {
	BACKGROUND-COLOR: #efefef; BORDER-BOTTOM: 1px dotted; BORDER-COLLAPSE: collapse; BORDER-LEFT: 1px dotted; BORDER-RIGHT: 1px dotted; BORDER-TOP: 1px dotted; COLOR: #000000
}
.shadow1 {
	COLOR: #ffffff; FILTER: dropshadow(color=#000000,offx=1,offy=1); FONT-SIZE: 12px
}
.shadow2 {
	COLOR: #000000; FILTER: dropshadow(color=#d5d5d5,offx=1,offy=1); FONT-SIZE: 12px
}
.p1 {
	COLOR: #ffffff; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p2 {
	COLOR: #000000; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p3 {
	COLOR: #004080; FONT-SIZE: 14px; TEXT-DECORATION: none
}
</STYLE>
</head>

<body bgcolor="#FFFFFF" text="#000000"  >
<table width="80%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolor="#c0c0c0">
  <tr bgcolor=""> 
    <td class="head-2" height="27" bgcolor="#FFFFFF"><b><font size="2" color="#cae4ff"> </font></b> 
      <div align="center"><font color="#FFFFFF"><a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0">增加同类</a> 
        <a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0"></a> 
        <a href="topic_addx.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>">增加下类</a> 
        <a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0"></a><a href="topic_edit.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>">修改本类</a> 
        <a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0"></a><a href="topic_del.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>">删除本类</a> 
        <a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0"></a><a href="topic_que.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>">同类排序</a> 
        <a href="topic_adds.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>"><img src="images/edit.gif"  width="18" height="13" border="0"></a><a href="topic_que2.php?sid=<?echo $sid;?>&pid=<?echo $pid;?>">统一排序</a>
		   <font color="#000000" >&nbsp;&nbsp;&nbsp;&nbsp;<a href="#" onClick="loadframes()">刷新</a></font> 
        </font></div>
    </td>
  </tr>
</table>
<table width="100%" border="0">
  <tr> 
    <td width="14%">&nbsp;</td>
    <td width="73%"> 
      <?
   // if($sid==""){
//	show_msg("请先选择专题!");
	//}
if($action=="que_all"){

	$sqldo="select spec_id  from basespec ";
	$res_array=$cla->db_query($sqldo);
	$i=0;	
	while($res_array[$i][0]){
        $temp1=trim(${text.$res_array[$i]["SPEC_ID"]});
		if($temp1==""){
		$temp1=250;
		}
		$spec_id=$res_array[$i]["SPEC_ID"];
		$sqldo="update basespec set tabindex_all='$temp1' where spec_id=$spec_id";
	    //echo $sqldo;
	   $cla->db_update($sqldo);
	  $i++;    
        }
       $cla->db_commit();
        }
      ?>
      <form name="form1" method="post" action="?action=que_all&sid=<?echo $sid;?>&pid=<?echo $pid;?>">
        <table width="95%" border="0">
          <tr>
            <td height="150"> 
              <table width=550 border=0 cellpadding=0 align=center bordercolorlight=000000 bordercolordark=000000 bordercolor=FFFFFF>
                <tr bordercolor=FFFFFF> 
                  <td align=left bgcolor=""> 
                    <table  border=1 cellspacing=0 cellpadding=5 width=550 bordercolor=#111111 class=border >
                      <tr> 
                        <td height="7" colspan="2"> 
                          <div align="center"></div>
                          <div align="center"><font color="#000000" size="10"><b><font size="4">当前专题:</font></b></font><font color=#FFFFF size=10><b><font size="4"> 
                       <?    
	    $sqldo="select spec_name from basespec where spec_id='$sid'";
	    $res_array=$cla->db_query($sqldo);
            ?>
	   <font size="4" color="#000000">  <?echo  $res_array[0][0];?> </font><font size="4">  
   
                         </font></b></font></div>
                        </td>
                      </tr>
                      <tr bgcolor=""> 
                        <td height="8" bgcolor="" width="165"> 
                          <div align="center">次序</div>
                        </td>
                        <td height="8" bgcolor="" width="359"> 
                          <div align="center">专题名</div>
                        </td>
                      </tr>
                      <?	
   
	$sqldo="select spec_id,tabindex_all,spec_name from basespec order by tabindex_all";
	$res_array=$cla->db_query($sqldo);	
	$i=0;
	while($res_array[$i][0]){
	$temp=$res_array[$i][0];
	$sqldo_in="select spec_id from basespec where spec_father='$temp'";
	$res_array_in=$cla->db_query($sqldo_in);	
	if(!$res_array_in[0][0]){ //如果没有字专题,则显示
    ?>
                      <tr> 
                        <td height="15" bgcolor="#f7f7f7" width="165"> 
                          <div align="center"> 
                            <input type="text" name="text<? echo $res_array[$i]['SPEC_ID'];?>" size="2" value= "<? if($res_array[$i]['TABINDEX_ALL']<>250){ echo $res_array[$i]['TABINDEX_ALL']; }?>">
                          </div>
                        </td>
                        <td height="15" bgcolor="#f7f7f7" width="359"> 
                          <div align="center"> 
                            <?echo $res_array[$i]['SPEC_NAME'];?>
                          </div>
                        </td>
                      </tr>
                      <? }  //   if结束
					  $i++; 
					  }     //  while 结束
					  ?>
                    </table>
                  </td>
                </tr>
              </table>
            </td>
          </tr>
        </table>
        <div align="center"> 
          <input type="submit" name="Submit" value="提交">
          <input type="submit" name="Submit2" value="重置">
        </div>
      </form>
    <td width="13%">&nbsp;</td>
  </tr>
  <tr> 
    <td width="14%">&nbsp;</td>
    <td width="73%">&nbsp;</td>
    <td width="13%">&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
<?$cla->db_logoff();?>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -