Multi-Site CMS Design Question

[andymike07]

Hey everyone,

 

I'm working on designing a CMS that will handle all the content for 2-4 sites and I would like to get some input on the best way to implement  it. Ideally I would like to do is have the system use the same admin area and the same content database for all the sites. Then I'd like to be able to say I want this article to appear on site a, site b and site d but not on site c. Then the php scripts that get the code from the database would simply look for their site ids to get the content that is assigned to them.

 

Thanks in advance for any help you guys can give!

[MadTechie]

Sounds like you just need to use the same database settings for all (except localhost being the master site, maybe add some cacheing)

as for what data goes where.. thats down to your own design.. i would probably have a table for contents tables for domains and a table to link them ie

 

Contents

ID -  Contents

1. Hello World

2. Hello John

3. Hello Paul

 

Domain

ID - Name

1. SiteA

2. SiteB

3. SiteC

 

CtoDLink

ID - DomainID - ContentID

1. 1 - 1

2. 1 - 2

3. 1 - 3

4. 2 - 1

5. 2 - 2

6. 3 - 1

7. 3 - 3

 

So..

SiteA can see all contents

SiteB can see Hello World & 2. Hello John

SiteC can see Hello World & 2. Hello Paul