I am programming a website as I learn and I need a more simplistic and creative approach. The project consists of the main website which will be utilizing a forum based user system. From there people may join and create a community that is completely another entity from the main website. In retrospect it would be something like this... mainwebsite.com -----> mainwebsite.com/usercommunity So from my thought it would require for the members of that community to create a whole new community that holds its own forum based member system. My approach is to provide them have an administrator interface where they can create pages within that community. For now it would only allow them to utilize html and certain JavaScript’s to an extent. They would not be able to "upload" anything at all to the server, only externally if you understand what I am trying to say. The problem is I do not want to have a mass amount of MySQL databases to organize it all, and I do not want to have one mass database to confuse it all. So I am looking for the best approach to this. This community system would automatically create a folder which is what the mywebsite.com/usercreatedcommunity is. From there each created community would come with a pre-interface forum website that they can edit willingly with a provided admin interface. I’ll try and provide a map to try and make this easier. Main website -forum member based Community -admin interface -create pages -edit pages "html etc...†If any question or anything left unchecked I will be glad to answer.
Why are you afraid of using MySQL to your advantage? So long as your database structure is well designed and the indexes are added where necessary etc you should have no problem saving all that info. Personally I'd have a user linked to a table which holds info about which areas of the site the user has opted into - a bit like I have one google login and then opt into Adsense, Gmail, Calendar etc.
try wordpress with buddypress. wordpress have mutiwebsite option too. (if your individual community is small)
I understand your view point but I am simply wondering if there is a cleaner way that is more organized than having a mass amount of MySQL databases. Also, the reason for not linking them in such a way as you describe is to ensure the entity and integrity of the user’s community so they feel like they are in control, hence the administrative interface. It’s mainly the whole point of the project which is not just to provide a very interactive community but one that the visitors can call their own.If there is no way around it I will gladly use a balligerent amount of MySQL databases.