如何用特殊字符迭代阵列
$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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论