+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: multi domain different db prefix (/showthread.php?tid=21611)
multi domain different db prefix - El Forum - 08-15-2009
[eluser]egoslip[/eluser]
Hey guys im trying to rack my brain here and cant figure out the "CORRECT" way of doing this.
I have a db table that has each domain with and id IE:
|id|dname
|1 |foo.com
|2 |bar.com
|3 |foobar.com
what i want to do is if they land on foo.com it would it would add a prefix tag to select tables so it can be 1_pages 2_pages 3_pages ...etc and each table would pull the correct data depending on the current domain name. But still be able to access the core tables like "users"
multi domain different db prefix - El Forum - 08-15-2009
[eluser]tomcode[/eluser]
Take the base_url(), eventually clean it from subdomains(www, etc).
Fetch Your id.
Query Your table.
Where is the problem ?
Why don't You have just one table with a field containing the domain id / or directly the domain ? Unless You will not have thousands of pages ...
multi domain different db prefix - El Forum - 08-15-2009
[eluser]egoslip[/eluser]
ahh for some reason it didnt post the rest of my post mmm...
Well the rest of it was
how can i change the db_prefix settings per controller i dont want to change the config file and i dont want to edit all that tables in my model ...
this way i can just tag a bit of code at the top of select controllers and change the db prefix just for them ...
multi domain different db prefix - El Forum - 08-15-2009
[eluser]tomcode[/eluser]
You can solve that by connecting to multiple databases, see the user guide http://ellislab.com/codeigniter/user-guide/database/connecting.html, then You can access the domaon specific database and the common database at the same time. I guess that's what You want and now I better unerstand what You try to do
multi domain different db prefix - El Forum - 08-15-2009
[eluser]egoslip[/eluser]
ya kinda what i need but I would like to keep everything in one database I just want to change the db prefix per controller something like what i have below
$this->site =1 //domain index
$this->CI =& get_instance();
$this->CI->db->dbprefix=$this->CI->db->dbprefix.$this->site.'_';
it changes it for the whole site but I only want it to change for the current model
like how can I get the current prefix then set the new modified prefix to the current model only..
Sorry for the confusing posts i cant seem to explain i like to do
multi domain different db prefix - El Forum - 08-15-2009
[eluser]tomcode[/eluser]
Well You could simply create Your own prefix variable which You use every time You query a domain specific table.