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>
基于在生产环境中使用php性能测试工具xhprof的详解
php cli模式学习(PHP命令行模式)
获取PHP警告错误信息的解决方法
php cli 小技巧
php中用加号与用array_merge合并数组的区别深入分析
PHP生成唯一的促销/优惠/折扣码(附源码)
php 数组动态添加实现代码(最土团购系统的价格排序)
Linux fgetcsv取得的数组元素为空字符串的解决方法
php中$_REQUEST、$_POST、$_GET的区别和联系小结
打造超酷的PHP数据饼图效果实现代码
DISCUZ在win2003环境下 Unable to access ./include/common.inc.php in... 的问题终极解决方案
一个PHP的QRcode类与大家分享
PHP提取字符串中的图片地址[正则表达式]
复星集团回应涉王宗南受贿案:售房价格处于市场折扣区间
飞机票也可团购 国内航空公司今起首推团体票预订