如何用特殊字符迭代阵列

发布于 2025-01-30 12:52:06 字数 1354 浏览 1 评论 0原文

$referral_leaderboard = $db->query("SELECT referrer, COUNT(*) FROM users WHERE NOT referrer = '' GROUP BY referrer ORDER BY COUNT(*) DESC")->fetchAll();

这是由控制器设置的我的数组的值:

Array
(
    [0] => Array
        (
            [referrer] => 9b71b93bc24e6340
            [0] => 9b71b93bc24e6340
            [COUNT(*)] => 3
            [1] => 3
        )

    [1] => Array
        (
            [referrer] => 958b0ac6f9883951
            [0] => 958b0ac6f9883951
            [COUNT(*)] => 1
            [1] => 1
        )

    [2] => Array
        (
            [referrer] => 893134b7cb7a4146
            [0] => 893134b7cb7a4146
            [COUNT(*)] => 1
            [1] => 1
        )

)

上面的数组存储在此变量= $ revyral_leaderboard中,

因此当我在twig文件中打印它时,应该是这样的:{{referral_leaderboard}}

} }现在是我的树枝文件中的数组

,我想通过数组迭代,这是我的代码,但没有起作用:

{% for row in referral_leaderboard %}
    <tbody>
        <tr>
            <td>{{ row.referrer }}</td>
        </tr>

        <tr>
            <td>{{ row.COUNT(*) }}</td>
        </tr>
    </tbody>
    
{% endfor %}

编辑: Row.Referrer正在工作,但行(*)不起作用。也许是因为特殊字符(*)。因此,我尝试了此操作仍然不起作用row.count \(\*\)

$referral_leaderboard = $db->query("SELECT referrer, COUNT(*) FROM users WHERE NOT referrer = '' GROUP BY referrer ORDER BY COUNT(*) DESC")->fetchAll();

Here is the value of my array that is set up by the controller:

Array
(
    [0] => Array
        (
            [referrer] => 9b71b93bc24e6340
            [0] => 9b71b93bc24e6340
            [COUNT(*)] => 3
            [1] => 3
        )

    [1] => Array
        (
            [referrer] => 958b0ac6f9883951
            [0] => 958b0ac6f9883951
            [COUNT(*)] => 1
            [1] => 1
        )

    [2] => Array
        (
            [referrer] => 893134b7cb7a4146
            [0] => 893134b7cb7a4146
            [COUNT(*)] => 1
            [1] => 1
        )

)

The array above is stored in this variable = $referral_leaderboard

so when I print it in my twig file it should be like this: {{ referral_leaderboard }}

{{ referral_leaderboard }} is an Array

Now in my twig file, I want to iterate through the array, Here is my code but did not work:

{% for row in referral_leaderboard %}
    <tbody>
        <tr>
            <td>{{ row.referrer }}</td>
        </tr>

        <tr>
            <td>{{ row.COUNT(*) }}</td>
        </tr>
    </tbody>
    
{% endfor %}

EDIT:
row.referrer is working but row.COUNT(*) is not working. Maybe because of the special character (*). So i tried this still did not work row.COUNT\(\*\)

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文