How to INNER JOIN 3 tables using CodeIgniter

Question

Can someone Tell me how to join 3 table with php  Example  SELECT FROM table1  table2 table on INNERJOIN -------------------   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    I don t know how to join 3 table

User · Answer

I think in CodeIgniter the best to use ActiveRecord as wrote above  One more thing  you can use method chaining in AR    this- gt db- gt select     - gt from  table1  - gt join  table2   table1 id table2 id  - gt

User · Answer

this- gt db- gt select            this- gt db- gt from  table1     this- gt db- gt join  table2    table1 id   table2 id    inner     this- gt db- gt join  table3    table1 id   table3 id    inner     this- gt db- gt where  table1    id     query    this- gt db- gt get        Where you can specify which id should be viewed or select in specific table  You can also select which join portion either left  right  outer  inner  left outer  and right outer on the third parameter of join method

User · Answer

I created a function to get an array with the values   for the fields and to join  This goes in the model     public function GetDataWhereExtenseJoin  table  fields  data          pega os campos passados para o select     foreach  fields as  coll   gt   value            this- gt db- gt select  value               pega a tabela      this- gt db- gt from  table         pega os campos do join     foreach  data as  coll   gt   value            this- gt db- gt join  coll   value               obtem os valores      query    this- gt db- gt get          retorna o resultado     return  query- gt result         This goes in the controller    data field   array           NameProduct    gt   product IdProduct            IdProduct    gt   product NameProduct            NameCategory    gt   category NameCategory            IdCategory    gt   category IdCategory                  data join   array                        product    gt   product category IdProduct   product IdProduct                          category    gt   product category IdCategory   category IdCategory                          product    gt   product category IdProduct   product IdProduct                              product category    this- gt mmain- gt GetDataWhereExtenseJoin  product category    data field   data join     result   echo   lt pre gt        print r  product category       die

User · Answer

I believe that using CodeIgniters active record framework that you would just use two join statements one after the other  eg    this- gt db- gt select        this- gt db- gt from  table1     this- gt db- gt join  table1    table1 id   table2 id     this- gt db- gt join  table1    table1 id   table3 id     query    this- gt db- gt get      Give that a try and see how it goes

User · Answer

function fetch comments  ticket id        this- gt db- gt select  tbl tickets replies comments              tbl users username tbl roles role name         this- gt db- gt where  tbl tickets replies ticket id   ticket id        this- gt db- gt join  tbl users   tbl users id   tbl tickets replies user id         this- gt db- gt join  tbl roles   tbl roles role id tbl tickets replies role id        return  this- gt db- gt get  tbl tickets replies

User · Answer

this- gt db- gt select            this- gt db- gt from  table1     this- gt db- gt join  table2    table1 id   table2 id   JOIN Type     this- gt db- gt join  table3    table1 id   table3 id     query    this- gt db- gt get         this will give you result from table1 table2 table3 and you can use any type of join in the third variable of  this- db- join   function such as inner left  right etc

User · Answer

you can modiv your coding like this     this- gt db- gt select  a nik b nama a inv c cekin c cekout a tunai a nontunai a id      this- gt db- gt select  DATEDIFF  c cekout  c cekin  as lama      this- gt db- gt select   DATEDIFF  c cekout  c cekin  c total  as tagihan      this- gt db- gt from  bayar as a      this- gt db- gt join  pelanggan as b    a nik   b nik      this- gt db- gt join  pesankamar h as c    a inv   c id      this- gt db- gt where  a user id   id     query    this- gt db- gt get     return  query- gt result      i hope can be resolve your SQL

User · Answer

For executing pure SQL statements  I Don t Know About the FRAMEWORK- CodeIGNITER     you can use SUB QUERY  The Syntax Would be as follows  SELECT t1 id FROM example t1 INNER JOIN   select id from  example2 t1 join example3 t2 on t1 id   t2 id   as t2 ON t1 id   t2 id   Hope you Get My Point

User · Answer

it should be like that        this- gt db- gt select            this- gt db- gt from  table1     this- gt db- gt join  table2    table1 id   table2 id     this- gt db- gt join  table3    table1 id   table3 id     query    this- gt db- gt get      as per  CodeIgniters active record framework

[php] How to INNER JOIN 3 tables using CodeIgniter

Examples related to php

Examples related to mysql

Examples related to codeigniter