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

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

If you want to do that, I just thought of a way to do it.  It would just 
require a variable in the config.php file to use a single user table say 
like $share_user_table or something like that.  Thats with the database 
feature below added into the code already.

> Would this method allow a site to have multiple instances of phpWS, but
> share one user table?
> ---
> Aaron Adams
> 
> 
> 
> From: "Jason Campbell" <cam...@xp...>
> Reply-To: php...@li...
> Date: Fri, 23 Mar 2001 15:31:07 -0500 (EST)
> To: php...@li...
> Subject: Re: [Phpwebsite-developers] Table Naming Conventions and
> Multiple Instances of phpWebSite
> 
> 
> 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
> 
> 
> 
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpwebsite-developers