I have tables in my database with prefixes and some without prefixes,
How would I go about using these tables especially in controllers which will take data from 2 or more tables which will have prefixes or without prefixes?
I have tables in my database with prefixes and some without prefixes,
How would I go about using these tables especially in controllers which will take data from 2 or more tables which will have prefixes or without prefixes?
You just use the complete tablename for tables without the prefix or tables with a different prefix… and for table with the prefix you use "{{tablename}}".
Documentation - http://www.yiiframew…fining-ar-class