📄 view_product.php
字号:
<?php
include_once "myconnect.php";
include_once "date_time_format.php";
if(!isset($_REQUEST['id']) || !is_numeric($_REQUEST['id']) || ($_REQUEST['id'] == 0) )
{
header("Location: index.php?msg=".urlencode("Invalid access, denied"));
die();
}
$id=$_REQUEST['id'];
$sbq_off="select *,UNIX_TIMESTAMP(sb_postedon) as sbposted from sbbleads_products where sb_id=$id";
//die($sbq_off);
$sbrow_off=mysql_fetch_array(mysql_query($sbq_off));
if(!$sbrow_off)
{
header("Location: index.php?msg=".urlencode("No such product catalog exists"));
die();
}
///////////------updating view count
//$sbqu_off="update sbbleads_offers set sb_viewed=sb_viewed+1 where sb_id=$id";
//mysql_query($sbqu_off);
//////////---------
function main()
{
global $sbrow_off;
$id=$_REQUEST['id'];
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
if(($config["sb_image_magik"]=="enable"))
{
$img_path="../thumbs2/";
$img_pmt="";
}
else
{
$img_path="../uploadedimages/";
$img_pmt="width=".$config["sb_th_width2"]." height=".$config["sb_th_width2"];
}
$cid=0;
$keyword="";
if(isset($_REQUEST["cid"])&&($_REQUEST["cid"]<>""))
{
$cid=$_REQUEST["cid"];
}
if(isset($_REQUEST["keyword"])&&($_REQUEST["keyword"]<>""))
{
$keyword=$_REQUEST["keyword"];
}
$catname="";
$category=0;
$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $cid );
if ($cat=mysql_fetch_array($cat_query))
{
$catname=$cat["sb_cat_name"];
$category=$cat["sb_id"];
}
$catpath="";
$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $cid );
while ($rs=mysql_fetch_array($cat_query))
{
$catpath =" > <a href=\"cat_sell.php?cid=" . $rs["sb_id"] . "\">" .$rs["sb_cat_name"]."</a>".$catpath;
$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $rs["sb_pid"] );
}
$mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$sbrow_off["sb_uid"]));
$profile=mysql_fetch_array(mysql_query("select * from sbbleads_companyprofiles where sb_uid=".$sbrow_off["sb_uid"]));
?>
<script language="JavaScript">
function win(box)
{
str="addcontact_popup.php?" + box;
window.open(str,"Allot","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=350,height=150,location=no,directories=no,scrollbars=yes");
return false;
}
function win1(box)
{
str="addblock_popup.php?" + box;
window.open(str,"Allot","top=5,left=30,toolbars=no,maximize=yes,resize=yes,width=350,height=150,location=no,directories=no,scrollbars=yes");
return false;
}
</script>
<table width="100%" border="0" cellspacing="10" cellpadding="2" class="maintablestyle">
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td>
<!--font class="normal"> <a href="index.php">Home</a><? echo $catpath;?></font-->
</td>
</tr>
<tr>
<td height="25">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="titlestyle">
<tr>
<td valign="middle"> <?php echo $sbrow_off["sb_title"]; ?>
<div align="right" ></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="1" class="onepxtable">
<tr valign="top">
<td><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr valign="top">
<td width="50%"> <table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Price
</div></td>
<td width="60%" height="25" class="innertablestyle" > <font class="normal">
<?php
$sbq_cur="select * from sbbleads_currencies where sbcur_id=".$sbrow_off["sb_price_cur_id"];
$sbrow_cur=mysql_fetch_array(mysql_query($sbq_cur));
echo $sbrow_cur['sbcur_symbol'].' '.$sbrow_off["sb_price"]; ?>
</font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Location</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_off["sb_location"]; ?></font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Posted
On</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class='normal'><?php echo sb_date($sbrow_off["sbposted"]);?></font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Posted
By</div></td>
<td width="60%" height="25" class="innertablestyle" ><strong><font class="normal">
<?php
if ($profile)
echo $profile["sb_companyname"];
else
echo $mem["sb_username"];
?>
</font><font class="smalltext"><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></font></strong></td>
</tr>
</table></td>
<td> <table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Minimum
Order</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_off["sb_min_order"]; ?></font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Shipping
Cost</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_cur['sbcur_symbol'].' '.$sbrow_off["sb_shipping_cost"]; ?></font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Sample
Available</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_off["sb_samples_available"]; ?></font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="40%" height="25" class="subtitle"> <div align="left">Product
Status</div></td>
<td width="60%" height="25" class="innertablestyle" ><font class="normal"><?php echo $sbrow_off["sb_product_status"]; ?></font></td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td colspan="2"><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr valign="top" class="onepxtable">
<td height="25" class="subtitle"> <div align="left">Payment
Mode</div></td>
<td height="25" class="innertablestyle" ><font class="normal">
<?php
$sb_payment_mode=$sbrow_off["sb_payment_mode"];
$sb_other_mode=$sbrow_off["sb_other_mode"];
if(strstr($sb_payment_mode,'cash'))
echo 'Cash<br>';
if(strstr($sb_payment_mode,'cheque'))
echo 'Cheque<br>';
if(strstr($sb_payment_mode,'credit'))
echo 'Credit Card<br>';
if(strstr($sb_payment_mode,'bank'))
echo 'Bank Transfer<br>';
if(strstr($sb_payment_mode,'loc'))
echo 'Letter of Credit<br>';
if(strstr($sb_payment_mode,'escrow'))
echo 'Escrow<br>';
echo $sb_other_mode;
//echo $sb_payment_mode;
// echo $sbrow_off["sb_description"]; ?>
</font></td>
</tr>
<tr valign="top" class="onepxtable">
<td width="20%" height="25" class="subtitle"> <div align="left">Categories</div></td>
<td height="25" class="innertablestyle">
<?php
$sbq_cat="select * from sbbleads_product_cats where sb_offer_id=$id";
//echo $sbq_cat;
$sbrs_cat=mysql_query($sbq_cat);
/* $sbcat_exists=false;
*/ while($sbrow_cat=mysql_fetch_array($sbrs_cat))
{
$catpath="";
$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=".$sbrow_cat["sb_cid"] );
/* if($sbrow_cat["sb_cid"] == $cid) //working code
// continue; //for skipping the category that is alreday displayed or passed
*/ while ($rs=mysql_fetch_array($cat_query))
{
/* $sbcat_exists=true; //just checks whether we come in this portion ever
*/ // $catpath =" > <a href=\"cat_sell.php?cid=" . $rs["sb_id"] . "\">" .$rs["sb_cat_name"]."</a>".$catpath;
$catpath =" > ".$rs["sb_cat_name"].$catpath;
$cat_query=mysql_query("Select * from sbbleads_categories where sb_id=" . $rs["sb_pid"] );
}
echo preg_replace('/^\s>\s/','',$catpath).'<br>'; //managing starting > symbol
}
/* if(!$sbcat_exists)
echo $config["sb_null_char"]; //prints in case no other category than cid
*/ ?>
</td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td colspan="2"><table width="100%" border="0" cellspacing="1" cellpadding="1" class="innertablestyle">
<tr>
<?php
$sbq_com="select * from sbbleads_companyprofiles where sb_uid=".$sbrow_off["sb_uid"];
$sbrow_com=mysql_fetch_array(mysql_query($sbq_com));
if($sbrow_com)
{
?>
<td align="center" valign="middle"> <a href="view_profile.php?id=<?php echo $sbrow_com["sb_id"]; ?>">View
Company Profile</a>
<?php
} //end if sbrow_com ?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="titlestyle"> Description</td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="4" cellspacing="1" class="onepxtable">
<tr>
<td height="25" valign="top" class="innertablestyle"><?php echo $sbrow_off["sb_description"]; ?></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="titlestyle"> Relevant Images</td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="1" class="seperatorstyle">
<?php
$sbq_img="select * from sbbleads_product_images where sb_offer_id=$id";
// die($sbq_img);
$sbrs_img=mysql_query($sbq_img);
if(mysql_num_rows($sbrs_img)>0)
{
$sbcnt=0;
$sbimg_per_row=4;
while($sbrow_img=mysql_fetch_array($sbrs_img))
{
?>
<?php if($sbcnt%$sbimg_per_row == 0)
{ ?>
<tr>
<?php
} //end if
$sbcnt++;
?>
<td height="100%">
<table width="100%" height="100%" border="0" cellpadding="5" cellspacing="0" class="innertablestyle">
<tr>
<td><div align="center"><a href="../uploadedimages/<?php echo $sbrow_img["sb_img_url"]; ?>" target="_blank"><img src="<?php echo $img_path;?><?php echo $sbrow_img["sb_img_url"]; ?>" border="0" <? echo $img_pmt; ?>></a></div></td>
</tr>
</table>
</td>
<?php if($sbcnt%$sbimg_per_row == 0)
{ ?>
</tr>
<?php
} //end if
} //end while
//////-------padding empty tds
$sb_remainder=$sbcnt%$sbimg_per_row;
$sb_no_of_pads=($sb_remainder!=0)?$sbimg_per_row-$sb_remainder:0;
for($sb_new_counter=1;$sb_new_counter<=$sb_no_of_pads;$sb_new_counter++)
{
?>
<td class="innertablestyle"><img src="../images/spacer.gif" width="100" height="100" border="0"></td>
<?php
} //end for padding
}
else
{ ?>
<tr>
<td class="innertablestyle" height="25"><font class="normal"> No images have been defined</font></td>
</tr>
<?php
} //end else no img defined?>
</table></td>
</tr>
</table>
<?
}// end main
include "template.php";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -