Re: [Phpwebsite-developers] Table Naming Conventions and Multiple Instances of phpWebSite

[Jason C. <cam...@xp...>]

I like this idea.  Unless anyone objects to this being added I could start 
work on this sometime this weekend.  Anyone else have any thoughts on this?

Jason Campbell
Xplozive Media Technologies
www.xplozivemedia.com
phpWebSite Developer

> I would like to suggest that phpWebSite should have the ability to
> create multiple phpWebsite databases in a single mySQL database. Here's
> why: many if not most web hosts limit the number of databases allowed
> on a single website.
> 
> So, if one wanted to create multiple, functionally separate instances
> of phpWebsite on a single domain, it must be done within a single
> database.
> 
> Here's my suggestion:
> 
> Add a configurable prefix onto each table name controlled by a variable
> in the configuration file.
> 
> For example, Add a variable such as, "$dbp" to the configuration file.
> Then when someone sets $dbp = "sales", then the author table, for
> example, would have the name sales_author.
> 
> Then, what I can do is install the phpWebsite code into a domain
>subdirectory called sales, set $dbp to "sales" and have a separate set
>of tables for the "sales" website. I can then setup another subdirectory
>called "techsupport", install the phpwebsite code into that directory,
>and configure it with the $dbp variable set to "tech" and have a
>separate set of tables for this instance of phpWebSite.
> 
> I would design this so that is someone set $dbp = "" (empty), then
> there would be no effect on the existing table names. This would
> preserve code compatibility with existing sites.
> 
> There are other ways of doing this so that multiple websites can exist
> in the same set of tables, but that would take a lot of design and
> implementation work. The above approach can be quickly and easily
> implemented.
> 
> Geoff
> 
> Geoff Staples,
> Founder
> Action Agenda <http://www.actionagenda.com/>
> 
> 3883 Turtle Creek Blvd., Suite 1812
> Dallas, Texas   75219-4432
> 214.599.0260
> 
> Action Agenda is hosted as a public service by
> Hostricity Web Hosting <http://www.hostricity.com/>
> 
> ActionAgenda.com is a Community Center for progressive and liberal
> activists to stay informed, find allies, and build support.
> 
> 
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwebsite-developers