|
<div class="codetitle"><a style="CURSOR: pointer" data="83636" class="copybut" id="copybut83636" onclick="doCopy('code83636')"> 代码如下:<div class="codebody" id="code83636">
$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;
完整代码:
<div class="codetitle"><a style="CURSOR: pointer" data="75350" class="copybut" id="copybut75350" onclick="doCopy('code75350')"> 代码如下:<div class="codebody" id="code75350">
<!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">
徐州汽车网最新团购
<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; }
<?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,"url");
$picurl=str_replace("/demo/","/thumb/200x121/demo/",$picurl);
?>
- <a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank">
<li class="realprice">￥<?=$nowprice?><a href="http://tuan.pcqc.com.cn/?view=<?=$id?>" target="_blank"><img alt="buy" src="images/buy.gif"/>
<li class="supprice">
<table> <tr> <td>原价</td> <td>折扣</td> <td>节省</td> </tr> <tr> <td><?=$price?></td> <td><?=$discount?>折</td> <td>￥<?=$jiesheng?></td> </tr> </table>
<?php
}
?>
<?php
function getpic($pic){ }
mysql_close($con);
?>
|
