php - Codeigniter 加入来自 2 个数据库的表

Question

是否可以连接来自不同数据库的 2 个表？

这是我的问题

public function getschedule($section){
    $this->dbsections->select('*');
    $this->dbsections->from($section);

    //I want to join the column "teacher" of the "section_name" table that is in the "dbsections" database
    //to the "id" column of the "teachers" table in the "dbusers" database

    $this->dbsections->join('teachers', 'teachers.ID = '.$section.'.TEACHER');
    $query = $this->dbsections->get();

    $query = $this->dbsections->get();
    return $query->result_array();
}

显然，这段代码给我错误。我也试过了

$this->dbsections->join('dbusers.teachers', 'teachers.ID = '.$section.'.TEACHER');

和

$this->dbsections->join('dbusers.teachers', 'teachers.ID = dbsections.'.$section.'.TEACHER');

但两者都给我错误

Error Number: 1096

No tables used

SELECT *

Answer 1

在 select * as 中需要表名

$this->dbsections->select("$section.*");// write tour table name before *

并删除一次

   //  $query = $this->dbsections->get();