📄 topic_conque.php

📁 Oracle源码：Oracle 数据库管理与应用系统开发代码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
require "inc/check.php";
    require "inc/func.php";
    require "inc/error.php";
?>
<html>
<head>
<title>“天勤”网站后台管理系统</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>
<?

				
if($cmd){ //如果添加NEWGIVER   

    /*    
    标题: %标题%
    作者：%作者%
    译者：%译者% 
    来源：%来源%
    正文内容：%内容% 
    加入时间：%时间%     
    相关链接：%链接%   
    */                //生成sql语句
                 $sqldo_head="select topicid,tabindex from topic ";
				 $sqldo_head_c="select count(*) from topic ";
				 $sqldo_cont="";
				// echo "topicsel".$topicsel;
				 if($topicsel or $sertime ){
			    	 $sqldo_cont.="where ";
				 }
				 if($topicsel){
				     $sqldo_cont.=" spec_id='$topicsel'  ";
				 }
				 if($sertime and $topicsel){
				     $datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
				     $sqldo_cont.="and datechar>'$datetime'  ";
				 }elseif($sertime){
				     $datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
				     $sqldo_cont.=" datechar>'$datetime'  ";
				 }
				 $sqldo_cont.="  order by topicid desc ";
				 $sqldo_s=$sqldo_head.$sqldo_cont;
				// echo "sqldo".$sqldo_s."end";
				 $sqldo=$sqldo_s;
				 $sqldo_c=$sqldo_head_c.$sqldo_cont;
	             $res_array=$cla->db_query($sqldo);
	             $i=0;	
	             while($res_array[$i][0]){
                     $temp1=trim(${text.$res_array[$i]["TOPICID"]});
		             if($temp1==""){
	                	$temp1=250;
		              }
		            $topicid=$res_array[$i]["TOPICID"];
		            $sqldo="update topic set tabindex='$temp1' where topicid=$topicid";
	                $cla->db_update($sqldo);
                    $i++;    
                 }
                 $cla->db_commit();
            }
			
    if($action=="del"){
	       $cmdsearc="搜索";
           $sqldo="delete from topic where topicid='$topicid'";
	       $cla->db_delete($sqldo);
	       $cla->db_commit();
    }			
   ?>



<!-- search code begin -->
    <SCRIPT LANGUAGE="JavaScript">
    function chg_manu(ser_type){
        var subobj=document.form2.ser_type;
		alert(subobj.value);
        if(""==subobj.value){
           //     if(-1!=(subobj.options[subobj.selectedIndex].text.indexOf("所有"))) return;
            //    subobj.options[subobj.selectedIndex+1].selected=true;
             //   chg_manu(subobj.options[subobj.selectedIndex].value);
              //  return;
        }
        document.list_manu.location="list_manu.php?ser_type=group_name";
    }
    </SCRIPT>
<center>

  <div align="center">
    <table width="100%" border="0" height="95">
      <tr> 
        <td width="75%" height="68" rowspan="5"> 

          <form name="form2" method="post" action="">
            <table width="100%" border="0" height="109">
              <tr> 
                <td width="7%" height="59">&nbsp;</td>
                <td width="86%" height="59" valign="middle"> 
                  <table width="754" border="1" cellpadding="3" cellspacing="0" align="center" bordercolor="#111111" class=border>
                    <tr > 
                      <td height="20" width="174"> 
                        <div align="center"></div>
                        <div align="center"><font color="#000000">时间限制</font></div>
                      </td>
                      <td width="562" height="20"> 
                        <div align="center"><font color="#000000">专题</font></div>
                      </td>
                    </tr>
                    <tr bgcolor="#f7f7f7"> 
                      <td width="174" > 
                        <div align="center"> </div>
                        <div align="center"> 
                          <select name="sertime" size="1">
                            <option value="7">7天之内</option>						  
                            <option value="3">3天之内</option>
                            <option value="30">一月之内</option>
                            <option value="180">半年之内</option>
                            <option value="">任何时间</option>							
                          </select>
                        </div>
                      </td>
                      <td width="562"> 
                        <div align="center"> 
                          <select name="topicsel">
                            <?
				$sqldo="select spec_id,spec_name from basespec where spec_layer=2";
				$result_array=$cla->db_query($sqldo);
				$i=0;
				$old=$result_array[$i][0];
				while($result_array[$i][0]){
				$temp1=$result_array[$i][0];
				$temp1_name=strip_tags($result_array[$i]["SPEC_NAME"]);
				
				$sqldo_in="select spec_id,spec_name from basespec where spec_father='$temp1'";
				$result_array_in=$cla->db_query($sqldo_in);
				$j=0;
				
				
				$flg1=0;
				if($result_array_in[$j][0]==""){//如果是空，也显示一次，即将第二级专题显示出来
				$flg1=1;
				}				
				while($result_array_in[$j][0] or $flg1){	
				
				$temp2=$result_array_in[$j][0];
				$temp2_name=strip_tags($result_array_in[$j]["SPEC_NAME"]);	
					
				$sqldo_in_in="select spec_id,spec_name from basespec where spec_father='$temp2'";
				$result_array_in_in=$cla->db_query($sqldo_in_in);
				$k=0;
				$flg2=0;
				if($result_array_in_in[$k][0]==""){//如果是空，也显示一次，即将第三级专题显示出来
				$flg2=1;
				}				
				while(($result_array_in_in[$k][0]<>"") or ($flg2<>0) or ($flg1<>0)){	
				$temp3=$result_array_in_in[$k]['SPEC_ID'];
				$temp3_name=strip_tags($result_array_in_in[$k]['SPEC_NAME']);				
                ?>
                            <option value=<? if($temp3){echo $temp3;}elseif($temp2){echo $temp2;}elseif($temp1){echo $temp1;}?>> 
                            <? echo "$temp1_name";if($temp2_name){ echo ".$temp2_name";if($temp3_name) echo".$temp3_name";}
					        ?>
                            </option>
                            <?
						
							$flg1=0; $flg2=0; $k++;}//第四级
							$j++;}//第三级
				             ?>
                            <option value="">*************************************************************</option>
                            <? 							
							$old=$result_array[$i][0];$i++;}//第二级
							?>
                          </select>
                        </div>
                      </td>
                    </tr>
                  </table>
				
                  <div align="right"></div>
                </td>
                <td width="7%" valign="middle" height="59"><font color="#000000"> 
                  <input type="submit" name="cmdsearc" value="搜索" >
                  </font></td>
              </tr>

            </table>
          </form>

        </td>
      </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr> </tr>
      <tr>
        <td width="75%" height="70" valign="top"> 

          <div align="right"> 
            <table width="84%" border="0" align="center">
              <tr> 
                <td colspan="3"> 

                  <form name="form1" method="post" action="">
                    <table width="84%" border="0" align="center">
                      <tr> 
                        <td colspan="3"> 
                          <div align="right"> </div>
                          <?
			  if(($cmdsearc=="搜索")or($temp==1)){ //如果搜索
                 $sqldo_head="select topicid,newsid,uploader,datechar,tabindex from topic ";
				 $sqldo_head_c="select count(*) from topic ";
				 $sqldo_cont="";
12 下一页
💿 文件大小 11628 K
👤 上传用户 liu4052032
📂 所属分类 Oracle数据库
🏷️ 相关标签

#Oracle #源码 #数据库管理 #应用系统
⌨️ 快捷键说明

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