Parse HTML and INSERT into mySQL DB

Annulé

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.

Compétences : ASP, Linux, PHP, XML

Voir plus : mysql insert amp html, you pull and pay, www kw com, where to find website programmer, where i can find programmer, where i can find a programmer, where do you go to find a programmer, where do i get a programmer, where can i find programmer, where can i find a programmer job, what to do when you can't find a job, what to do if you can't find a job, what is job id, what do you need to get a manufacturer, what can i do with php and mysql, script to pull data from a website, pull and pay, programmer where i can find one, programmer mysql, programmer find job, programmer can t find a job, pay by hour, oscommerce 2.3 header php, need a small manufacturer, mysql db

N° du projet : #7734

1 freelance a fait une offre moyenne de 100 $ pour ce travail

skullcode

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

100 $ USD en 2 jours
(5 Commentaires)
3.9