我正在循环浏览一个结果数组,但是结果中有重复名称的行。有没有办法只回显一次名称。解决方案可能微不足道,但目前我被难住了。
这是代码:
$service_query = $this->db->query('SELECT service_id, server_id, port, comment FROM services');
foreach ($service_query->result() as $service)
{
$server_query = $this->db->query('SELECT server_id, name, host FROM servers WHERE server_id =' . $service->server_id);
foreach ($server_query->result() as $server)
{
echo $server->name;
echo $service->comment;
echo $server->host;
echo $service->port;
echo '<br>';
}
}
结果如下:
Mail Server IMAP (Secure) XXX.XXX.XXX.XXX:993
Mail Server POP3 (Secure) XXX.XXX.XXX.XXX:995
Mail Server POP3 XXX.XXX.XXX.XXX:110
Mail Server IMAP XXX.XXX.XXX.XXX:143
Web Server Apache XXX.XXX.XXX.XXX:80
仅供参考,我正在为这个项目使用代码点火器框架。
试试这个:
$query = $this->db->query('SELECT name, service_id, server_id, host, port, comment
FROM services
LEFT JOIN servers USING (server_id)
ORDER BY servers.name');
$server_name = '';
foreach ($query->result() as $server)
{
if($server_name != $server->name) {
echo $server->name;
$server_name = $server->name;
}
else { echo '-/-/-' };
echo $server->comment;
echo $server->host;
echo $server->port;
echo '<br>';
}
我通过在$service之前查询数据库中的$server并在前面的循环中回显$server->name来解决此问题。这是我的解决方案。感谢大家的快速回答。
$server_query = $this->db->query('SELECT server_id, name, host FROM servers');
foreach ($server_query->result() as $server)
{
echo $server->name;
$service_query = $this->db->query('SELECT service_id, server_id, port, comment FROM services WHERE server_id =' . $server->server_id);
foreach ($service_query->result() as $service)
{
echo $service->comment;
echo $server->host;
echo $service->port;
echo '<br>';
}
}
您的意思是"邮件服务器"数据是重复的吗? 如果是这样,请考虑在查询中使用MySQL DISTINCT
来删除重复项,请参阅此处的示例。
因为我了解您需要什么。 就像
它在你的 SQL 语法中
改变它
'SELECT server_id, name, host FROM servers WHERE server_id =' . $service->server_id .' GROUP BY name'