RE: [PHP] Two websites need to share part of one database,suggestions please
| From: | Chris W. Parker | Date: | Fri, 08 Jul 2005 23:46:33 +0000 |
| Subject: | RE: [PHP] Two websites need to share part of one database,suggestions please | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218374@lists.php.net to get a copy of this message | ||
Robert Cummings <mailto:robert@interjinn.com>
on Friday, July 08, 2005 3:32 PM said:
> Use a bitvector field in the table and use a bitmask for filtering for
> which sites can access what products.
I think I understand what a bitmask is after doing some research but
would you please give me an example so I can apply what I've read?
> Then similarly for
> customizations (presuming good database normalization) you can extend
> this to customizations, specials, etc, etc. This is only one possible
> solution of many, you could have the database list in another table,
> but I thought I'd skip a join since you only mention two sites.
Again, I think I understand what you're suggesting, but the problem is
that I'm not sure how to apply it. Example please, if you will.
Thanks,
Chris.