Codeigniter Query Builder Class

Question

I am beginner in using codeigniter query builder class. and I got a problem in converting this query using query builder class.

SELECT tb_country.`countryName`, COUNT(tb_country.countryId) AS totalCustomer FROM tb_customer 
    JOIN tb_city ON tb_city.`cityId` = tb_customer.`cityId`
    JOIN tb_state ON tb_state.`stateId` = tb_city.`stateId`
    JOIN tb_country ON tb_country.`countryId` = tb_state.`countryId`
GROUP BY tb_country.`countryName`

any answers will be helpful to me, thanks in advance!

puncoz · Accepted Answer · 2017-01-01 17:26:20Z

1

$this->db
     ->select("tb_country.countryName, COUNT(tb_country.countryId) AS totalCustomer", false)
     ->from('tb_customer')
     ->join('tb_city', 'tb_city.cityId = tb_customer.cityId')
     ->join('tb_state', 'tb_state.stateId = tb_city.stateId')
     ->join('tb_country', 'tb_country.countryId = tb_state.countryId')
     ->group_by('tb_country.countryName')
     ->get()
     ->result();

edited Jan 1, 2017 at 17:26

answered Jan 1, 2017 at 17:12

puncoz

4972 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Alexander David Over a year ago

what is the meaning of 'true' in the third parameter of select function?

puncoz Over a year ago

sorry it should be false. it means codeigniter not to protect the select statement. it is required because, there is compound select statement, i.e count() in our select, hence set that second argument to false

puncoz Over a year ago

check once whether it works or not, these days i am not using codeigniter so i m not sure.

Alexander David Over a year ago

I think the third parameter is not required, it still works even after I remove it. But, thanks man it works!

Collectives™ on Stack Overflow

Codeigniter Query Builder Class

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related