php - 如何在codeigniter中加入两个数据库

Question

我在使用 codeigniter 连接这两个数据库时遇到了问题，我尝试使用 mysql 进行了尝试，它成功了。

谁能把它转换成codeigniter

这是我的代码

SELECT DATE_FORMAT(FROM_UNIXTIME(ex.extime), '%Y-%m-%d') as `export_report`, u.username as `Username`, ex.qdesc as `Search_Performed`,
                 ex.to as `Number_of_records_exported`, ex.format as `Format`
                 FROM cone.users u
                 INNER JOIN igdata.export_status as ex
                 ON u.id = ex.uid
                 WHERE DATE_FORMAT(FROM_UNIXTIME(ex.extime), '%Y-%m-%d') = '{$dateToday}'
                 ORDER BY u.username ASC

我也把它放在我的构造函数中

private $cone_read;
private $ixdata;

function __construct()
{
    // Call the Model constructor
    parent::__construct();

    $this->cone_read = $this->load->database('cone_read', TRUE);
    $this->ixdata = $this->load->database('cone_us', TRUE);

}

Answer 1

试试这个:

        $this->db->select("DATE_FORMAT(FROM_UNIXTIME(ex.extime), '%Y-%m-%d') as export_report, u.username as Username, ex.qdesc as Search_Performed, ex.to as Number_of_records_exported, ex.format as Format");    
        $this->db->from('cone.users u');
        $this->db->join('igdata.export_status as ex', 'u.id = ex.uid');
        $this->db->where("DATE_FORMAT(FROM_UNIXTIME(ex.extime), '%Y-%m-%d') = '$dateToday'");
        $this->db->order_by("u.username", "asc");
        $query = $this->db->get();