这是我尝试连接的数据库的数据库配置。对于此特定模型,情况有所不同。
$db['campaignsDB']['hostname'] = 'localhost';
$db['campaignsDB']['username'] = 'root';
$db['campaignsDB']['password'] = '';
$db['campaignsDB']['database'] = 'sf_campaigns';
$db['campaignsDB']['dbdriver'] = 'mysql';
$db['campaignsDB']['dbprefix'] = '';
$db['campaignsDB']['pconnect'] = TRUE;
$db['campaignsDB']['db_debug'] = TRUE;
$db['campaignsDB']['cache_on'] = FALSE;
$db['campaignsDB']['cachedir'] = '';
$db['campaignsDB']['char_set'] = 'utf8';
$db['campaignsDB']['dbcollat'] = 'utf8_general_ci';
$db['campaignsDB']['swap_pre'] = '';
$db['campaignsDB']['autoinit'] = TRUE;
$db['campaignsDB']['stricton'] = FALSE;
我已经创建了一个crud_model,我确定函数写得正确,但我要包括相关部分......
class CRUD_model extends CI_Model
{
protected $database = null;
protected $_table = null;
protected $_primary_key = null;
public function __construct()
{
parent::__construct();
$this->load->database($this->database, TRUE);
}
我遇到的问题如下:
我创建一个campaigns_model...
class Campaigns_model extends CRUD_model
{
protected $database = "campaignsDB"; //DEFINE database
protected $_table = "camp_forminfo";
protected $_primary_key = "form_id";
public function __construct()
{
parent::__construct();
}
}
现在,经过长时间的中断,我将回到面向对象编程,因此我可能在这里缺少一些重要的部分,但是我可以发誓,通过在派生类中定义基类的变量,当我尝试使用基类的方法时,它将被定义。我尝试在我的控制器中使用CRUD_model的插入功能...
首先我加载campaigns_model...
class Campaigns extends MY_Controller
{
private $layout = "";
private $content = "";
public function __construct()
{
parent::__construct($this->layout);
$this->load->model('campaigns_model');
}
然后我在我的控制器功能中使用它...
public function saveForm()
{
$this->campaigns_model->insert([
'form_name' => $this->input->post('form_name'),
'form_leads' => $this->input->post('form_leads'),
'form_content' => $this->input->post('form_content'),
'form_template' => $this->input->post('form_template')
]);
}
我收到以下错误:
An Error Was Encountered
You have not selected a database type to connect to.
我可能是错的,但这是我在我的双数据库应用程序中执行此操作的方式:
class CRUD_model extends CI_Model{
protected $database = null;
protected $_table = null;
protected $_primary_key = null;
public function __construct() {
parent::__construct();
$this->db = $this->load->database($this->database, true);
}
奇怪的
是,我能够通过对我的CRUD_model代码进行轻微修改来使这一切正常工作。
通过改变这个...
class CRUD_model extends CI_Model
{
protected $database = null;
protected $_table = null;
protected $_primary_key = null;
public function __construct()
{
parent::__construct();
$this->load->database($this->database, TRUE);
}
对此...
class CRUD_model extends CI_Model
{
protected $database = null;
protected $_table = null;
protected $_primary_key = null;
public function __construct()
{
parent::__construct();
$this->load->database("".$this->database."", TRUE);
}
成功了。。。通过强制将该变量解释为字符串,它起作用了。为什么会这样,我还没有学会,也许有人可以分享?