Pull Data From External Site

Discussion in 'Programming' started by zhoom, Jul 29, 2010.

  1. #1
    Hi All

    I am hoping to develop a website (in Wordpress) for my local squash club and am wondering how I would go about pulling the State results from an external site.

    The external site is a nationwide results site where rankings are calculated and posted to the site. You can see here: http://squashmatrix.com/

    I would only want to pull the results from my region (NT, Darwin).

    How would I go about doing this? (Yes I would get permission to do so first...)
     
    zhoom, Jul 29, 2010 IP
  2. bigmax

    bigmax Peon

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Simple. Scrape off the InitialRatings.asp page (say with CURL). Extract the <table> tag's contents. Parse it & push it into your mysql table. Pull the data off that table into your page by your scrip. You can bypass the mysql storage and pull the "feed" directly, though I'd personally keep it for statistical processing etc.
     
    bigmax, Aug 1, 2010 IP