Website Community

Discussion in 'Programming' started by naopublic, Aug 15, 2012.

  1. #1
    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.
     
    naopublic, Aug 15, 2012 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,828
    Likes Received:
    4,541
    Best Answers:
    123
    Trophy Points:
    665
    #2
    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.
     
    sarahk, Aug 16, 2012 IP
  3. nandanamnidheesh

    nandanamnidheesh Active Member

    Messages:
    376
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    55
    #3
    try wordpress with buddypress. wordpress have mutiwebsite option too. (if your individual community is small)
     
    nandanamnidheesh, Aug 16, 2012 IP
  4. naopublic

    naopublic Member

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #4
    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.
     
    naopublic, Aug 16, 2012 IP