📄 topic_que.php

📁 本书主要介绍了从基础开始建立Portal的快速应用开发过程（RAD）的方法。通过本书你可以了解到关于Oracle 9iAS Portal产品的主要特性、入口的开发和组织、网络开发和管理、实际的关系型数
💻 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"){

	$sqldo="select spec_layer from basespec where spec_id=$sid";
	$res_array=$cla->db_query($sqldo);
	//$result=mysql_query($sqldo);
	//$res_array=mysql_fetch_array($result);
	$temp=$res_array[0][0];
   // echo "res_array[0]:".$res_array[0];
   // echo "temp:".$temp;
	$sqldo="select spec_id,tabindex from basespec where spec_layer='$temp' and spec_father='$pid'";
	$res_array=$cla->db_query($sqldo);
	$i=0;	
	//$result=mysql_query($sqldo);
	//while($res_array=mysql_fetch_array($result)){
	while($res_array[$i][0]){
        $temp1=${text.$res_array[$i]["SPEC_ID"]};
		if($temp1==""){
		$temp1=250;
		}
		$spec_id=$res_array[$i]["SPEC_ID"];
		$sqldo="update basespec set tabindex=$temp1 where spec_id=$spec_id";
	//	echo $sqldo;
	
	// mysql_query($sqldo);
	$cla->db_update($sqldo);

	$i++;    
      }
    $cla->db_commit();
}
?>
      <form name="form1" method="post" action="?action=que&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);
	    //$result=mysql_query($sqldo);
	    //$res_array=mysql_fetch_array($result);   
            ?>
	   <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_layer from basespec where spec_id='$sid'";
	$res_array=$cla->db_query($sqldo);	
	//$result=mysql_query($sqldo);
	//$res_array=mysql_fetch_array($result);
	$temp=$res_array[0][0];
   // echo "temp:".$temp;
	$sqldo="select spec_id,spec_name,tabindex from basespec where spec_layer='$temp'  and spec_father='$pid' order by tabindex ";
	$res_array=$cla->db_query($sqldo);
	//$result=mysql_query($sqldo);
	$i=0;	
	while($res_array[$i][0]){	
	//while($res_array=mysql_fetch_array($result)){
		
    ?>
                      <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']<>250){ echo $res_array[$i]['TABINDEX']; }?>">
                          </div>
                        </td>
                        <td height="15" bgcolor="#f7f7f7" width="359"> 
                          <div align="center"> 
                            <?echo $res_array[$i]['SPEC_NAME'];?>
                          </div>
                        </td>
                      </tr>
                      <? $i++; }?>
                    </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>
💿 文件大小 21905 K
👤 上传用户 foresnake
📂 所属分类 Oracle数据库
🏷️ 相关标签

#Portal #Oracle #9iAS #RAD
⌨️ 快捷键说明

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