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

[Geoff S. <Ge...@Ho...>]

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.