mysql - Adding product attributes -


while listing product in catalog every product has few general attributes mrp, price, sku, product description etc etc, applicable all.

but there few attributes product specific, example, t-shirts can have color , size, laptops have memory, resolution, processor speed, mobile phones can have memory, camera resolution, , operating system.

each of above attributes in example product specific , important.

taking cue out of opencart ecommerce, believe, replicated database few changes (to suit needs) , here is.

products

enter image description here

the idea record product information/attribute (which applicable described in first paragraph) product table in product table.

enter image description here

attributes

enter image description here

then comes attributes table store attributename eg, resolution, memory, color, size, processor speed etc etc

enter image description here

product_attribute

enter image description here

this table save productid of product table, attributeid of attributes table , value of attribute attributevalue eg . resolution = 15000pixels(attributevalue), memory = 500gb (attributevalue), color = blue (attributevalue).

enter image description here

up till have 3 tables records need displayed on product detail page this

enter image description here

opencart, if not mistaken, uses left join statement combine product, attribute , product_attribute display product on product detail pages , need do.

how use left join statement display product, attribute , product_attribute display products , attributes? please note there can few products needs no attribute.

unfortunately, going full recursion left join 1 of things sql not at. in fact, i'm pretty sure impossible, @ least in standard sql.

a decent alternative use simple inheritance having main "products table" base class, , extending other different tables types (such "cell phone" or "t-shirt"). extension, in case, can performed having different new tables , have of them have foreign key products table.

then if don't have way distinguish type of product in product table, add "kind" or "type" attribute , in application perform left join based on attribute, needed.


Comments

Post a Comment

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

i have web app developed using google app script htmlservice , html form, populating excel sheet in google drive using spreadsheetapp . , 1 section calling contentservice download data excel file. function doget(e) { // read excel sheet //getappfile(); // render application html template return htmlservice.createtemplatefromfile('index').evaluate() .settitle('go smart') .setsandboxmode(htmlservice.sandboxmode.iframe); } function downloaddoublequatecsvfile() { var sheetid = propertiesservice.getscriptproperties().getproperty('sheetid'); var ss = spreadsheetapp.openbyid(sheetid).getactivesheet(); //var ss = spreadsheetapp.getactivespreadsheet().getactivesheet(); var maxcolumn = ss.getlastcolumn(); var maxrow = ss.getlastrow(); var data = ss.getrange(1, 1, maxrow, maxcolumn).getvalues(); if (data.length > 1) { var csv = ""; (var row = 0; row < data.length; row++) { (var c...
Read more

javascript - Function overwritting -

is there way overwrite function or event handling in function? using addeventlistener, can have many event handlers on element want var test=document.getelementbyid("div"); test.addeventlistener("click",function(){alert("im first");},false); test.addeventlistener("click",function(){alert("im second");},false); // alerts "im first" , after "im second" but if want overwrite function/event example based on client width example this function one() { alert("first"); } function two() { alert("second"); } window.onresize = function() { var test = document.getelementbyid("div"); if (window.innerwidth > 500) { test.onclick = 1 } else { test.onclick = two; } } is possible in javascript? in case use effective little known approach. addeventlistener can accept object property handleevent event handler. in case it's easy overwr...
Read more

php - Find a regex to take part of Email -

i have following emails need extract part from: bestellnummer xxx: 1 von xxx, 1er pack ------------- anfang der nachricht ------------- foo bar baz foo bar baz // <<<<< need text here ------------- ende der nachricht ------------- ------------- anfang der nachricht ------------- foo bar baz foo bar baz ------------- ende der nachricht ------------- there 0 unlimited occurences of ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- and i'm able extract first part regex: $re = "/------------- .*? -------------.?(.*?).?------------- .*? -------------/s"; but, i'm quite new on learning regex, i'm pretty sure there must better regex extract part (foo bar baz foo bar baz) of text between ------------- anfang der nachricht ------------- ------------- ende der nachricht ------------- as can in different languages, i'm using .? to match between hyphens. i...
Read more