dprq18175 2013-11-04 22:07
浏览 139
已采纳

在foreach循环中运行第二个查询?

Need to run 2 queries inside a foreach but cant do it without errors.

So, i have this for showing comments:

$query = 'SELECT * FROM comments WHERE updatepostid = "' . $postID . '"';
    try {
        $stmt = $db->prepare($query);
        $stmt->execute();
        $countcomments = $stmt->rowCount();
        }
        catch (PDOException $ex) 
        {
            die("Failed to run query: " . $ex->getMessage());
        }

$rows = $stmt->fetchAll();
foreach ($rows as $row):
$commentID       = $row['commentID'];
$usercommentID   = $row['userID'];
$commentusername = ucfirst($row['commentusername']);
$comment         = ucfirst($row['comment']);
$updatepostid    = $row['updatepostid'];

<div class="textcomment">
    <?php
        echo "<a class='$rightscommentcolor'>$commentusername:</a>&nbsp; $comment";
    ?>
</div>


<?php endforeach; ?>

I then however want to run another query on the users database to check what rights the user has and then set the class of the comments username to that class.

That query would be e.g.

    <?php

$query2 = 'SELECT * FROM users WHERE id = "' . $usercommentID . '"';
    try {
        $stmt = $db->prepare($query2);
        $stmt->execute();
        }
        catch (PDOException $ex) 
        {
            die("Failed to run query: " . $ex->getMessage());
        }

$rows = $stmt->fetchAll();
foreach ($rows as $row):
$rights = $row['rights'];

if ($rights = '1') {
    $rightscommentcolor = 'userrights1';
} else if ($rights = '5') {
    $rightscommentcolor = 'userrights5';
}

?>
<?php endforeach; ?>

How is the proper way to go about this?

P.S. i understand that the above code will probably make people cry.

  • 写回答

2条回答 默认 最新

  • doubaran2438 2013-11-04 22:22
    关注

    You can join the tables in select as mentioned:

    <?php
    
    $query = "SELECT * FROM comments c
              JOIN users u ON u.usercommentID = c.userID
              WHERE updatepostid = :updatepostid";
        try {
            $stmt = $db->prepare($query);
            $stmt->execute();
            $countcomments = $stmt->rowCount();
            }
            catch (PDOException $ex) 
            {
                die("Failed to run query: " . $ex->getMessage());
            }
    
    $rows = $stmt->fetchAll();
    foreach ($rows as $row):
    
    $commentID       = $row['commentID'];
    $usercommentID   = $row['userID'];
    $commentusername = ucfirst($row['commentusername']);
    $comment         = ucfirst($row['comment']);
    $updatepostid    = $row['updatepostid'];
    
    if ($rights = '1') {
        $rightscommentcolor = 'userrights1';
    } else if ($rights = '5') {
        $rightscommentcolor = 'userrights5';
    }
    
    echo "<div class="textcomment"><a class='$rightscommentcolor'>$commentusername:</a>&nbsp; $comment</div>";
    
    endforeach;
    
    ?>
    

    You also could insert the second loop within the first and assign separate variables to that second loop so that it does not conflict with the first as below, but joining would be a better option:

    <?php
    
    $query = 'SELECT * FROM comments WHERE updatepostid = "' . $postID . '"';
        try {
            $stmt = $db->prepare($query);
            $stmt->execute();
            $countcomments = $stmt->rowCount();
            }
            catch (PDOException $ex) 
            {
                die("Failed to run query: " . $ex->getMessage());
            }
    
    $rows = $stmt->fetchAll();
    foreach ($rows as $row):
    
    $commentID       = $row['commentID'];
    $usercommentID   = $row['userID'];
    $commentusername = ucfirst($row['commentusername']);
    $comment         = ucfirst($row['comment']);
    $updatepostid    = $row['updatepostid'];
    
    $query2 = 'SELECT * FROM users WHERE usercommentID = "' . $usercommentID . '"';
        try {
            $stmt2 = $db->prepare($query2);
            $stmt2->execute();
            }
            catch (PDOException $ex2) 
            {
                die("Failed to run query: " . $ex2->getMessage());
            }
    
    $rows2 = $stmt2->fetchAll();
    foreach ($rows2 as $row2):
    $rights = $row2['rights'];
    
    if ($rights = '1') {
        $rightscommentcolor = 'userrights1';
    } else if ($rights = '5') {
        $rightscommentcolor = 'userrights5';
    }
    
    endforeach;
    
    echo "<div class="textcomment"><a class='$rightscommentcolor'>$commentusername:</a>&nbsp; $comment</div>";
    
    endforeach;
    
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 商城生产日期批次库存问题
  • ¥15 esp8266控制共阳极wrgb灯板无法关闭所有led灯
  • ¥100 python读取速度问题
  • ¥15 stm32f407使用DMA问题
  • ¥15 您好 这个API接口该怎么弄 网站搭建好了 API也有 现在就不知道该怎么填写API 不知道怎么用
  • ¥88 用uniapp写一个多端的程序,用到高德地图,用高德的JSAPI吗?
  • ¥20 关于#c++#的问题:水果店管理系统
  • ¥30 dbLinq最新版linq sqlite
  • ¥20 对D盘进行分盘之前没有将visual studio2022卸载掉,现在该如何下载回来
  • ¥15 完成虚拟机环境配置,还有安装kettle