Tutorial :How to make lookup tables shared to multiple site with the same DB and every site can have a customized list of this lookup?



Question:

I want to having all common data (i.e. nationalities) identical in all site (the main webmaster/administrator who should decide either to make a certain list global or not) how to achieve this goal in the database design or in the system architecture


Solution:1

If you want one master list and share them across applications, you can better do it in database. Create a nationality table. I would do it in database, load from it to the application and use it.


Solution:2

I don't follow - but couldn't you simply connect all your different sites to the same DB? Assuming that you're not using in-process databases, it should be fine.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »