📄 choosecategory.php

📁 通达OA部分源代码
💻 PHP
字号:
<?
include_once "myconnect.php";
include_once "styles.php";
if ( isset( $_REQUEST["cid"] ) && $_REQUEST["cid"]!="" )
{
$cid=$_REQUEST["cid"];
}
else
{
$cid=0;
}

$rs_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $cid );
	if ($rs=mysql_fetch_array($rs_query))
	{
	$catname=$rs["sb_cat_name"];
	$category=$rs["sb_id"];
	$cid=$rs["sb_id"];
	}
    else
	{
	$catname="";
	$category=0;
	$cid=0;
	}
 $catpath="";
  	$rs_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $category );
//	echo "Select * from sbppc_categories where id=" . $category ;
	while ($rs=mysql_fetch_array($rs_query))
    {
    $catpath ="><a href=\"choosecategory.php?box=1&cid=" . $rs["sb_id"] . "\" class='titlelink'>" .$rs["sb_cat_name"]."</a>" . $catpath; 
  	$rs_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $rs["sb_pid"] );
	 }
    
  ?>

<html>
<head>
<title>Choose Category</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<Script Language="JavaScript">
function closewin()
{
window.opener.document.frm1.<?php echo "cat" . $_REQUEST["box"];?>.value='<?php echo $cid; ?>';
window.opener.document.frm1.<?php echo "cat_name" . $_REQUEST["box"];?>.value='<?php echo $catname; ?>';
window.close()
}
</script>
<form action="choosecategory.php" method="post" name="frm123">
  <table width="400" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td ><font class="normal"><strong>Choose Category</strong></font></td>
    </tr>
    <tr> 
      <td class="titlestyle"><font color="#FFFFFF"><a href="choosecategory.php?box=1" class="titlelink">All 
        Categories</a> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo  $catpath; ?></font></font></td>
    </tr>
  </table>
  <font face="Arial, Helvetica, sans-serif" size="2"> 
  <?
  	$rs_query=mysql_query("Select count(*) from sbbleads_categories where sb_pid=" . $cid );
	$rs=mysql_fetch_array($rs_query);

$rs_query=mysql_query("Select * from sbbleads_categories where sb_pid=" . $cid ." order by sb_order_index");
if ($rs=mysql_fetch_array($rs_query))
	{
	
  ?>
  <table width="400" border="0" cellspacing="0" cellpadding="0" class="onepxtable">
    <?php
					   $cnt=1;
					   $rs_query_t=mysql_query("Select * from sbbleads_categories where sb_pid=" . $cid." order by sb_order_index"	);
					   while($rs_t=mysql_fetch_array($rs_query_t))
					   {
		$child=mysql_num_rows(mysql_query("Select * from sbbleads_categories where sb_pid=" . $rs_t["sb_id"]));
					   ?>
    <?php if ($cnt%2==1) { ?>
    <tr> 
      <?php } ?>
      <td><font size="2" face="Arial, Helvetica, sans-serif"> <a href="choosecategory.php?box=<?php echo $_REQUEST["box"] ;?>&cid=<?php echo $rs_t["sb_id"] ;?>" class="insidelink"><?php echo $rs_t["sb_cat_name"] ;

	  ?></a> 
        </font></td>
      <?php if ($cnt%2==0) { ?>
    </tr>
    <?php } ?>
    <?php
						$cnt++;
					   }
					   ?>
  </table>
  </font> 
  <?
}
//else
{
?>

  
  <input type="button" name="Button" value="Done" onClick="closewin();">

<?

}
?>
</form>
</body>
</html>
⌨️ 快捷键说明

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