asked on

mysql/php web project - how can i duplicate

I just created a portal using PHP/MySQL to capture data for a local association and it is something that could be valuable for others in the same business. What would be the best practice to duplicate the project?

Essentially, I'd like to be able to add a new top level group in my DB, which would then filter down through the tables already created. Should i keep it all in one DB or have a new DB created for each new association that may want the portal?

Juan Ocasio

You could append to each table for each association. So if you have a tennis association, and one table is called users, you would name the table tennis_users. You could also do this append the name to the db and create a new db for each association as well.

I personally prefer using new databases as it ensures data segragation.

HTH

axessJosh

ASKER

yea, but if i wanted the user registration to be more automatic what would i do. For example, a new person has an association that could use this portal, they can register their information and it creates the necessary DB for them. Is that too complex a concept for a newbie?

ASKER CERTIFIED SOLUTION

Juan Ocasio

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pius_babbun

My suggestion is consider the new requirement and modify the existing database accordingly to make it strong. In case if you adding another database for the new one , it would be loosely coupled and you may need put in more stuff get what you desired. However it depends on what database engine you are using too. In case if you have used INNODB you would find the strong relations where they work perfectly. Since you already have a Database you can assume the requirement and make considerable changes in the structure without affecting the earlier features already you have achieved. This analyse would of making it as common database would be helpful to you to create desire outcome with single datbase. Hope this helps.