Find Jobs
Hire Freelancers

Parse HTML and INSERT into mySQL DB

$20-100 USD

已取消
已发布超过 19 年前

$20-100 USD

货到付款
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.
项目 ID: 7734

关于此项目

1条提案
远程项目
活跃20 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
1威客以均价$100 USD来参与此工作竞标
用户头像
Hi there, Please check your PM for some questions. Let me know about it. Cheers, Skulled
$100 USD 在2天之内
5.0 (5条评论)
3.9
3.9

关于客户

UNITED STATES的国旗
West Lafayette, United States
5.0
7
会员自4月 26, 2004起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。