如何在Zend Framework中使用GROUP_CONCAT? [英] How to use GROUP_CONCAT with Zend Framework?

问题描述

假设我有一张桌子:学生

Assume that I have a table : students

______________________________________________________
|id   | name           | school        | class        |
______________________________________________________
| 1   | John           | ABC           | C1           |
| 2   | Jack           | ABC           | C1           |
| 3   | Anna           | ABC           | C1           |
| 4   | Peter          | DEF           | D1           |
| 5   | Alex           | ABC           | C2           |
| 6   | Bryan          | ABC           | C2           |
| 7   | David          | ABC           | C2           |
| 8   | Cristian       | DEF           | D1           |
_______________________________________________________

使用此查询:

 SELECT a.class,GROUP_CONCAT(a.name) as names FROM students a WHERE a.school='ABC' GROUP BY a.class 

给我这个结果:

 ____________________________
|class  | names             |
 ____________________________
| C1    | John, Jack, Anna  |
| C2    | Alex, Bryan, David|
 ____________________________

如何使用Zend_Db_Table或Zend_Db_Select在Zend Framework中执行此查询? 非常感谢！

How can I execute this query in Zend Framework by using Zend_Db_Table or Zend_Db_Select? Thank you so much!

推荐答案

我想会是这样的.试试吧.

I guess it will be something like this. Try it.

$table = Your_DbTable_Class();
$select = $table->select()
          ->setIntegrityCheck(false)
          ->from(array('a' => 'students'), array( 'class' => 'class' , 'names' => new Zend_Db_Expr('GROUP_CONCAT(a.name)')) )
          ->where( 'a.school = ?', 'ABC' ) 
          ->group('a.class');

当我组装它时，它给了我以下查询:

When I assemble it, it gives me following query:

SELECT `a`.`class`, GROUP_CONCAT(a.name) AS `names` FROM `students` AS `a` 
WHERE (a.school = 'ABC')
GROUP BY `a`.`class`

是您要找的东西吗?

这篇关于如何在Zend Framework中使用GROUP_CONCAT?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！