Find Jobs
Hire Freelancers

Parse HTML and INSERT into mySQL DB

$20-100 USD

Kansellert
Lagt ut over 19 år siden

$20-100 USD

Betalt ved levering
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 [login to view URL] 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: [login to view URL] insert manufacturer name and sku 3. the product page should be found. The example of quotFuji S5000quot will give [login to view URL] 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 [login to view URL] 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.
Prosjekt-ID: 7734

Om prosjektet

1 forslag
Eksternt prosjekt
Aktiv 20 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
1 frilanser byr i gjennomsnitt $100 USD for denne jobben
Brukeravatar
Hi there, Please check your PM for some questions. Let me know about it. Cheers, Skulled
$100 USD om 2 dager
5,0 (5 omtaler)
3,9
3,9

Om klienten

UNITED STATESs flagg
West Lafayette, United States
5,0
7
Medlem siden apr. 26, 2004

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.