Parse HTML and INSERT into mySQL


We sell digital cameras and needs to populate products specs in a quick manner. I am looking for a small script that will extract data from www.shopping.com. Before I go in to details, I do have permission to spider thier site and to use the data since we buy their advertising.

Here is an example page:

[url removed, login to view]

Notice the row in gray, the main Spec Category. The following Sub categories are below. What I need is the data to the right of the sub categories. The HTML is fluent through all digital camera specs. So it should be easy to write the parser to find where to parse and collect and when not to.

So all cameras within:

[url removed, login to view]

need to be parsed. If I am correct, I do beleive they use rdd or xml. Notice the links have xPP and xPF. I guess the parser could check every possible link that has the word digital AND camera then decide to parse the page.

So what needs to be added to the db? The title of the name of the camera - can be collected from header tags TITLE, but only the camera name like FUJI FINEPIX S5000 DIGITAL CAMERA. From there, the specs to be collected then INSERTED into a mysql db which will have the same subcategories name. On the very last row of the specs is a sub category of Product ID, this is not needed.

I need this done ASAP. I suspect it should take 3-4 hours to do this job. I am willing to pay $35/hour or a max of $140.

If you have any questions please reply back. Thanks

Taidot: ASP, Linux, PHP, XML

Näytä lisää: parse html mysql, insert html tags mysql, perl parse text insert mysql, parser html mysql insert, parse html insert mysql, awk mysql insert, insert xml mysql, mysql insert parse string, mysql insert html, inserting html tags mysql, parse html insert, where do we find xml, Mysql questions, links html 5, link no html 5, link html 5, i need digital advertising, html 5 link, html 5 header, find a job in advertising

Tietoa työnantajasta:
( 7 arvostelua ) West Lafayette, United States

Projektin tunnus: #1242

Myönnetty käyttäjälle:


Hello! It's an interesting project for me... I'm a profy in data extracting applications!

$150 USD 2 päivässä
(14 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I am a freelancer working on open source technologies since last three years. I have implemented the similar task in many of my projects. I can complete your task within 3 days. You can view some of my projects for Lisää

$100 USD 3 päivässä
(292 arvostelua)

Dear sir or madam, i wouldlike to suggest youmy experience and strong knowledge. I provide 3 months of support after project will be completed and 24 hours per day online during the project.

$120 USD 0 päivässä
(3 arvostelua)

Hi! I have done a lot of PPC engines parsing (inside the login area and stuff) and I have complete understanding of spidering and matching in such a manner. I'd like to do the spider and parser in Perl though, which wo Lisää

$230 USD 2 päivässä
(1 arvostelu)

Thank you for the invitation to bid on this project. Relevent experience includes the following: Installation of software, hardware and HTTP servers · Support for on-line documentation, software and code for US and In Lisää

$500 USD 5 päivässä
(0 arvostelua)

The links are straightforward HTML links. You just need an application that will open the [login to view URL] website dig cameras page, parse it to find links and so on repeatedly in a loop, getting down to the page with the Lisää

$350 USD 3 päivässä
(0 arvostelua)

Hi I understand your requirement . and i got 8 years of experience on required skills. I confident that i can give a good solution to you.

$450 USD 60 päivässä
(0 arvostelua)