Can I pull content for an article from a separate database?

Discussion in 'Windows 8 Help and Support' started by songsinh1241, Aug 14, 2015.

  1. songsinh1241

    songsinh1241 New Member

    Joined:
    Aug 13, 2015
    Messages:
    1
    Likes Received:
    0
    My Question:
    How hard would it be to pull a varying set of daily data and construct a weekly “article” based on a requested date, and is there any tutorial / resource that would explain possible approaches?

    Background:
    Each week on my site, I provide definitions for expressions, idioms, and technical words used in that week’s Dilbert comic strips to help my Korean friends to improve their use of English in business.

    Currently the site is organized as a bunch of separate, hand-coded html pages, to which I add each week a new page with the latest definitions. So far, I’ve used separate pages for desktop and mobile browsers as originally the Dilbert site didn’t support mobile browsers (there was a separate app for mobile, but the app was really slow to load). The Dilbert site recently upgraded to a responsive design so now the comic strips can be easily viewed on any device, which is why I’m thinking of rebuilding my site. (Note: I provide a link from my site to each day’s comic strip rather than displaying the comic strip on my site as displaying the strip would infringe on the Dilbert copyright.)

    Details:
    My thoughts on how the site would function are:
    Once a week the definitions database is updated with the latest words/expressions, the definition/explanation, the specific date for the applicable strip, and maybe a sequence number (so the definitions show up in the right order for that day’s comic strip). There are usually between 0 and 6 definitions each day.
    When someone visits the site’s main page, the server would build a page listing all of the definitions for the past week, separated by day, with a link for each day to the comic strip on the Dilbert website. If there are no definitions for a specific day, the page would include a note to that effect and still include the link.
    Doing it this way would save me from having to build up separate “articles” for each week (I’d still have to transfer the definitions I already have and add new ones, but that should be slightly less work).

    Recommendations on ways to structure the site and where to find information on how to implement it will be appreciated.


    Thanks,
    Songsinh
     
  2. Josephur

    Josephur Windows Forum Admin
    Staff Member Premium Supporter

    Joined:
    Aug 3, 2010
    Messages:
    1,019
    Likes Received:
    125
    You would probably need to write a web scraper in PHP, and store your data in your own MySql database. Learn PHP and go from there :)
     
    kemical likes this.
  3. ussnorway

    ussnorway Windows Forum Team
    Staff Member Premium Supporter

    Joined:
    May 22, 2012
    Messages:
    2,535
    Likes Received:
    315
    I would use Muse to build my site with a mix of pages then display a random page (or you can use a count) instead of letting the server build it... the main advantage here is speed both for you making the pages and the viewer loading them.

    TUTORIALS | Adobe Muse CC

    p.s. an iframe that points to the comic page normally gets around copyright (because it remains on the other guys site) but thats a different point.
     

Share This Page

Loading...