基于php+mysql购物商城 校园二手商品 图书鲜花商城 毕业设计(9)商品评论

it2024-01-11  59

效果图

代码

<!doctype html> <html> <head> <meta charset="utf-8"> <title>黄菊华:H5+CSS3商城界面实战-产品详情</title> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="css/chanpin_xiangqing.css"> </head> <body <?php require "conn.php"; ?> <!--头部菜单--> <div class="toubu"> <a class="toubu_caidan" href="cp_xinxi1.php?cs_id=<?php echo $_GET["cs_id"] ?>">商品</a> <a class="toubu_caidan" href="cp_xinxi2.php?cs_id=<?php echo $_GET["cs_id"] ?>">详情</a> <a class="toubu_caidan toubu_caidan_xuanzhong">评论</a> </div> <?php //根据id读取要修改的信息内容 $sql_xg="select * from shangpin where id=".$_GET["cs_id"]; $jieguo_xg=mysqli_query($conn,$sql_xg); if(!$jieguo_xg){ die("不能获取数据"); } $xg_mingcheng=""; $xg_lx_id1=0; $xg_lx_id2=0; $xg_kucun=0; $xg_yixiaoshou=0; $xg_jiage1=0; $xg_jiage2=0; $xg_jiage3=0; $xg_cp_tupian=""; $xg_cp_tupian_yn=0; //有产品附图,默认0没有,1有 $xg_cp_tupian1=""; $xg_cp_tupian2=""; $xg_cp_tupian3=""; $xg_cp_tupian4=""; $xg_zhuangtai_yn=0; //0默认在销,1下架 $xg_tuijian_yn=0; //0默认不首页推荐,1首页推荐 $xg_jianjie_yn=0; //0默认,1有 $xg_jianjie=""; $xg_neirong=""; $xg_fabu_riqi=""; //$xg_=""; while ($row_xg=mysqli_fetch_array($jieguo_xg,MYSQLI_ASSOC)){ //echo "{$row["id"]}"."{$row["cn"]}"."{$row["en"]}"."<br>"; $xg_mingcheng=$row_xg["mingcheng"]; $xg_lx_id1=$row_xg["lx_id1"]; $xg_lx_id2=$row_xg["lx_id2"]; $xg_kucun=$row_xg["kucun"]; $xg_yixiaoshou=$row_xg["yixiaoshou"]; $xg_jiage1=$row_xg["jiage1"]; $xg_jiage2=$row_xg["jiage2"]; $xg_jiage3=$row_xg["jiage3"]; $xg_cp_tupian=$row_xg["cp_tupian"]; $xg_cp_tupian_yn=$row_xg["cp_tupian_yn"]; //有产品附图,默认0没有,1有 $xg_cp_tupian1=$row_xg["cp_tupian1"]; $xg_cp_tupian2=$row_xg["cp_tupian2"]; $xg_cp_tupian3=$row_xg["cp_tupian3"]; $xg_cp_tupian4=$row_xg["cp_tupian4"]; $xg_zhuangtai_yn=$row_xg["zhuangtai_yn"];; //0默认在销,1下架 $xg_tuijian_yn=$row_xg["tuijian_yn"];; //0默认不首页推荐,1首页推荐 $xg_jianjie_yn=$row_xg["jianjie_yn"];; //0默认,1有 $xg_jianjie=$row_xg["jianjie"]; $xg_neirong=$row_xg["neirong"]; $xg_fabu_riqi=$row_xg["fabu_riqi"]; //$xg_=$row[""]; } ?> <div class="qukuai"> <?php //获取参数 $sql_num =""; $cp_id = $_GET["cs_id"]; //根据条件组合sql语句 $sql_num = "select count(*) from huiyuan_pingjia where cpid=" . $cp_id ; $sql_num2 = "select * from huiyuan_pingjia where cpid=" . $cp_id . " order by id desc" ; //echo $sql_num . "<br>"; $result_num = mysqli_query($conn,$sql_num); $rows_num = mysqli_fetch_row($result_num); $num = $rows_num[0]; //echo "总的数:". $num . "<br>"; /循环显示数据 $jieguo=mysqli_query($conn,$sql_num2); if(!$jieguo){ die("不能获取数据"); } $xuhao=0; while ($row=mysqli_fetch_array($jieguo,MYSQLI_ASSOC)) { $xuhao = $xuhao +1; $huiyuan_xinxi = ""; $sql_hyid="select * from huiyuan where id=".$row["u_id"]; $jieguo_hyid=mysqli_query($conn,$sql_hyid); if(!$jieguo_hyid){ die("不能会员信息"); } while ($row_hyid=mysqli_fetch_array($jieguo_hyid,MYSQLI_ASSOC)) { if(empty($row_hyid["wx_nicheng"])){ $huiyuan_xinxi = substr($row_hyid["shouji"],0,8)."***"; }else{ $huiyuan_xinxi = $row_hyid["wx_nicheng"]; } } ?> <div class="pinglun"> <div class="pinglun_tou"> <img src="tupian/touxiang.jpg" class="pinglun_tou_img" /> <p class="pinglun_tou_nicheng"><?php echo $huiyuan_xinxi ?></p> <p class="pinglun_tou_shijian"><?php echo $row["riqi"] ?></p> </div> <div class="pinglun_zhong"> <div class="pinglun_zhong_xing"> <?php for ($x=0; $x<=(int)$row["xing"]-1; $x++) { ?> <img src="img/xing0.png" class="pinglun_zhong_xing_img"/> <?php } ?> </div> <div class="pinglun_zhong_neirong"> <?php echo $row["neirong"] ?> </div> </div> </div> <div class="gaodu10"></div> <?php } ?> </div> <!--底部菜单--> <?php include 'cp_dibu.php'; ?> </body> </html>
最新回复(0)