如何使用 CodeIgniter 对 3 个表进行 INNER JOIN [英] How to INNER JOIN 3 tables using CodeIgniter

问题描述

谁能告诉我如何用php加入3个表?示例

Can someone Tell me how to join 3 table with php? Example

SELECT FROM table1, table2,table on INNERJOIN -------------------

让我有3张桌子.(问题表，答案表和类别表)这是我网页的示例.

let I have 3 table.(question table ,answer table and category table) Here is example form my webpage.

Time remaining 30 minutes(I will get "30 minutes" form Category table)
1. Question (from question table)
2. answer (from answer table)

我不知道如何加入 3 桌.

I don't know how to join 3 table.

推荐答案

应该是这样的，

$this->db->select('*');    
$this->db->from('table1');
$this->db->join('table2', 'table1.id = table2.id');
$this->db->join('table3', 'table1.id = table3.id');
$query = $this->db->get();

根据 CodeIgniters 活动记录框架

as per CodeIgniters active record framework

这篇关于如何使用 CodeIgniter 对 3 个表进行 INNER JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！