Storing Web Data in a Local DB
Hello, this is my first post here. Although i have some decent HTML skills, and some very basic Javascript knowledge, I was wondering whether someone here could help me out. What I basically want to do is take information from a web page by running a program/script to automatically store the data in a local database. An example of what I want to store would be....
http://www.racingpost.co.uk/rpost/?MIval=v2_racing_result&race_id=317700
View Source to see the tables.
Any ideas or suggestions?
Arkle was a gift from God
The Webmistress posted this at 14:25 — 29th July 2002.
She has: 5,586 posts
Joined: Feb 2001
Welcome to TWF,
Do you mean that you want to store the information in a database and then use a script to display the information on the website? If so you will need to use something like php to read from the database.
Julia - if life was meant to be easy Michael Angelo would have painted the floor....
zollet posted this at 04:49 — 30th July 2002.
He has: 1,016 posts
Joined: May 2002
The_Oracle,
You can use PHP to read the HTML from any given URL and then have the script take out the parts you want/need and store them in a local database. Take a look at PHP's fopen and fread. If you don't have much programming experience, you'll probably be better of paying someone to create the script for you.
The_Oracle posted this at 08:57 — 30th July 2002.
They have: 13 posts
Joined: Jul 2002
Excellent, just the answers I was looking for. Thank you both very much, that was very kind of you.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.