PHP：循环分组的 SQL 查询数组，但为每个“分组”回显一个值一次？

发布于 2024-12-17 15:24:42 字数 1209 浏览 0 评论 0原文

我已经尝试了几个小时来思考一小段代码。

我正在尝试创建一个检索一些元素的查询，并最终通过选择器对它们进行分组。我将尝试演示：我正在查询组织中的所有成员。每个成员都是一个“部门”的成员，每个部门可以有多个成员，但每个成员只能有一个部门。

因此，我创建了查询来按部门选择组织组中的所有成员。

当我使用简单的 foreach($my_query as $q) ... 显示它时，我想输出 $q->department_name 但只为该部门输出一次。现在，所有五个成员下面都显示“营销”，然后所有这些成员都变为“人力资源”。我尝试了一些不同的方法，例如 array_unique，创建一个函数来检查字符串以查看它是否相同，但没有结果。

我可以创建两个 foreach 循环，但如果可能的话，我宁愿不这样做，因为两个 foreach 循环会影响性能。

任何帮助或建议将非常感激。

真诚地
- 梅斯蒂卡

--- 编辑 --- 顺便说一句，我的查询如下所示：

SELECT * 
FROM wp_term_taxonomy AS cat_term_taxonomy
INNER JOIN wp_terms AS cat_terms ON cat_term_taxonomy.term_id = cat_terms.term_id
INNER JOIN wp_term_relationships AS cat_term_relationships ON cat_term_taxonomy.term_taxonomy_id = cat_term_relationships.term_taxonomy_id
INNER JOIN wp_posts AS cat_posts ON cat_term_relationships.object_id = cat_posts.ID
INNER JOIN wp_postmeta AS meta ON cat_posts.ID = meta.post_id
WHERE cat_posts.post_status =  'publish'
AND meta.meta_key =  'active'
AND meta.meta_value =  'active'
AND cat_posts.post_type =  'member'
AND cat_term_taxonomy.taxonomy =  'deparment'
GROUP BY cat_terms.slug, cat_term_relationships.object_id

原文

I’ve a small piece of code I’ve tried to wrap my brain around for some hours now.

I’m trying to create a query which retrieves some elements and in the end group them by a selector.
I’ll try to demonstrate: I’m querying all the members in my organization. Each member is a member of a “department” and there can be several members in each department, but only one department for each member.

So I’ve created the query to select all members in my organization group by departments.

When I’m displaying it using a simple foreach($my_query as $q) … I want to output $q->department_name but only once for that department. Right now it says “Marketing” under all five members and then it changes to “HR” for all those members. I’ve tried some different methods such as array_unique, creating a function that checks for the string to see if it is the same and other but with no result.

I could create two foreach loops but if it is at all possible not to I would prefer that because two foreach loops would affect the performance.

Any help or suggestion would be very much appreciated.

Sinerely
- Mestika

--- Edited ---
By the way, my query looks like this:

SELECT * 
FROM wp_term_taxonomy AS cat_term_taxonomy
INNER JOIN wp_terms AS cat_terms ON cat_term_taxonomy.term_id = cat_terms.term_id
INNER JOIN wp_term_relationships AS cat_term_relationships ON cat_term_taxonomy.term_taxonomy_id = cat_term_relationships.term_taxonomy_id
INNER JOIN wp_posts AS cat_posts ON cat_term_relationships.object_id = cat_posts.ID
INNER JOIN wp_postmeta AS meta ON cat_posts.ID = meta.post_id
WHERE cat_posts.post_status =  'publish'
AND meta.meta_key =  'active'
AND meta.meta_value =  'active'
AND cat_posts.post_type =  'member'
AND cat_term_taxonomy.taxonomy =  'deparment'
GROUP BY cat_terms.slug, cat_term_relationships.object_id

分享到QQ

分享到微博

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

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

童话里做英雄 2024-12-24 15:24:42

$prev_department = NULL;

foreach ($my_query AS $q)
{
  if ($prev_department != $q->department_name)
    echo '<h2>'. htmlentities($q->department_name, ENT_COMPAT, 'UTF-8') .'</h2>';

  // ...

  $prev_department = $q->department_name;
}

$prev_department = NULL;

foreach ($my_query AS $q)
{
  if ($prev_department != $q->department_name)
    echo '<h2>'. htmlentities($q->department_name, ENT_COMPAT, 'UTF-8') .'</h2>';

  // ...

  $prev_department = $q->department_name;
}

回复收藏 0 原文

~没有更多了~