Help connecting MySQL to web page

Discussion in 'Databases' started by ozstar, Aug 19, 2012.

  1. #1
    We are wanting to do this..

    We are streaming audio from a program called radioDJ on an XP box thru to the Shoutcast.com server.

    We want to show on our shared server website, a web page of what is playing, what has played and what is coming up etc.

    We have a php script which connects to a mySQL database in their office which does this. It works well as I have seen it on another site.

    Evidently mySQL goes thru port 3306 but after days of trying to get it work for us, we have been told that our host does not allow connections to an external dbase to do what we wish to do.

    Does anyone have any ideas how we can still get this info from our desktop XP MySQL, dynamically to the web page?

    Thanks


    oz
     
    ozstar, Aug 19, 2012 IP
  2. WeddiGo

    WeddiGo Greenhorn

    Messages:
    40
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    18
    #2
    You will have to use AJAX and have a server side page running on your XP box and have a fixed IP address on your XP box
     
    WeddiGo, Sep 22, 2012 IP
  3. WeddiGo

    WeddiGo Greenhorn

    Messages:
    40
    Likes Received:
    2
    Best Answers:
    2
    Trophy Points:
    18
    #3
    just thought of another way, if you are on XP pro running IIS then you could do this:

    1. have a website set in IIS on the XP box
    2. create an ASP page that connects to the database and retreives the data and then submits it to a page on your remote hosting
    3. create a sheduled task in XP to call that ASP page every minute or so
     
    WeddiGo, Sep 22, 2012 IP