Project Detail

Description

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:
http://www.kentwoodmirrors.com/products.html, 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, '1.jpg', '', '', 316, '24\\" wide, 34\\" high and 3/8\\" deep', 189.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00),
(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, '0.jpg', '', '', 303, '22\\" wide, 28\\" high and 3/8\\" deep', 149.00, 304, '20\\" wide, 27\\" high and 3/8\\" deep', 149.00, 305, '23 1/2\\" wide, 33\\" high and 3/8\\" deep', 169.00, 306, '28\\" wide, 40\\" high and 3/8\\" deep', 209.00, 307, '24\\" wide, 36\\" high and 3/8\\" deep', 169.00),
(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, '2.jpg', '', '', 309, '23 1/2\\" wide, 30 1/2\\" high and 3/8\\" deep with a 1\\" beveled edge', 229.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00),
(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, '3.jpg', '', '', 318, '24\\" wide, 30\\" high and 3/8\\" deep with a 1\\" beveled edge.', 209.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00),
(37, '308', 'American made for amazing quality. Free shipping in the continental United States', 3, '4.jpg', '', '', 308, '28\\" wide, 28\\" high and 3/8\\" deep with a 1\\" beveled edge', 169.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00),
(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, '5.jpg', '', '', 327, '38 1/2\\" wide, 30\\" high and 3/8\\" deep', 259.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00),
(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, '6.jpg', '', '', 321, '20\\" wide, 28\\" high and 1/2\\" deep', 179.00, 324, '24\\" wide, 32\\" high and 1/2\\" deep', 209.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00);

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.


Additional files submitted:
project.doc