Sedang Disiapkan

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 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]

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




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


// product specs

DoWhile exist

ForEach spec header:


find spec header info:


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.

Kemahiran: Linux, Perl, PHP, XML

Lihat lagi: oscommerce insert mysql, 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 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

Tentang Majikan:
( 7 ulasan ) West Lafayette, United States

ID Projek: #7741

12 pekerja bebas membida secara purata $272 untuk pekerjaan ini


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

$180 USD dalam 3 hari
(40 Ulasan)

I am an expert in web extraction

$200 USD dalam 0 hari
(112 Ulasan)

Please see PMB for more details.

$500 USD dalam 2 hari
(5 Ulasan)

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 Lagi

$500 USD dalam 15 hari
(6 Ulasan)

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 Lagi

$115 USD dalam sehari
(10 Ulasan)

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 Lagi

$250 USD dalam 2 hari
(4 Ulasan)

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 Lagi

$200 USD dalam 2 hari
(1 Ulasan)

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

$150 USD dalam sehari
(1 Ulasan)

please see pmb for details

$500 USD dalam 10 hari
(1 Ulasan)

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

$400 USD dalam 2 hari
(0 Ulasan)

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 dalam 2 hari
(0 Ulasan)

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

$130 USD dalam 2 hari
(1 Ulasan)