RE: Two websites need to share part ofonedatabase,suggestions please

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2005-07-12 at 14:50, Chris W. Parker wrote:
> Robert Cummings <mailto:robert@xxxxxxxxxxxxx>
>     on Tuesday, July 12, 2005 11:47 AM said:
> 
> > Sorry to respond so late, my free time these days is sporadic :)
> 
> No problem.
> 
> > My example suggested one database to host all products for both sites.
> > The bitmask is used as a filter to determine which sites can access
> > the product information. In this way you keep your products
> > centralized while providing easy access for either site 1 or site 2
> > customers.
> 
> Oh I see. And I guess the same technique would be applied to the other
> tables like 'customers', 'coupons', 'orders', etc.

Absolutely.

> 
> > I also mentioned when I first suggested it, and as another response
> > mentioned, that you could go with a separate table that provides site
> > to product relationships and that would be scalable to many more
> > sites.
> 
> I think I'm going to do something like this.

Cool :)

Cheers,
Rob.
-- 
.------------------------------------------------------------.
| InterJinn Application Framework - http://www.interjinn.com |
:------------------------------------------------------------:
| An application and templating framework for PHP. Boasting  |
| a powerful, scalable system for accessing system services  |
| such as forms, properties, sessions, and caches. InterJinn |
| also provides an extremely flexible architecture for       |
| creating re-usable components quickly and easily.          |
`------------------------------------------------------------'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux