Hello all,
I need to extract data from a website, say for eg. Buy.com's Electronics category
and save it either in MS excel.
I tried looking for the code over the internet, but this wasn't properly explained anywhere.
Please help me.
99k 0 Newbie Poster
depassel 0 Newbie Poster
Maybe this can help you http://office.microsoft.com/en-us/excel-help/getting-data-from-the-web-in-excel-HA001045085.aspx
sudeepjd 19 Junior Poster
You could also use AutoIt's IE UDF to do it as well. However, this is a PHP forum. Are you looking for a PHP specific method?
99k 0 Newbie Poster
I am not looking for any tools or softwares.
As Sudeep says, I am looking for a php specific method.
epicrevolt 6 Junior Poster in Training
Take a look at http://web-harvest.sourceforge.net/index.php
It can gather data from web pages. It can do some advanced things, but with some programming know-how, you can place the data on spreadsheets.
99k 0 Newbie Poster
Thanks people.
But, I want something like a raw code, not a tool or a software. Please help me.
diafol
Look up the php manual and search file_get_contents() - your host may have disabled cross-domain use of this. If so use cURL. There are a few other methods too, but I think those two are the most common.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.