query builder with different database, join

query builder with different database, join - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: query builder with different database, join (/showthread.php?tid=76191)

query builder with different database, join - gidro - 04-20-2020

Hi, friends!

Example:

Code:
SELECT t1.*, t2.*

FROM database1.table1 AS t1

INNER JOIN database2.table2 AS t2 ON t2.field1 = t2.field1

How i can do this query with query builder in CodeIgniter 3/4 ?

Thanks for answers.

RE: query builder with different database, join - gidro - 05-02-2020

Nobody really knows how to do this?

RE: query builder with different database, join - php_rocs - 05-03-2020

@gidro,

Try using query binding ( https://codeigniter.com/userguide3/database/queries.html?highlight=query#query-bindings ).