SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2011
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Linking SQL Database to Two Different Websites?

    Hi there,
    I am not very familiar with PHP and MySQL. I'm all about Joomla and letting them create the databases for ya! But I am working for a company that has a very custom website, and they want me to create a website for the building in which the company is situated. I plan on using Joomla to create this website. The companies website displays events and sells tickets for them. Soo, the boss' idea is to link the events database from the companies website to the buildings new website, so that when an event is created it not only displays on the companies website but also on the buildings.

    Now, if this is just ridiculous, let me know! Like I said, I am definitely not a database expert by any means. I would just like to know if this is possible, and what would make it possible (websites need to be hosted on same domain? etc.) Thanks so much!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    from the database perspective, what you describe is feasible

    all it takes is the requisite application coding
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Oct 2011
    Posts
    70
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    from the database perspective, what you describe is feasible

    all it takes is the requisite application coding
    Thanks, any good resources for 'requisite application coding'? Right now, it seems french Could you also tell me whether or not the website needs to be hosting with the same hosting service as the website I want to link the database from? Thanks again.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,015
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    i would imagine the technical issues of accessing another database are more difficult if the databases are on separate servers

    good luck with the joomla database, from the few glimpses i've seen, it's horrendously complex
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you are using a shared hosting service (even one you pay for), it is unlikely that connections from an outside script are allowed. Many of them turn this ability off for security reasons. The script would have to reside on the same server as the database. You can always ask of course. If it is on a network computer within your company then you'd ask your networking person to ensure you have the correct permissions.


Bookmarks

Posting Permissions

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