开发者

Join more than two tables in codeigniter

开发者 https://www.devze.com 2023-02-28 01:22 出处:网络
I have 4 tables and i want to join there tables 开发者_如何学Gotogether in codeigniter. Is it possible with codeigniters join method?If you are using CodeIgniter\'s Active Record class, you can just u

I have 4 tables and i want to join there tables 开发者_如何学Gotogether in codeigniter. Is it possible with codeigniters join method?


If you are using CodeIgniter's Active Record class, you can just use the join method multiple times to join multiple tables.

$this->db->join('table2', 'table2.ID = table1.ID');
$this->db->join('table3', 'table3.ID = table1.ID');
$this->db->join('table4', 'table4.ID = table1.ID', 'left');


I assume that you are talking about joining SQL database tables, is this correct? If so you can always use the CodeIgniter SQL method, see: http://codeigniter.com/user_guide/database/queries.html

0

精彩评论

暂无评论...
验证码 换一张
取 消