How to access a custom table name that isn't prefixed with exp_

Question

I'm developing an EE module that needs to access a non EE database table that isn't prefixed with 'exp_'.

How would I go about doing this? In Codeigniter I can use set_dbprefix, but that doesn't appear to be available in EE.

I'm using EE 2.73 currently.

Thanks in advance!

Answer 1

If I recall correctly, using the query module (and relative portion of the database class) doesn't force the prefix.

https://ellislab.com/expressionengine/user-guide/add-ons/query/

So you can use that to query any full table name:

$result = ee()->db->query('SELECT * FROM not_prefixed_table')->result_array();

You just annoyingly have to write out each query.

Edit Also, I'm assuming you don't have permissions to make schema and table changes to this database, because otherwise the obvious answer is just modify the table name to include the prefix.

Answer 2

You can set the database to be used like so:

$mydb = ee()->load->database('mydatabase', TRUE);

By setting the second parameter to TRUE the function will return the database object.

and then run a query like:

$query = $mydb->select('*')->from('tableName')->get();

UPDATE:

To set the database prefix to use in the query use:

ee()->db->set_dbprefix('myprefix');