Käynnissä

Copy and paste HTML to MySQL

Overview

An existing client would like to rebuild an on-line catalog for their mirrors. Essentially, the new design is finished, but data entry is needed. What is needed is information to be taken from an online catalog and placed into a MySQL Table. The source of the online catalog is:

[url removed, login to view], and the sub directories linked from that page.

On this page, you will see several links to other pages that have the products. If you click on each of the main section (Frameless all, Lacquer all, wood all, etc..) you will see a listing of products in each section. What I need is the information from those screens moved into the table below.

CREATE TABLE `items` (

`id` int(12) NOT NULL auto_increment,

`name` varchar(60) NOT NULL,

`description` text NOT NULL,

`item_id` int(12) NOT NULL,

`image1` varchar(40) NOT NULL,

`image2` varchar(40) NOT NULL,

`image3` varchar(40) NOT NULL,

`id_1` int(6) NOT NULL,

`size_1` varchar(250) NOT NULL,

`price_1` decimal(10,2) NOT NULL,

`id_2` int(6) NOT NULL,

`size_2` varchar(250) NOT NULL,

`price_2` decimal(10,2) NOT NULL,

`id_3` int(6) NOT NULL,

`size_3` varchar(250) NOT NULL,

`price_3` decimal(10,2) NOT NULL,

`id_4` int(6) NOT NULL,

`size_4` varchar(250) NOT NULL,

`price_4` decimal(10,2) NOT NULL,

`id_5` int(6) NOT NULL,

`size_5` varchar(250) NOT NULL,

`price_5` decimal(10,2) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;

There are two types of item listings on each of the pages: item listings that have one size only, and item listings with multiple sizes. Below is the information that is needed and examples from single and multiple listings. The only information that you need to put in is:

Name -> a three digit number from the HTML page. The number is either listed first, in the case of single size entries, or the first 3 digit number in the size listing

,

Description -> The main description of the item without prices and without the item number, and price

Item_id -> a integer from the below table, depending on the section you are getting the information from. If the item is from the Frameless section, the integer would be 3.

2, 'Metal', ''

3, 'Frameless', ''

4, 'Gold', ''

5, 'Laquered', ''

6, 'Wood', ''

11, 'Chevel', ''

The next information needed is id_#, price_# and size_#

Single size listings only have information in id_1, size_1 and price_1. 2-5 are null. Multiple listings have information in _1 through the number of listings (to a max of _5). The value of id_1 is the same as the id above. Size_1 is equal to addslashes value found by the description

Price_1 is found at the end of each line listing.

Single size entries are done at that point, multiple line entries get additional information in the _2 line.

This would be continued for items with three listings or more.

For more clarification, here a HTML form that they use to input the items:

Here is an example to the information in the frameless section: I have provided a MySQL example of the first couple of rows:

INSERT INTO `items` (`id`, `name`, `description`, `item_id`, `image1`, `image2`, `image3`, `id_1`, `size_1`, `price_1`, `id_2`, `size_2`, `price_2`, `id_3`, `size_3`, `price_3`, `id_4`, `size_4`, `price_4`, `id_5`, `size_5`, `price_5`) VALUES (34, '316', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 316, '24\\" wide, 34\\" high and 3/8\\" deep', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]),

(33, '303', 'Oval Frameless mirror features a 1\\" beveled edge. Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 303, '22\\" wide, 28\\" high and 3/8\\" deep', [url removed, login to view], 304, '20\\" wide, 27\\" high and 3/8\\" deep', [url removed, login to view], 305, '23 1/2\\" wide, 33\\" high and 3/8\\" deep', [url removed, login to view], 306, '28\\" wide, 40\\" high and 3/8\\" deep', [url removed, login to view], 307, '24\\" wide, 36\\" high and 3/8\\" deep', [url removed, login to view]),

(35, '309', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 309, '23 1/2\\" wide, 30 1/2\\" high and 3/8\\" deep with a 1\\" beveled edge', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]),

(36, '318', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 318, '24\\" wide, 30\\" high and 3/8\\" deep with a 1\\" beveled edge.', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]),

(37, '308', 'American made for amazing quality. Free shipping in the continental United States', 3, '[url removed, login to view]', '', '', 308, '28\\" wide, 28\\" high and 3/8\\" deep with a 1\\" beveled edge', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]),

(38, '327', 'Tri-View wall mirror features hinged side mirrors with 1\\" beveled edges. The overall measurements of this mirror are 38 1/2\\" wide, 30\\" high and 3/8\\" deep. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 327, '38 1/2\\" wide, 30\\" high and 3/8\\" deep', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]),

(39, '321', 'Octagon Frameless Mirror features a mirror on mirror with 1\\" beveled edges. Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[url removed, login to view]', '', '', 321, '20\\" wide, 28\\" high and 1/2\\" deep', [url removed, login to view], 324, '24\\" wide, 32\\" high and 1/2\\" deep', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view], 0, '', [url removed, login to view]);

n this page, you will see several links to other pages that have the products. If you click on each of the main section (Frameless all, Lacquer all, wood all, etc..) you will see a listing of products in each section. What I need is the information from those screens moved into the table below.

Required Deliverables

1). MySQL Table with the information detailed above.

Taidot: tiedonsyöttö, verkkosivujen suunnittelu

Näytä lisää: copy paste mysql, copy paste data mysql, paste mysql, html mysql, wood website design, wood products design, use case types, single case design, quality gold, online html design, main get metal design, linked int, int size, input html, html website free copy, html design free, horizontal line example, free website html, free online catalog design, free html website, detailed use case example, design screens online, data entry screens, create text online free, create html page online

About the Employer:
( 1 review ) Macungie, United States

Projektin tunnus: #415113

Myönnetty käyttäjälle:

natgeo

Please see PM. Thanks

30 $ USD 2 päivässä
(111 arvostelua)
6.8

13 freelanceria on tarjonnut keskimäärin 152 $ tähän työhön

A2Design

We can move data from one MySQL db to another one. See our skills at http://www.a2design.biz/portfolio

200 $ USD 2 päivässä
(43 arvostelua)
7.8
indyaportal

Professional designer/developer here. Done many websites. Ready to start work. Please check PM for work samples and also check out my reviews.

200 $ USD 4 päivässä
(255 arvostelua)
7.3
freeworks

Please check my PM

200 $ USD 3 päivässä
(176 arvostelua)
6.9
momleetech

we can do it

120 $ USD 4 päivässä
(39 arvostelua)
5.9
Obialo

Hi, we ready to start. thanks

158 $ USD 4 päivässä
(23 arvostelua)
5.8
edatassol

We are ready to start work any time. We are waiting for your reply Please Check the PM.Thanks Thanks, Edatassol Technology

200 $ USD 10 päivässä
(51 arvostelua)
5.6
CItechict

Dear Concern, I am full of confident to provide you prominent service having high professional work unite as to accomplish your each and every single requisite. I hope you will consider my bid as a serious bidder who a Lisää

200 $ USD 7 päivässä
(46 arvostelua)
5.2
alexander2007

Please check PM. Thanks

190 $ USD 5 päivässä
(25 arvostelua)
4.8
ruimaxwell

I saw your other post with the same info, I know everything you need. Will be ready in 7 days or less. Thanks

175 $ USD 7 päivässä
(6 arvostelua)
3.5
riff79

Dear Sir, Please let me do it. Professional but cheaper. Thanks.

30 $ USD 2 päivässä
(1 arvostelu)
1.0
esskay

pls check pm

100 $ USD 7 päivässä
(0 arvostelua)
3.1
webstudios

Hi, my honor to work on this project. Can you please check pmb for more details.

170 $ USD 3 päivässä
(0 arvostelua)
3.4