产品添加页代码

最新推荐文章于 2024-03-10 22:57:25 发布

萌球球Q

最新推荐文章于 2024-03-10 22:57:25 发布

阅读量666

点赞数

分类专栏：代码

本文链接：https://blog.youkuaiyun.com/mengqiuqiuq/article/details/12656171

版权

代码专栏收录该内容

16 篇文章

订阅专栏

<?php
include "../include/head.php";
include "../include/cn.php";
include "../include/fun.php";
include "../esifsf/fckeditor.php";
$sql="select * from product order by id desc";
$rs=mysql_query($sql);
?>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<body>
<table width="1048" border="1" align="center" cellpadding="1" cellspacing="1">
<tr>
    <td width="927" align="center">产品管理目录</td>
</tr>
<tr>
    <td><table width="100%" border="1" cellpadding="1" class="fontblack12">
      <tr>
        <td align="center" class="bgc">产品名称</td>
        <td align="center" class="bgc">产品价格</td>
        <td align="center" class="bgc">产品图片</td>
        <td align="center" class="bgc">一级分类</td>
        <td align="center" class="bgc">二级分类</td>
        <td align="center" class="bgc">三级分类</td>
        <td align="center" class="bgc">简介</td>
        <td align="center" class="bgc">推荐</td>
        <td align="center" class="bgc">热卖</td>
        <td align="center" class="bgc">删除</td>
        <td align="center" class="bgc">修改</td>
      </tr>
<?php
   while ($row=mysql_fetch_array($rs))
   {
    $rr=explode(",",$row["pic"]);
    $c=count($rr)-1;
    $sql3="select * from product_class where id=".$row["class"];
    $rs3=mysql_query($sql3);
    $row3=mysql_fetch_array($rs3);
    $sql2="select * from product_class where id=".$row3["pid"];
    $rs2=mysql_query($sql2);
    $row2=mysql_fetch_array($rs2);
    $sql1="select * from product_class where id=".$row2["pid"];
    $rs1=mysql_query($sql1);
    $row1=mysql_fetch_array($rs1);
    if ($row["tuijian"]==1)
    {
     $tuijian="是";
     }
     else{
      $tuijian="否";
      }
     if ($row["hotmai"]==1)
    {
     $hotmai="是";
     }
     else{
      $hotmai="否";
      }
      ?>
      <tr>
        <td align="center"><?php echo $row["title"]?></td>
        <td align="center"><?php echo $row["price"]?></td>
        <td align="center"><table width="33" border="0" cellspacing="0">
           <?php
       for ($i=0; $i<$c; $i++)
      {
             ?>
          <tr>
             <td width="31"><img src="img/<?php echo $rr[$i]?>" width="50" height="50"></td>
           </tr>
           <?php
       }
          ?>
     </table>
     </td>
        <td align="center"><?php echo $row1["title"]?></td>
        <td align="center"><?php echo $row2["title"]?></td>
        <td align="center"><?php echo $row3["title"]?></td>
        <td align="center"><?php echo $row["content"]?></td>
        <td align="center"><?php echo $tuijian?></td>
        <td align="center"><?php echo $hotmai?></td>
        <td align="center"><a href="del.php?id=<?php echo $row["id"]?>" onClick="return confirm('确定删除吗')">删除</a></td>
        <td align="center"><a href="up.php?id=<?php echo $row["id"]?>" onClick="return confirm('确定修改吗')">修改</a></td>
      </tr>
      <?php
   }
   ?>
    </table></td>
</tr>
</table>
</body>
</html>