How to execute my SQL query in CodeIgniter

Question

I have a problem with my query and I need to join two tables from different databases now my problem is how can I execute my query  I got my syntax format from here   Please visit first this link so you could understand why my SQL syntax is like this http   www x-developer com php-scripts sql-connecting-multiple-databases-in-a-single-query  Im using CodeIgniter and here is an Idea of what my query looks like  Notice the way I m selecting my columns   DATABASE NAME TABLE NAME COLUMN NAME   ENROLLEES    this- gt load- gt database  ENROLLEES   TRUE    ACCOUNTS     this- gt load- gt database  ACCOUNTS   TRUE     SELECT       SELECT  ACCOUNTS BALANCES TABLE IDNO   ACCOUNTS BALANCES TABLE balance    FROM         FROM  ACCOUNTS BALANCES TABLE    WHERE         ACCOUNTS BALANCES TABLE IDNO IN  SELECT  ENROLLEES ENROLLEES TABLE IDNO FROM  ENROLLEES ENROLLEES TABLE      SQL          SELECT        FROM        WHERE    MAIN PROBLEM  How to Execute my query  If we do like this in codeIgniter    ENROLLEES- gt query  SQL   or  ACCOUNTS- gt query  SQL     How can I execute my query that Im having multiple databases  What will I provide here database - gt query  SQL

User · Answer

If the databases share server  have a login that has priveleges to both of the databases  and simply have a query run similiar to    query    this- gt db- gt query   SELECT t1    t2 id FROM  database1   table1  AS t1   database2   table2  AS t2       Otherwise I think you might have to run the 2 queries separately and fix the logic afterwards

User · Answer

http   www bsourcecode com codeigniter codeigniter-select-query     query    this- gt db- gt query  select   from tbl user         OR    query    this- gt db- gt select                    this- gt db- gt from  table name                 query  this- gt db- gt get

User · Answer

I can see what     aw mentioned     ENROLLEES    this- gt load- gt database  ENROLLEES   TRUE    ACCOUNTS    this- gt load- gt database  ACCOUNTS   TRUE     CodeIgniter supports multiple databases  You need to keep both database reference in separate variable as you did above  So far you are right correct   Next you need to use them as below    ENROLLEES- gt query     ENROLLEES- gt result      and    ACCOUNTS- gt query     ACCOUNTS- gt result      Instead of using    this- gt db- gt query     this- gt db- gt result      See this for reference  http   ellislab com codeigniter user-guide database connecting html

User · Answer

return  this- gt db- gt select   CASE              enter code hereWHEN orderdetails ProductID   0   THEN dealmaster deal name             WHEN orderdetails DealID   0 THEN products name             END  as product name

User · Answer

this- db- select  id  name  price  author  category  language  ISBN  publish date             this- gt db- gt from  tbl books

User · Answer

sql  quot Select   from my table where 1 quot            query    this- gt db- gt query  SQL       return  query- gt result array

[php] How to execute my SQL query in CodeIgniter

Examples related to php

Examples related to sql

Examples related to codeigniter

Examples related to join

Examples related to multiple-databases