Jump to content

Archived

This topic is now archived and is closed to further replies.

ger_mac74

HELP! Grab newspaper stories & dump in dbase

Recommended Posts

Hi

I've just begun learning php and mySQL and am having probs working on an assignment. The assignment is as follows:

 

The task in this exercise is to build two systems. The first system which will do the following at least once a day:

 

Visit your chosen news web-page

Identify new stories that were not present last time the page was visited

Insert the following data about each such story into a mySQL database:

the date the story appeared on the website

the headline for the story

the URL for the story

an abstract containing the first few paragraphs of the story

 

The second system will list all the stories in the database on a HTML page.

---------------------

 

I know how to do most of this assignment. I know how to setup the blank database in mySQL. I will be identifying new stories using php, regular expressions, crontab etc. I dont know how to insert the new stories into a mySQL database or list the stories from datbase on an html page. Not very good at programming. I presume I'll be using some kind of INSERT INTO function but how to use this and with what code is the problem. Can anyone help out a confused irishman!?

Thanks in advance....

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.