📄 products.php
字号:
if(isset($_REQUEST["mem_id"])&&($_REQUEST["mem_id"]<>""))
{
$strpass.="&mem_id=".$_REQUEST["mem_id"];
$sql.=" and sb_uid=".$_REQUEST["mem_id"];
}
//=================================date search================
if($gdate<>"")
{
$sql.=" and sb_postedon > $gdate";
}
if($gdate1<>"")
{
$sql.=" and sb_postedon < $gdate1";
}
//============================================================
//echo $sql;
$offer_query=mysql_query($sql);
///////////////////////////////////PAGINATION /////////
if(!isset($_REQUEST["pg"]))
{
$pg=1;
}
else
{
$pg=$_REQUEST["pg"];
}
$rcount=mysql_num_rows($offer_query);
if ($rcount==0 )
{
$pages=0;
}
else
{
$pages=floor($rcount / $recperpage);
if (($rcount%$recperpage) > 0 )
{
$pages=$pages+1;
}
}
$jmpcnt=1;
while ( $jmpcnt<=($pg-1)*$recperpage && $row = mysql_fetch_array($offer_query) )
{
$jmpcnt = $jmpcnt + 1;
}
////////////////////////////////////////////////////////////////////////
?>
<script language="JavaScript">
function select_all()
{
for (var i=0;i<document.form2.elements.length;i++)
{
var e =document. form2.elements[i];
if ((e.name != 'check_all') && (e.type=='checkbox'))
{
e.checked = document.form2.check_all.checked;
}
}
}
function validate(frm)
{
var reply;
reply=confirm("This will remove the checked product catalogs, do you really want to continue ?");
return reply;
}
</script>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="10">
<tr>
<td height="25" colspan="2" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong> Search
Product Catalogs</strong></font></td>
</tr>
<form name="search_form" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >
<tr>
<td width="50%" bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Keyword:</font></strong></div></td>
<td><input name="keyword" type="text" id="keyword2" value="<?php echo $keyword;?>"></td>
</tr>
<tr align="left" valign="top">
<td bgcolor="#F5F5F5"> <div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Show:</strong></font></div></td>
<td><font face="Arial, Helvetica, sans-serif"> <font size="2">
<input name="sbapproval" type="radio" value="1" <? if($sbapproval==1) { echo "checked";}?>>
All</font></font><font size="2" face="Arial, Helvetica, sans-serif">
<input type="radio" name="sbapproval" value="2" <? if($sbapproval==2) { echo "checked";}?> >
Unapproved
<input type="radio" name="sbapproval" value="3" <? if($sbapproval==3) { echo "checked";}?> >
Approved
<input type="radio" name="sbapproval" value="4" <? if($sbapproval==4) { echo "checked";}?> >
New </font></td>
</tr>
<tr>
<td bgcolor="#F5F5F5"><div align="right"><strong><font size="2" face="Arial, Helvetica, sans-serif">Record
Per Page:</font></strong></div></td>
<td><select name="recperpage">
<option value="10" <? if($recperpage==10) { echo "selected";}?>>10</option>
<option value="20" <? if($recperpage==20) { echo "selected";}?>>20</option>
<option value="30" <? if($recperpage==30) { echo "selected";}?>>30</option>
<option value="50" <? if($recperpage==50) { echo "selected";}?>>50</option>
<option value="100" <? if($recperpage==100) { echo "selected";}?>>100</option>
</select></td>
</tr>
<tr>
<td bgcolor="#F5F5F5"> </td>
<td><input type="submit" name="Submit2" value="Search"> </td>
</tr>
</form>
</table>
</td>
</tr>
<tr>
<td><form name="form2" method="post" action="delete_product.php" onSubmit="return validate(this);">
<table width="100%" border="0" cellspacing="10" cellpadding="2" class="maintablestyle">
<tr>
<td height="25" bgcolor="#004080"> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><?php echo $sblabel; ?></font></strong></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td> <font size="2" face="Arial, Helvetica, sans-serif">
<input type="submit" name="Submit" value="Remove Checked">
</font> <div align="right"></div></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr valign="middle" bgcolor="#F5F5F5" >
<td height="25" ><font size="2" face="Arial, Helvetica, sans-serif">
<input type="checkbox" name="check_all" value="yes" onClick="select_all();">
</font></td>
<td align="right" ><font class="normal">Total <font class="red">
<strong>
<?php echo $rcount; ?>
</strong> </font> match<?php echo ($rcount>1)?'es':'';?> found</font></td>
</tr>
<?
$cnt=0;
while (($offer=mysql_fetch_array($offer_query)) && ($cnt<$recperpage))
{
if($cnt%2<>0)
$bgcolor="#F5F5F5";
else
$bgcolor="#FFFFFF";
$images=mysql_fetch_array(mysql_query("select * from sbbleads_product_images where sb_offer_id=".$offer["sb_id"]." order by sb_id"));
$cnt++;
?>
<tr bgcolor="<?php echo $bgcolor; ?>" >
<td colspan="2" valign="top" > <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" rowspan="3" align="center" valign="top">
<input type="checkbox" name="checkbox<?php echo $offer["sb_id"]; ?>" id="checkbox<?php echo $offer["sb_id"]; ?>2" value="<?php echo $offer["sb_id"]; ?>">
</td>
<td width="60" rowspan="3" align="center" valign="top">
<? if ($images) {echo "<a href=\"view_product.php?id=".$offer["sb_id"]."\" ><img $img_pmt border=0 src=\"$img_path" .$images["sb_img_url"]."\"></a>"; } else
{
?>
<img src="../images/nopic.gif" width="50" height="50">
<?
}?>
</td>
<td ><strong><font class="normal"> <?php
if (strlen ($offer["sb_title"])>50)
{
echo substr($offer["sb_title"], 0, strrpos( substr($offer["sb_title"], 0, 50),' ' ));
}
else
{
echo $offer["sb_title"];
}
?><font class="red"> [
<?
$cur=mysql_fetch_array(mysql_query("select * from sbbleads_currencies where sbcur_id=".$offer["sb_price_cur_id"]));
echo $cur["sbcur_symbol"];
?>
<?php echo $offer["sb_price"];?> ]</font></font></strong></td>
</tr>
<tr>
<td><font class="smalltext"> Posted by <strong>
<?php
$mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$offer["sb_uid"]));
$profile=mysql_fetch_array(mysql_query("select * from sbbleads_companyprofiles where sb_uid=".$offer["sb_uid"]));
if ($profile) { echo $profile["sb_companyname"];}
else { echo $mem["sb_username"]; }
?>
</strong><font class="red"><strong>[
<?php
$level_query=mysql_query("select * from sbbleads_levels where sb_levelid=" .$mem["sb_memtype"]);
$level= mysql_fetch_array($level_query);
echo $level["sb_levelname"];
?>
]</strong></font> on <?php echo sb_date($offer["ondate"]);?>
</font></td>
</tr>
<tr>
<td valign="top"><font class="smalltext"> <?php
if (strlen (strip_tags($offer["sb_description"]))>100)
{
echo substr(strip_tags($offer["sb_description"]), 0, strrpos( substr(strip_tags($offer["sb_description"]), 0, 100),' ' )) . "..";
}
else
{
echo strip_tags($offer["sb_description"]);
}
?>
</font></td>
</tr>
<tr>
<td align="center" valign="top"> </td>
<td align="center" valign="top"> </td>
<td valign="top"><font size="1" face="Arial, Helvetica, sans-serif"> [<a href="view_product.php?id=<?php echo $offer["sb_id"];?>">View</a>] [<a href="edit_product.php?sb_id=<?php echo $offer["sb_id"]; ?>">Edit</a>]<?php
if($offer["sb_new"]<>"yes")
{
?> [<a href="approve_product.php?sb_id=<?php echo $offer["sb_id"];
?>"><?php echo ($offer["sb_approved"]=='no')?'Approve':'Disapprove'; ?></a>]<?php
}
else
{
?> [<a href="approve_product_new.php?sb_id=<?php echo $offer["sb_id"];
?>">Approve</a>] [<a href="reject_product_new.php?sb_id=<?php
echo $offer["sb_id"]; ?>">Reject</a>]<?php
}
?> [<a href="view_images_product.php?sb_id=<?php echo $offer["sb_id"]; ?>" target="_blank">Images</a>]</font></td>
</tr>
</table></td>
</tr>
<?
}
?>
</table></td>
</tr>
<tr>
<td height="25" bgcolor="#004080"> <p> <strong><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif">
Pages:
<?
if ($pg>1)
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".($pg-1).$strpass."' class='pagelink'><font color='#FFCC00'>";
}//end if
if ($pages<>1)
echo "Previous";
if ($pg>1)
{
echo "</font></a> ";
}//end if
echo " ";
for ($i=1; $i<=$pages; $i++)
{
if ($pg<>$i)
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".$i.$strpass."' class='pagelink'><font color='#FFCC00'>";
echo $i;
echo "</font></a> ";
}
else
{
echo " ".$i." ";
}
}//for
echo " ";
if ($pg<$pages )
{
echo " <a href='".$_SERVER['PHP_SELF']."?pg=".($pg+1).$strpass."' class='pagelink'><font color='#FFCC00'>";
}//end if
if ($pages<>1)
{
echo "Next";
}//end if
if ($pg<>($pages))
{
echo "</font></a> ";
}//end if
?>
</font></strong></p></td>
</tr>
</table>
</form></td>
</tr>
</table>
<?
}// end main
include "template.php";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -