Results 1 to 3 of 3

Thread: Central Database Multiple Sites

  1. #1
    Join Date
    Dec 2012

    Central Database Multiple Sites

    I hope you can help me with a project I am working on.

    I want to create a product catalog which is hosted on my server. Access to products is by password only. The password can be global and change automatically once a week.
    I then want to publish different subsets of that catalog on various existing clients sites as a list. Once a Visitor clicks on one item in the list he will need to submit his name & email address to receive a link to the full listing by email. The link should already contain the password.
    The name and email address will be passed into a crm for follow up. I also need to track which site the request came from. The CRM supports creation of web forms.

    My Questions are:
    1. Is a custom designed database the way to go or are there existing products in the market?
    2. What is the best way to get the data to the client sites which all run on different structures? html, iframe, xml or can the server be queried directly?

    Thanks for your help.

  2. #2
    Join Date
    Aug 2004
    1. No idea

    2. I'd probably create a web-based API, possibly RESTful, that would return a JSON string, or XML string if you prefer.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Dec 2012
    Thanks NogDog, sorry my late reply, I forgot my password and it has taken some time to find out how to reset it.

    I dont really understand the API thingi so I have a few questions.

    Would I need to create a new API for every client site or would they all go through one?

    Can a JSON or XML string be embedded into every website? Also CMS'es like Wordpress and Joomla?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center