Đang Thực Hiện

parse HTML and insert into db (mysql)

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 "Fuji S5000" 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: "See product details"

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

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

find:

COLLECT EVERYTHING BETWEEN THIS TAGS

do: "insert into product_desc" into db according to product SKU

find:

// product specs

DoWhile exist

ForEach spec header:

COLLECT THIS TEXT

find spec header info:

COLLECT THIS TEXT

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.

Kỹ năng: Linux, Perl, PHP, XML

Xem thêm: oscommerce insert mysql, need get manufacturer, script pull data website, pull pay, programmer find one, programmer mysql, perl programmer job, need small manufacturer, 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 perl, find job programmer, find job advertising, buy resources website, buy sell php script, all spec

Về Bên Thuê:
( 7 nhận xét ) West Lafayette, United States

Mã Dự Án: #7741

12 freelancer đang chào giá trung bình $272 cho công việc này

siddhartha1

dear sir, we can do it in the above budget and in 2 days or at the max 3 days. Thanx

$180 USD trong 3 ngày
(40 Đánh Giá)
7.6
webxtor

I am an expert in web extraction

$200 USD trong 0 ngày
(112 Đánh Giá)
5.6
ispg

Please see PMB for more details.

$500 USD trong 2 ngày
(5 Đánh Giá)
4.7
crvenk

Our company would like to bid on your project. We will be able to provide you with our expertise in this field and meet your requirements. We have handled similar projects and have got a massive team of 140+ employees Thêm

$500 USD trong 15 ngày
(6 Đánh Giá)
4.6
NetHunter

Hi, I have plenty of experience with MySQL/OSC and PHP to build this very quickly and efficiently. I think most of the other bids are overpriced, and so I bid what I think is fair enough. I assure you you won't be disa Thêm

$115 USD trong 1 ngày
(10 Đánh Giá)
4.3
jlcreat

Hello, We are capable and willing of putting this script together for you, cleanly coded and commented, and most importantly, completed on time. However, we feel your estimate of 3-4 hrs is really on the low end and Thêm

$250 USD trong 2 ngày
(4 Đánh Giá)
3.9
halwasiyainfosys

Dear Sir, We have understood your requirements and can easily do the project as we are having more than 5 years of experience in IT industry and we are India's leading IT company. We offer 100% satisfaction and money Thêm

$200 USD trong 2 ngày
(1 Đánh Giá)
2.5
xenon79

Hi, I'll do the job, just need your database structure. Regards, Valentin

$150 USD trong 1 ngày
(1 Đánh Giá)
1.6
tanuj99

please see pmb for details

$500 USD trong 10 ngày
(1 Đánh Giá)
3.2
phpXpert

Hire me and consider the job done. My portfolio: [url removed, login to view]

$400 USD trong 2 ngày
(0 Đánh Giá)
0.0
qcosol

I am interested, Bid is for the complete work as per your specification, I have done many similar site scraping and parsing jobs. Thanks.

$140 USD trong 2 ngày
(0 Đánh Giá)
0.0
erhardsmit

Hello. I can write this script for you in less than 2 days. I have experience with these type of scripts.

$130 USD trong 2 ngày
(1 Đánh Giá)
0.0