updating one off table without exp prefix
Development and Programming
15 years ago
Hi -
We have a third party system that writes data into the database nightly. From there I’m writing a custom module that will periodically update the said data in the same table. Unfortunately, this table doesn’t share the “exp” prefix that the rest of the tables do. Is there a way to tell $this->EE->db->update_string not to add the prefix?
summer
15 years ago
Try this:
$dbprefix = $this->EE->db->dbprefix;
$this->EE->db->dbprefix = '';
....run your queries without exp prefix....
$this->EE->db->dbprefix = $dbprefix;
14 years ago
or put this in your constructor
$this->db = clone $this->EE->db;
$this->db->dbprefix='';and use $this->db
$result = $this->db->get('mytable');