Code for CI to operate multiple databases in php_PHP tutorial

In fact, this is not a difficult task. Because I just started CI, it still took a lot of trouble. Fortunately there is a manual.

Find the database configuration file and add the connection information of a new library. $config[XX].
In the controller,
a) $this->xx = $this->load->database('XX', TRUE) tip:XX represents the key name of the database information array you configured , it is recommended to set it to TRUE later, which means returning the connection ID and enabling the ActionRecord class
b) Then in the controller you can use $this->xx->query() to query your other library data. There is no need to create a model file for your other library

Copy the code The code is as follows:

function __construct()
{
parent::__construct();
$this->xx = $this->load->database('XX', TRUE);
$this->load->model('Default library table name');
}
function index()
{
//Now you can use $this->xx-> ;query() to execute the sql of XX library
$this->xx->query($sql);
}
?>

http://www.bkjia.com/PHPjc/325681.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/325681.htmlTechArticleActually, this is not a difficult task, because I just started CI, so it still took a lot of trouble. Fortunately there is a manual. Find the database configuration file and add the connection information for a new library. $config...