php 团购折扣计算公式

2015-01-24信息快讯网

php 团购折扣计算公式,因为最近需要调用天天团购程序的数据,代码比较不好找,所以直接自己写个代码读取mysql的数据。

 
$price=$row['price']; //原价 
$nowprice=$row['nowprice']; //现价 
$jiesheng=$price-$nowprice; //节省金额 
//$discount折扣计算 
if ( $nowprice > 0 ) 
{ 
$discount = round(10 / ($price / $nowprice), 1); 
} 
else 
{ 
$discount = 0; 
} 
if ( $discount <= 0 ) $discount = 0; 


完整代码:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> 
<title>徐州汽车网最新团购</title> 
<style type="text/css"> 
body{margin: 0 auto; text-align:center; padding:0} 
ul,li{margin:0; padding:0;list-style:none} 
body,td,th { 
font-size: 12px; 
} 
a:link { 
color: #333333; 
text-decoration: none; 
} 
a:visited { 
text-decoration: none; 
color: #333333; 
} 
a:hover { 
text-decoration: none; 
color: #FF3300; 
} 
a:active { 
text-decoration: none; 
} 
img{border:0;} 
/*Group buy*/ 
.groupbuy{ width:970px; border:1px solid #FEDDBA; padding:4px;} 
.groupbuy ul{width:146px; border:1px solid #FEDDBA; padding:2px; height:180px; float:left; margin:0 4px;} 
.groupbuy ul li{ text-align:center;} 
.groupbuy ul li.realprice{ background:#333; background:url(../images/groupprice.jpg) no-repeat right top; height:40px; line-height:40px; font-family:"Microsoft YaHei",Arial;display:block; font-weight:bold;color:#fff;} 

.groupbuy ul li.realprice img{ cursor:pointer;} 
.groupbuy ul li.realprice span{float:left; margin:0; padding:0} 
.groupbuy ul li.realprice span b{ font-size:18px;} 

.groupbuy ul li.supprice{ text-align:center;} 
.groupbuy ul li.supprice div table td{ background:#FDF4E3; text-align:center; } 
</style> 
</head> 
<body> 
<?php 
error_reporting(0); 
header("Content-type: text/html; charset=gbk"); 
$con = mysql_connect("localhost","mysql用户名","mysql密码"); 
if (!$con) 
{ 
die('Could not connect: ' . mysql_error()); 
} 
// some code 
mysql_select_db("tuanpcqc"); 
mysql_query("set names gbk"); 
$sql="select * from cenwor_tttuangou_product order by id desc limit 0,3"; 
$result = mysql_query($sql); 
?> 
<div class="groupbuy clear"> 
<?php 
while($row = mysql_fetch_array($result, MYSQL_BOTH)) { 
$id=$row['id']; 
$name = $row['name']; 
$price = $row['price']; 
$price=$row['price']; 
$nowprice=$row['nowprice']; 
$jiesheng=$price-$nowprice; 

if ( $nowprice > 0 ) 
{ 
$discount = round(10 / ($price / $nowprice), 1); 
} 
else 
{ 
$discount = 0; 
} 
if ( $discount <= 0 ) $discount = 0; 

$pic=$row['img']; 
$pic_arr=split(",",$pic); 
$picadd=$pic_arr[0]; 
//echo $picadd; 
$sql2="select * from cenwor_tttuangou_uploads where id=".intval($picadd); 
$result2 = mysql_query($sql2); 
$picurl = mysql_result($result2, 0,"url"); 
$picurl=str_replace("/demo/","/thumb/200x121/demo/",$picurl); 
?> 
<ul> 
<li><a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank"><img alt="" src="<?=$picurl?>" width="120" height="90" /></a></li> 
<li class="realprice"><span>¥<b><?=$nowprice?></b></span><a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank"><img alt="buy" src="images/buy.gif"/></a></li> 
<li class="supprice"> 
<div> 
<table> 
<tr> 
<td>原价</td> 
<td>折扣</td> 
<td>节省</td> 
</tr> 
<tr> 
<td><?=$price?></td> 
<td><?=$discount?>折</td> 
<td>¥<?=$jiesheng?></td> 
</tr> 
</table> 
</div> 
</li> 
</ul> 
<?php 
} 
?> 
</div> 
<?php 
function getpic($pic){ 

} 
mysql_close($con); 
?> 
</body> 
</html>
©2014-2024 dbsqp.com