RE: [PHP] Two websites need to share part of one database, suggestions please

André Medeiros on Monday, July 11, 2005 3:08 PM said: > XML is quite easy. Let's say you're making a search for books, and you > have site1.com searching site2.com for some stuff. > > site2.com could have some sort of "back end" like I see what you're saying. But t

Re: [PHP] Two websites need to share part of one database, suggestions please

XML is quite easy. Let's say you're making a search for books, and you have site1.com searching site2.com for some stuff. site2.com could have some sort of "back end" like http://site2.com/_backend/search.php?keywords=a+book That would search it's database for the keywords "a book". It could ge

RE: [PHP] Two websites need to share part of one database, suggestions please

André Medeiros on Monday, July 11, 2005 12:44 PM said: > What about using web-services (something ala xml?). Could that be > considered an option? No because I don't how to use that stuff. :) Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP] Two websites need to share part of one database, suggestions please

What about using web-services (something ala xml?). Could that be considered an option? On 7/11/05, Brad Pauly <[EMAIL PROTECTED]> wrote: > On 7/8/05, Chris W. Parker <[EMAIL PROTECTED]> wrote: > > > Which option should I go for? Is there another option I'm not > > considering? > > Another possi

Re: [PHP] Two websites need to share part of one database, suggestions please

On 7/8/05, Chris W. Parker <[EMAIL PROTECTED]> wrote: > Which option should I go for? Is there another option I'm not > considering? Another possibility would be adding a new table that relates products to sites. This allows a one (product) to many (sites) relationship without changing the produ

RE: [PHP] Two websites need to share part of one database, suggestions please

This seems to be the best option of the one you presented. If you start duplicating data you will have a situation where your data will get out of sync eventually. You can have a lookup table with the keys to the items that belong to website two, just look in the lookup table to get your key, the

RE: [PHP] Two websites need to share part of one database,suggestions please

On Fri, 2005-07-08 at 19:46, Chris W. Parker wrote: > Robert Cummings > 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 b

RE: [PHP] Two websites need to share part of one database,suggestions please

Robert Cummings 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

Re: [PHP] Two websites need to share part of one database, suggestions please

On Fri, 2005-07-08 at 18:20, Chris W. Parker wrote: > Hello, > > We have two websites. One website is already up and running, the other > is not. > > The first website (I'll call it one.com) contains a large number of the > products and is meant for a specific audience. The second website (I'll >