查询生成器中的CodeIgniter子查询 [英] CodeIgniter Subquery in Query Builder

问题描述

有没有办法或有人可以将其翻译为代码点火器查询生成器.

Is there a way or can someone translate this to code igniter query builder.

SELECT result.id, result.name, result.added
FROM (SELECT tbl.id, tbl.name, tbl.date_added
      FROM table tbl
      GROUP BY tbl.id) result
GROUP BY result.date_added

我已经进行了研究(下面的链接)，但是找不到类似的内容(上面的查询). https://www.codeigniter.com/userguide3/database/query_builder.html

I already have my research(link below) but can't find anything like this(query above). https://www.codeigniter.com/userguide3/database/query_builder.html

https://arjunphp.com/how-在codeigniter-active-record/

是的，这可以使用存储过程来完成，但是我还有另一个原因需要将其作为查询生成器来实现.

And yes, this can be done using Stored Procedure but I have another reason why I need to implement this as query builder.

推荐答案

尝试这个.

// Sub Query
         $this->db->select('result.id, result.name, result.added')->from('table tbl');
     $subQuery =  $this->db->get_compiled_select();

// Main Query
     $this->db->select('result.id, result.name, result.added')
     ->from('table tbl')
     ->where("id IN ($subQuery)", NULL, FALSE)
     ->get()
     ->result();

这篇关于查询生成器中的CodeIgniter子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！