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

📄 topic_make2.php

📁 Oracle源码:Oracle 数据库管理与应用系统开发代码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
<?
require "inc/check.php";
require "inc/func.php";
require "inc/error.php";

//check_login();
?>
<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($cmdadd){ //如果添加
               
                 $sqldo="insert into topic values(topictopicid.nextval,newsid,spec_id,uploader,datechar,model) ";
				 if($sercont or $sertime or $seritem){
				 $sqldo.="where ";
				 }
				 if($sercont){
				 $sqldo.="(instr(newsname,'$sercont')>0 or instr(newstext,'$sercont')>0)  ";
				 }
				}
				
?>



<script language="JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<!-- search code begin -->
    <SCRIPT LANGUAGE="JavaScript">
    function checksubmit(cform){
		i = cform.obj.options[cform.obj.selectedIndex].value;
        cform.action=url_arr[i][1];
		for(j=2;j<url_arr[i].length;j+=2){
			obj=eval("document.search_form."+url_arr[i][j]);
			if(obj)obj.value=url_arr[i][j+1];
		}
    }
    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>
  <p>&nbsp;</p>
  <div align="center">
    <table width="100%" border="0" height="95">
      <tr> 
        <td width="75%" height="68" rowspan="5"> 
          <p align="center">&nbsp;</p>
          <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="bottom"> 
                  <table width="754" border="1" cellpadding="3" cellspacing="0" align="center" bordercolor="#111111" class=border>
                    <tr > 
                      <td width="138" height="20"> 
                        <div align="center"><font color="#000000">查询内容</font></div>
                      </td>
                      <td width="259" height="20"> 
                        <div align="center"><font color="#000000">时间限制</font></div>
                      </td>
                      <td width="165" height="20"> 
                        <div align="center"><font color="#000000">栏目</font></div>
                      </td>
                    </tr>
                    <tr bgcolor="#f7f7f7"> 
                      <td width="138" > 
                        <div align="center"> 
                          <input type="text" name="sercont">
                        </div>
                      </td>
                      <td width="259"> 
                        <div align="center"> 
                          <select name="sertime" size="1">
                       <option value="">任何时间</option>
			             <option value="3">3天之内</option>
							 <option value="2">7天之内</option>
							  <option value="30">一月之内</option>
							   <option value="180">半年之内</option>
                          </select>
                        </div>
                      </td>
                      <td width="165"> 
                        <div align="center">
                          <select name="seritem">
				 <option value="">任何栏目</option> 
                            <?
				$sqldo="select class_id,class_name from baseclass where class_layer=1";
				$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]["CLASS_NAME"]);
				
				$sqldo_in="select class_id,class_name from baseclass where class_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]["CLASS_NAME"]);	
					
				$sqldo_in_in="select class_id,class_name from baseclass where class_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]['CLASS_NAME'];
				$temp3_name=strip_tags($result_array_in_in[$k]['CLASS_NAME']);				
                ?>
                            <option value=<?echo $result_array_in_in[$k]["CLASS_ID"];?>> 
                            <? echo "$temp1_name";if($temp2_name){ echo ".$temp2_name";if($temp3_name) echo".$temp3_name";}
					   //echo "old:".$old;
					  // echo "result_array".$result_array[$i][0];
					   
					   ?>
                            </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>
              <tr> 
                <td width="7%">&nbsp;</td>
                <td width="86%"> <br>
                  <div align="right"> </div>
                </td>
                <td width="7%">&nbsp;</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"> 
                  <div align="right"> </div>
                  <p>&nbsp;</p>
                  <form name="form1" method="post" action="">
                    <table width="84%" border="0" align="center">
                      <tr> 
                        <td colspan="3"> 
                          <div align="right"> </div>
                          <?
			  if($cmdsearc){ //如果搜索
                 $sqldo="select newsid,newsname,uploadertime,pub_statue,newslength,column1,uploader from news ";
				 if($sercont or $sertime or $seritem){
				 $sqldo.="where ";
				 }
				 if($sercont){
				 $sqldo.="(instr(newsname,'$sercont')>0 or instr(newstext,'$sercont')>0)  ";
				 }
				 if($sercont and $sertime){
				 $datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
				 $sqldo.="and uploadertime>$datetime  ";
				 }elseif($sertime){
				 $datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
				 $sqldo.=" uploadertime>$datetime  ";
				 }
				 if(($sercont or $sertime) and $seritem){
				 $sqldo.="and  column1=$seritem  ";
				 }elseif($seritem){
				 $sqldo.=" column1='$seritem'  ";
				 } 
				 echo $sqldo;
				$res_array=$cla->db_query($sqldo);
                }		
		?>
                          <table border="1" cellspacing="0" cellpadding="3" align="center" width="754"bgcolor="#000060" class=border bordercolor="#111111">
                            <tr> 
                              <td height="2" width="9%"> 
                                <div align="center"> 选择</div>
                              </td>
                              <td height="2" width="9%"> 

⌨️ 快捷键说明

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