全局设置Codeigniter $ this->查询？

Question

I am working with a CI site, and MS SQL database, and CRUD operations are requiring me to run a few queries before the operations are actually run.

$this->db->query('SET ANSI_NULLS ON;');
$this->db->query('SET QUOTED_IDENTIFIER ON;');
$this->db->query('SET CONCAT_NULL_YIELDS_NULL ON;'); 
$this->db->query('SET ANSI_WARNINGS ON;');
$this->db->query('SET ANSI_PADDING ON;');       

I'm wondering if there is any where I can plant these so that they always run?

Right now, I'm putting them in my models __construct()

Answer 1

You can create a custom model class that you can then extend in the models.

application/core/MY_Model.php

class MY_Model extends CI_Model{

    function __construct(){
        parent::__construct();
        $this->db->query('SET ANSI_NULLS ON;');
        $this->db->query('SET QUOTED_IDENTIFIER ON;');
        $this->db->query('SET CONCAT_NULL_YIELDS_NULL ON;'); 
        $this->db->query('SET ANSI_WARNINGS ON;');
        $this->db->query('SET ANSI_PADDING ON;');
    }
}

application/models/some_model.php

class Some_model extends MY_Model{

    function __construct(){
        parent::__construct();
    }

    function some_function(){
        //interact with db
    }
}