将MySQL查询转换为Codeigniter语法 [英] converting MySQL query to Codeigniter syntax

问题描述

我有一个问题将MYSQL查询转换为CI语法。

I have some problem converting a MYSQL query to CI syntax.

这是我的MySQL语法：

This my MySQL syntax:

select a.pbj_name as 'NAMA PERUSAHAAN', count(a.id_pbj) as 'JUMLAH PAKET', group_concat(c.paket_kode) as 'PILIHAN PAKET'
from jed_pbj a
left join jed_paket_pbj b
       on a.id_pbj=b.id_pbj
left join jed_paket c
       on b.id_paket=c.id_paket
group by a.id_pbj

推荐答案

查看此 ActiveSign class in Codeigniter，

Check out this Active Record class in Codeigniter,

$this->db->select("a.pbj_name as 'NAMA PERUSAHAAN', count(a.id_pbj) as 'JUMLAH PAKET', group_concat(c.paket_kode) as 'PILIHAN PAKET'");
$this->db->from('jed_pbj a');
$this->db->join('jed_paket_pbj b', 'a.id_pbj=b.id_pbj', 'left');
$this->db->join('jed_paket c', 'b.id_paket=c.id_paket', 'left');
$this->db->group_by("a.id_pbj"); 
$this->db->get();

这篇关于将MySQL查询转换为Codeigniter语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！