We need to generate one dynamic form, from 2 drop down list.
Height: Height drop down lst have all height enteries in database. height_id and height_name
Width: Width drop down lst have all didth enteries in database. width_id and width_name
Ref: [url removed, login to view]
When user select any height from drop down list it will add one row in table. And the added height should be remove from drop down list (Working)
When user select any width from drop down list it will add one colum in table. And the added width should be remove from drop down list (Working)
Now each crossed cels should make input box in each, just like running on ref form. And this form should post values in corespondance of input box name.
Just try to add some heights & width in above form. And then you'll see the values display like [15x12] with one input text box. (working)
What is [15x12] => Height : 15, width : 12.
What we need .... ??
Height 15: ... 15 ...
Width 12: ... 12 ...
When this form submit values to us. We will get all values in bellow format. (not working)
'310x134' = '50', // 15x12
and so on
Note : 310 is the option values for height 15 and 134 is the option value for width 12
Why we need this...?
We are making a batch mysql entry in database. Where we need ... height_id, width_id and price.
In above example we will get height_id as 310 and width_id as 134 and price are 50$
If you have any better suggestion. Let us know.
Here is the excel which we need fill in the referenced form. Have a look, may be give an idea .. Why we need this form
Here is the Database snap, where we need to enter height and width values according to their ids ...
Height id = options_height_id
width id = options_width_id
`products_attributes_id` int(11) NOT NULL auto_increment,
`products_id` int(11) NOT NULL,
`options_width_id` int(11) NOT NULL,
`options_height_id` int(11) NOT NULL,
`options_values_price` decimal(15,4) NOT NULL,
`price_prefix` char(1) NOT NULL,