Solved

Pls explain how to grab text from a website

Posted on 2008-10-17
7
359 Views
Last Modified: 2013-12-13
My background:
Total new to programming language
Linux web hosting
I will hire someone to achieve this task.

Dear experts

I plan to grabs some texts and images from a classified website.
I need to know how things work so that I can explain to programmers what I need to achieve.
The programmer will need to create an automated tool.
The main page of the website are updated every few minutes with new listing.
The tool will need to click on each of this listing, and grab Topic, Description, Image etc from the listing and put into a database... The tool will also need to check the main page for un-grab listing hourly.
My questions
a, Is this call data parsing?
b, what programming language are commonly used to create the tool? Can php be use?
c, once the programmer create the codes, I will put the files in my linux web server and run it myself . Is this alright?
d, the tool will grab the data and put in MYSQL?

Did I left out anything that worth mentioning?
Your details explanation is much appreciated.
thx


0
Comment
Question by:royalgoldleaf
  • 3
  • 3
7 Comments
 
LVL 26

Expert Comment

by:ushastry
ID: 22745737
I think php,perl or any shell script will do this stuff..

PHP -> use curl to grab text from remote web site, extract the required data from the copied text & put this into MySQL
 
Bash/sed/awk - > Using lynx copy the entire text    into a text file, extract the required data and format according to MySQL compatible (csv or tsv) and just load this into MySQL (using heredoc, non-interactive mode).

Perl-> can be done...
0
 
LVL 5

Expert Comment

by:RightNL
ID: 22747518
have a look at snoopy
it's a really nice class that does it for you..
snoopy.sourceforge.com  
0
 
LVL 5

Expert Comment

by:RightNL
ID: 22747531
sorry I didn't fully read the threath ;)
it can all be done in php...
using snoopy you'd grab the full page and then strip out the stuff you like and put it in the database..
any php programmer should be able to do this..
 
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:royalgoldleaf
ID: 22749160
Any pre-written scripts that i can customize to do the job?
Cant find in snoopy..
0
 
LVL 26

Accepted Solution

by:
ushastry earned 250 total points
ID: 22755803
0
 
LVL 5

Assisted Solution

by:RightNL
RightNL earned 250 total points
ID: 22755843
snoopy can be found : http://sourceforge.net/projects/snoopy/
it's a highly customable php class. which you can just point the url to...
 
0
 
LVL 26

Expert Comment

by:ushastry
ID: 22887433
Thanks for the points!

Thanks,
Umesh
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
The viewer will learn how to count occurrences of each item in an array.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question