İptal Edildi

Parse HTML and INSERT into mySQL DB


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


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]

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






do: quotinsert into product_descquot into db according to product SKU



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






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.

Beceriler: ASP, Linux, PHP, XML

Daha fazlasını gör: 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

İşveren Hakkında:
( 7 değerlendirme ) West Lafayette, United States

Proje NO: #7734

Bu iş için 1 freelancer ortalamada $100 teklif veriyor


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

$100 USD in 2 gün içinde
(5 Değerlendirme)