📄 browsecats.php
字号:
if($cat_num==0)
{
$list_num=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats where sb_cid=$cid"));
$list_num1=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats_buy where sb_cid=$cid"));
$sbq_pro="select * from sbbleads_product_cats where sb_cid=$cid";
//echo $sbq_pro;
$list_num2=mysql_num_rows(mysql_query($sbq_pro));
$list_num3=mysql_num_rows(mysql_query("select * from sbbleads_profile_cats where sb_cid=$cid"));
?>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td colspan="2"><font size="2" color="#990000" face="Arial, Helvetica, sans-serif">This
Category doesn't contain any sub category.
<?
if($list_num>0)
{
?>
<br>
Click <a href="selloffers.php?cid=<?php echo $cid; ?>">Sell
Offers</a> (<? echo $list_num;?>) to list the sell
offers of this category.
<?
}
if($list_num1>0)
{
?>
<br>
Click <a href="buyoffers.php?cid=<?php echo $cid; ?>">Buy
Offers</a> (<? echo $list_num1;?>) to list the buy
offers of this category.
<?
}
if($list_num2>0)
{
?>
<br>
Click <a href="products.php?cid=<?php echo $cid; ?>">Product
Catalogs</a> (<? echo $list_num2;?>) to list the
product catalogs of this category.
<?
}
if($list_num3>0)
{
?>
<br>
Click <a href="profiles.php?cid=<?php echo $cid; ?>">Company
profiles</a> (<? echo $list_num3;?>) to list the
company profiles of this category.
<?
}
?>
</font></td>
</tr>
<?php
}
else
{
while ($rs=mysql_fetch_array($rs_query))
{
$rst1_query=mysql_query("Select * from sbbleads_categories where sb_pid=" . $rs["sb_id"] );
$clist=$rs["sb_id"];
while ( $rst1=mysql_fetch_array($rst1_query) )
{
$clist.="," . $rst1["sb_id"];
while ( $rst1=mysql_fetch_array($rst1_query) )
{
$clist.="," . $rst1["sb_id"];
}
$rst1_query=mysql_query("Select * from sbbleads_categories where sb_pid IN (" . $clist . ") and sb_id not in ( ". $clist . ")") ;
}
// $list_num=mysql_num_rows(mysql_query("select * from sbbleads_forums where sb_cid in ($clist)"));
?>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif"> <a href="browsecats.php?cid=<?php echo $rs["sb_id"]; ?>"><?php echo $rs["sb_cat_name"]; ?></a><!--font color="#666666" size="1">
( <? //echo $list_num;?> )</font--></font></td>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<a href="browsecats.php?delete=Yes&delid=<?php echo $rs["sb_id"]; ?>&cid=<?php echo $cid; ?>" onClick="return del_confirm();">Delete</a>
| <a href="editcat.php?cid=<?php echo $rs["sb_id"]; ?>">Edit</a>
</font></td>
</tr>
<?php
}
}
?>
<tr>
<td height="48"> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="10">
<form name="form2" method="post" action="browsecats.php">
<tr bgcolor="#004080">
<td height="25" colspan="2" align="left"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> Add
New
<?
if($cid<>0) { echo "Subcategory";} else { echo "Category";}?>
</font></strong></td>
</tr>
<tr>
<td width="50%" align="right" bgcolor="#F5F5F5"> <div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Category</font><font size="2" face="Arial, Helvetica, sans-serif">
Name: </font></strong></div></td>
<td width="448"><font size="2" face="Arial, Helvetica, sans-serif">
<input name="cat_name" type="text" value="<? echo $cat_name;?>" size="40">
<input name="cid" type="hidden" id="cid" value="<? echo $cid;?>">
</font></td>
</tr>
<tr>
<td align="right" bgcolor="#F5F5F5"><strong><font size="2" face="Arial, Helvetica, sans-serif"> </font></strong></td>
<td> <input type="submit" name="Submit" value="Add"> </td>
</tr>
</form>
</table></td>
</tr>
<tr>
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="10">
<tr>
<td height="25" colspan="2" align="left" bgcolor="#004080"><strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"> Shift
Listings</font></strong></td>
</tr>
<script language="JavaScript">
function validate(form)
{
if(form.cid.selectedIndex==0)
{
alert('Please choose a category to shift from');
form.cid.focus();
return false;
}
if(form.cat1.selectedIndex==0)
{
alert('Please choose a category in which to shift');
form.cat1.focus();
return false;
}
return true;
}
</script>
<form name="form1" method="post" action="shiftlistings.php" onSubmit="return validate(this);">
<tr>
<td width="50%" align="right" bgcolor="#F5F5F5"> <div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">From
Category: </font></strong></div></td>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif">
<select name="cid" id="cid" >
<option value="0">Select a category</option>
<?
$rs_query=mysql_query("select * from sbbleads_categories order by sb_pid");
while($rst=mysql_fetch_array($rs_query))
{
$cat_path="";
$child=mysql_fetch_array(mysql_query("select * from sbbleads_categories where sb_pid=".$rst["sb_id"]));
if($child)
{
continue;
}
$cat_path.=$rst["sb_cat_name"];
$par=mysql_query("select * from sbbleads_categories where sb_id=".$rst["sb_pid"]);
while($parent=mysql_fetch_array($par))
{
$cat_path=$parent["sb_cat_name"].">".$cat_path;
$par=mysql_query("select * from sbbleads_categories where sb_id=".$parent["sb_pid"]);
}
$num=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats where sb_cid=".$rst["sb_id"]));
$num+=mysql_num_rows(mysql_query("select * from sbbleads_offer_cats_buy where sb_cid=".$rst["sb_id"]));
$num+=mysql_num_rows(mysql_query("select * from sbbleads_product_cats where sb_cid=".$rst["sb_id"]));
$num+=mysql_num_rows(mysql_query("select * from sbbleads_profile_cats where sb_cid=".$rst["sb_id"]));
if($num==0)
{
continue;
}
?>
<option value="<? echo $rst["sb_id"];?>" ><? echo $cat_path." (".$num.")";?></option>
<?
}
?>
</select>
</font></td>
</tr>
<tr>
<td width="50%" align="right" bgcolor="#F5F5F5"> <div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">To
Category: </font></strong></div></td>
<td align="left"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif">
<select name="cat1" id="select3" >
<option value="0">Select a category</option>
<?
$rs_query=mysql_query("select * from sbbleads_categories order by sb_pid");
while($rst=mysql_fetch_array($rs_query))
{
$cat_path="";
$child=mysql_fetch_array(mysql_query("select * from sbbleads_categories where sb_pid=".$rst["sb_id"]));
if($child)
{
continue;
}
$cat_path.=$rst["sb_cat_name"];
$par=mysql_query("select * from sbbleads_categories where sb_id=".$rst["sb_pid"]);
while($parent=mysql_fetch_array($par))
{
$cat_path=$parent["sb_cat_name"].">".$cat_path;
$par=mysql_query("select * from sbbleads_categories where sb_id=".$parent["sb_pid"]);
}
?>
<option value="<? echo $rst["sb_id"];?>" ><? echo $cat_path;?></option>
<?
}
?>
</select>
</font></div>
<div align="left"></div>
<div align="left"><font size="2" face="Arial, Helvetica, sans-serif">
</font></div></td>
</tr>
<tr>
<td align="right" bgcolor="#F5F5F5"> <div align="right"><font size="2" face="Arial, Helvetica, sans-serif"></font></div></td>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif">
<input type="Submit" name="no3" value="Go" >
</font></td>
</tr>
</form>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?
} //End of main
include_once("template.php");
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -