Cancelado

Parse HTML and INSERT into mySQL DB

Hello,

We sell digital cameras and need to populate products specs within oscommerce

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.

I would prefer a friendly script - not killing [url removed, login to view] or using a lot

of resources.

Here is what the script needs to do:

1. From our db, pull the manufacturer name and sku (i can write in this

query).

2. from starting page: [url removed, login to view] insert manufacturer name

and sku

3. the product page should be found. The example of quotFuji S5000quot will give

[url removed, login to view]+s5000

4. on the right side of this page there will be a box. we need to visit the

link that reads: quotSee product detailsquot

5. from this page is where data will be collected and stored into our db. here

is the breakdown

===========================

find:

&

div id=quotsumTextquot<COLLECT EVERYTHING BETWEEN

THIS TAGS&/div<

do: quotinsert into product_descquot into db according to product SKU

find:

&

table class=quotprod_boxquot id=quotsinglequot cellspacing=quot0quot width=quot100%quot< //

product specs

DoWhile &tr<&td class=quotheaderquot colspan=quot2quot< exist

ForEach spec header:

&

tr<&td class=quotheaderquot colspan=quot2quot<COLLECT

THIS TEXT&/td<&/tr<

find spec header info:

&

td class=quotinfoheadquot<&a href=quotjavascript:popWhat(9475)quot<COLLECT

THIS TEXT&/a<&/td<

do: insert spec header and spec header info into db according to sku

End ForEach

End DoWhile

Jump to step one

Continue until no more query results from step one

=============================

Ok, that is the breakdown. Now, you do not have to actually write the program

as I have indicated but, what is important is that I get all Spec Headers with

the correct Spec Header Info. If you want to use arrays, that is fine by me.

I need this script to be in one file - for cron purposes. Since [url removed, login to view]

website changes from time to time - I am also looking for the code to be clean

in case I need to make modifications. I am not a real programmer but I can

modify

and

make

small

changes

when needed.

I can only read clean code.

I need this done ASAP. This job shouldn't take more than 3-4 hours with testing

included. I am willing to pay $35/hour or a max of $140. Please don't bid if

you can't finish this within 2 days from the closing date of bidding.

Habilidades: ASP, Linux, PHP, XML

Ver más: mysql insert amp html, need get manufacturer, script pull data website, pull pay, programmer find one, programmer mysql, need small manufacturer, mysql db, need digital advertising, html programmer job, html program code, html date, get found, foreach php mysql, fine products, find programmer job, find programmer code, find job programmer, find job advertising, buy resources website

Información del empleador:
( 7 comentarios ) West Lafayette, United States

ID de proyecto: #7734

1 freelancer está ofertando un promedio de $100 para este trabajo.

skullcode

Hi there, Please check your PM for some questions. Let me know about it. Cheers, Skulled

$100 USD en 2 días
(5 comentarios)
3.9