Jump to content

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....

Link to comment
https://forums.phpfreaks.com/topic/2842-help-grab-newspaper-stories-dump-in-dbase/
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.