PHP MySQL - 每 6 行插入一个 div?

2024-04-12

PHP:

<?php
$stmt = $db->prepare("SELECT * FROM `users`");
$stmt->execute();
$result = $stmt->get_result();

//<div class="ui stackable six cards">

if($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    echo $one[] = "image div".$row["avatar"]."image div";
    echo $two[] = "content div".$row["username"]."content div";
  }
  echo "</table>";
}
$stmt->close();
?>

HTML:

<div class="ui center aligned stackable grid container" style="padding: 4em !important;">
                <div class="center aligned row">
                    <div class="column">
                        <h2 class="header">Members </h2>
                    </div>
                </div>

                <div class="ui stackable six cards">
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>

                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>

                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>

                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                </div>

                <div class="ui stackable six cards">
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>

                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>

                    <div class="ui card small">
                        <div class="image">
                            <img src="assets/img/players/.jpg">
                        </div>

                        <div class="content">
                            <a class="header"></a>
                        </div>
                    </div>
                </div>
            </div>

所以基本上我需要弄清楚的是我到底如何得到

//<div class="ui stackable six cards">

每次达到 6 行时都会回显!这可能吗?

我想我会使用 foreach 循环?

我需要它做的是从数据库中回显头像和用户名并将其放在我的 HTML 代码中,我可以做得很好。

但问题是我不知道如何让它每 6 行添加一次(最后添加一个)

附:我英语说得不太好,所以我真的希望你明白我的意思!


我将参考这个问题,因为这是您所需要的:检查一个数字是否能被 6 整除 PHP https://stackoverflow.com/questions/2090475/checking-if-a-number-is-divisible-by-6-php

你的逻辑基本上应该是:如果一个数字可以被 6 整除,则做某事,否则做其他事。

if ($row_number % 6 == 0) {
    // Row number is 6, 12, 18 and so on
} else {
    // Other rows
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

PHP MySQL - 每 6 行插入一个 div? 的相关文章

随机推荐