内容超出PHP PDO [英] Content out of div PHP PDO

问题描述

我的子类别内容以某种方式越过了div。
第一个停留在那里，但是第二个，第三个等等离开它。

My content of the subcategories is getting out of the div somehow. The first one stays on there but the second, third etc is getting out from it.

任何解决方案？

<?php
...
$stmt = $dbh->query('SELECT parent.subcat_id, parent.subcat_name, child.subsubcat_name, child.subcat_id, child.cat_id FROM subcategories parent  JOIN subsubcategories child ON child.cat_id = parent.cat_id');
$lastcat = 0;
$stmt->execute();
$row2 = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($row2 as $row) {
    if($lastcat != $row['cat_id']){
        $lastcat = $row['cat_id'];
        echo '<div class="panel panel-default">
              <div class="panel-heading">';
        echo $row['subcat_name'];
        echo '</div><div class="panel-body">';
    }
    echo $row['subsubcat_name'];
    echo "</div></div>";
}

?>

推荐答案

这应该改写为：

$close_previous = false;    // special flag
foreach ($row2 as $row) {
    if ($lastcat != $row['cat_id']) {
        $lastcat = $row['cat_id'];

        // check whether you need to close divs from previous block
        if ($close_previous) {
            echo '</div>'; // close .panel-body 
            echo '</div>'; // close .panel-default
        } else {
            // for the first time you don't need 
            // to close divs, so here we skip it
            $close_previous = true;
        }

        echo '<div class="panel panel-default"><div class="panel-heading">';
        echo $row['subcat_name'];
        echo '</div><div class="panel-body">';
    }
    echo $row['subsubcat_name'];
    // add link
    echo '<a href="/test.php?id=' . $row['subcategoryid'] . '">Click</a>';
}

// explicitly close last divs block
echo '</div>'; // close .panel-body 
echo '</div>'; // close .panel-default

此外，最好检查一下您生成的html标记以查看什么是错的。

Also it's a good practice to check your generated html-markup to see what is wrong.

这篇关于内容超出PHP PDO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！