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

📄 advance_search.php

📁 通达OA部分源代码
💻 PHP
字号:
<?
include_once "myconnect.php";


function main()
{
?>
<script language="JavaScript">
function validate()
{

	if(document.form1.keyword.value != "")
	{
		if((document.form1.all_p.checked==false) &&  (document.form1.int_comment.checked==false) && (document.form1.all_comment.checked==false) && (document.form1.article.checked==false) && (document.form1.member.checked==false))
		{
			alert ('You must choose atleast one parameters!');
			document.form1.keyword.focus();
			return (false);
		}
	}
	return (true);
}
</script>

<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr align="left" valign="top"> 
    <td><table width="90%%" border="0" align="center" cellpadding="1" cellspacing="0" >
        <tr > 
          <td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="5" class="onepxtable">
              <form name="form1" method="post" action="search.php" <? //onSubmit="return validate();"?>>
                <tr align="left" valign="top"> 
                  <td colspan="3" class="titlestyle">&nbsp;Advance Search</td>
                </tr>
                <tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'><strong>Search 
                    Keywords</strong></font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"> <font class='normal'> 
                    <input name="keyword" type="text" size="50">
                    </font></td>
                </tr>
                <tr valign="top"> 
                  <td align="right" class="innertablestyle"><font class='normal'><strong>Search 
                    Method </strong></font></td>
                  <td class="maintext">&nbsp;</td>
                  <td class="maintext"><font class='normal'> 
                    <input name="search_method" type="radio" value="1" checked>
                    An exact phrase match<br>
                    <input type="radio" name="search_method" value="2">
                    Matches on all words (AND)<br>
                    <input type="radio" name="search_method" value="3">
                    Matches on any words (OR)</font></td>
                </tr>
                <!--<tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'><strong>Search 
                    in </strong></font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"> <p><font class='normal'>(Please choose at least one option of these)<br>
                      <input name="all_p" type="checkbox" value="yes" checked>
                      All<br>
                      <input name="article" type="checkbox" id="article" value="yes">
                      Article<br>
                      <input type="checkbox" name="int_comment" value="yes">
                      Initial Comment<br>
                      <input type="checkbox" name="all_comment" value="yes">
                      All Comments<br>
                      <input type="checkbox" name="member" value="yes">
                      Members Username/Name<br>
                      </font></p></td>
                </tr>-->
                <tr valign="top"> 
                  <td align="right" class="innertablestyle"><font class='normal'><strong>Search 
                    in</strong></font></td>
                  <td class="maintext">&nbsp;</td>
                  <td class="maintext"><select name="type">
                      <option value="1" selected>Sell Offers</option>
                      <option value="2">Buy Offers</option>
                      <option value="3">Products Catalogs</option>
                      <option value="4">Company Profiles</option>
                    </select> </td>
                </tr>
                <tr valign="top"> 
                  <td align="right" class="innertablestyle"><font class='normal'><strong>Category</strong></font></td>
                  <td class="maintext">&nbsp;</td>
                  <td class="maintext"><font face="Arial, Helvetica, sans-serif" size="2"> 
                    <select name=cid id="cid"  >
                      <option value=0>All Categories</option>
                      <?
			
				$rs_query=mysql_query("Select * from sbbleads_categories where sb_pid=0");
	
	while ($rs=mysql_fetch_array($rs_query))
	{
				?>
                      <option value="<?php echo $rs["sb_id"]; ?>"
						
				><?php echo $rs["sb_cat_name"]; ?></option>
                      <?
                      
			  }
			  ?>
                    </select>
                    </font><font class='normal'>&nbsp;</font></td>
                </tr>
                <tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'><strong>Posted 
                    After</strong></font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"><font size="2"><font color="#333333" face="Arial, Helvetica, sans-serif"><strong> 
                    <select name="month" id="select13" class="box4">
                      <option value="0" selected>-</option>
                      <?
				 for ($i=1; $i<=12; $i++)
				 {
				 ?>
                      <option value="<? print($i); ?>"


><? print($i);?></option>
                      <?
				 }//next for
				 ?>
                    </select>
                    / 
                    <select name="day" id="select14" class="box4">
                      <option value="0" selected>-</option>
                      <? 
				 for ($i=1; $i<=31; $i++)
				 {
				 ?>
                      <option value="<? print($i);?>"

				  
				  
				  ><? print($i);?></option>
                      <?
				 }
				 ?>
                    </select>
                    / 
                    <select name="year" id="select15" class="box4">
                      <option value="0" selected>-</option>
                      <? 
				 for ($i=(date("Y",time())-5); $i<=(date("Y",time())+10); $i++)
				 {
				 ?>
                      <option value="<? print($i);?>"

									><? print($i);?></option>
                      <?
				 }
				 ?>
                    </select>
                    </strong><font size="1">(mm/dd/yyyy) </font></font></font></td>
                </tr>
                <tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'><strong>Posted 
                    Before</strong></font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"><font class='normal'><font color="#333333"><strong> 
                    <select name="month1" id="select10" class="box4">
                      <option value="0" selected>-</option>
                      <?
				 for ($i=1; $i<=12; $i++)
				 {
				 ?>
                      <option value="<? print($i); ?>"


><? print($i);?></option>
                      <?
				 }//next for
				 ?>
                    </select>
                    / 
                    <select name="day1" id="select11" class="box4">
                      <option value="0" selected>-</option>
                      <? 
				 for ($i=1; $i<=31; $i++)
				 {
				 ?>
                      <option value="<? print($i);?>"

				  
				  
				  ><? print($i);?></option>
                      <?
				 }
				 ?>
                    </select>
                    / 
                    <select name="year1" id="select12" class="box4">
                      <option value="0" selected>-</option>
                      <? 
				 for ($i=(date("Y",time())-5); $i<=(date("Y",time())+10); $i++)
				 {
				 ?>
                      <option value="<? print($i);?>"

									><? print($i);?></option>
                      <?
				 }
				 ?>
                    </select>
                    </strong><font size="1">(mm/dd/yyyy) </font></font></font></td>
                </tr>
                <tr valign="top">
                  <td align="right" class="innertablestyle"><font class='normal'><strong>Country</strong></font></td>
                  <td class="maintext">&nbsp;</td>
                  <td class="maintext"><font face="Arial, Helvetica, sans-serif" size="2"><strong><font color="#004566">
                    <select name="country" >
                      <option selected value="">All Countries</option>
                      <?
$rs_t_query=mysql_query ("select * from sbbleads_country order by country");
while ($rs_t=mysql_fetch_array($rs_t_query))    
{
?>
                      <option  value="<? echo $rs_t["id"];?>"><? echo $rs_t["country"]  ; ?></option>
                      <?
		  }
		  		  ?>
                    </select>
                    </font></strong></font></td>
                </tr>
                <tr valign="top"> 
                  <td width="40%" align="right" class="innertablestyle"><font class='normal'>&nbsp;</font></td>
                  <td width="6" class="maintext">&nbsp;</td>
                  <td width="60%" class="maintext"><font class='normal'> 
                    <input type="submit" name="Submit" value="Search">
                    </font></td>
                </tr>
              </form>
            </table></td>
        </tr>
      </table></td>
  </tr>
  <tr align="left" valign="top"> 
    <td>&nbsp;</td>
  </tr>
</table>
<?
}// end main
include "template.php";
?>

⌨️ 快捷键说明

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