dede织梦系统html页面多表联查，下面主要介绍2表联查

最新推荐文章于 2022-12-22 12:15:05 发布

阔意

最新推荐文章于 2022-12-22 12:15:05 发布

阅读量130

点赞数

分类专栏： dedecms 文章标签： html php 前端

本文链接：https://blog.csdn.net/weixin_43130145/article/details/125327284

版权

dedecms 专栏收录该内容

4 篇文章 1 订阅

订阅专栏

先看一段代码截图：

以下为截图中PHP代码：

<?php
$sql = "SELECT * FROM dede_two_wechat as a,dede_member_wechat as b where a.oia=b.openid";
$dsql->SetQuery($sql);//将SQL查询语句格式化
$dsql->Execute();//执行SQL操作
   while($row1 = $dsql->GetArray()){
       echo "<tr height='26' align='center' bgcolor='#FFFFFF';>";
       echo "       <td><input name='id' type='checkbox' id='id' value=".$row1['id']." class='np' /></td>";
       echo "       <td>".$row1['id']."</td>";

       if($row1['nickname']){echo "<td>".$row1['nickname']."</td>";}else{echo "<td style='font-weight:bolder;color:red;'>拉斯达克指数</td>";}
       if($row1['headimgurl']){echo "<td><img src=".$row1['headimgurl']." width='25px' height='25px'></td>";}else{echo "<td style='font-weight:bolder;color:red;'>特殊符号</td>";}

       if($row1['sex']==1){echo "<td>男</td>";}elseif($row1['sex']==2){echo "<td>女</td>";}else{echo "<td>未知</td>";}
       echo "       <td>".$row1['oia']."</td>";
       echo "       <td>".$row1['price']."</td>";
       if($oib=$row1['oib']){
           $row = $dsql->GetOne("SELECT nickname,sex,headimgurl FROM dede_member_wechat where openid='$oib'");
           if($row['nickname']){echo "<td>".$row['nickname']."</td>";}else{echo "<td style='font-weight:bolder;color:red;'>拉斯达克指数</td>";}
           if($row['headimgurl']==NULL){echo "<td><img src='http://www.gs110.online/wechat/myhome/teemhead.jpg' width='25px' height='25px'></td>";}else{echo "<td><img src=".$row['headimgurl']." width='25px' height='25px'></td>";}
       }else{echo "       <td>暂无</td>";}

       if($row['sex']==1){echo "<td>男</td>";}elseif($row['sex']==2){echo "<td>女</td>";}else{echo "<td>未知</td>";}
       echo "       <td>".$row1['oib']."</td>";
       echo "       <td>".$row1['datetime']."</td>";
       echo "       <td>".$row1['time']."</td>";
       echo "       <td><a href='http://www.gs110.online/wechat/dede/fenddian.php?oib=".$row1['oib']."&oia=".$row1["oia"]."'>【DEL】</a></td>";
       echo "</tr>";
   }
?>