triggers - Automatically create and update one to one relationships in MySQL -

-

i have web shop (zen-cart)that has inefficient attribute schema. 1 option can used attributes many products. (instead of other way around). have tried use views make things easier, creating new attributes still tedious. have looked changing php-code, difficult. solution multi-lingual, don't need.

the tables following:

tb_products: prod_id  tb_description: prod_id lang_id product_name (t-shirt)  tb_attributes: attr_id prod_id option_id values_id  tb_options: option_id language_id option_name (size & color)  tb_values: value_id option_id language_id value_name (xs red)

as quick-fix, following:

  1. make additional fields:

    tb_products: product_name option_name [optional - if attributes created] value_concatinator [optional]  tb_attributes: value_name_1 value_concatinator_1 [optional] value_name_2 [optional] value_concatinator_2 [optional] value_name_3 [optional]

  2. create trigger, when create new row in tb_products, automatically create new row in both tb_description , tb_options, respectively product_name , option name taken tb_products. every time these fields updated in tb_products, must updated in tb_description , tb_options. let option_id same prod_id

  3. when creating new row in tb_attributes, automatically:

    • insert option_id parental product row.
    • create new row in tb_values. value_name concationation of value names , value_concatinators in attributes

    concat(value_name_1, ' ' , value_concatinator_1, ' ', value_name_2, ' ', value_concatinator_2, ' ', value_name_3) tb_attributes

every time these fields updated in tb_attributes, must automatically updated in tb_values

so main object actively update tables tb_products , tb_attributes, , let mysql update other tables every time product or attribute created or updated in new fields mentioned above.

i not sure if triggers answer, or if columns can made automatically updated (and if last solution make problems how columns defined in php-code.

for of make values_names array: how supposed be. doesn't work out quantities, customers can add combinations don't exist. people have spent 1000s of hours trying fix it. no avail. want solution works backoffice-wise, , makes easy me sort etc.

we use filemaker , magneticone normal backoffice activities, mysql workbench changes database. can read php, code complex me change (and professionals make lot of mess when trying upgrade newer versions, due necessary customizations)


Comments

Post a Comment

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

-
this svg contains rect overflows svg element: <svg id='svg' width='10' height='10'> <rect x='-10' y='-10' width='30' height='30'/> </svg> chrome 28 , opera 12 return getboundingclientrect() svg element width , height of 10. firefox 23 reports width , height of 30. correct? jsfiddle the relevant spec cssom , delegates svg spec if svg element not "have associated css layout box". haven't found definition of "having associated css layout box", correct result seem hinge on definition, getbbox returns 30x30 rect in browsers. this firefox bug fixed now, fix in firefox nightlies , should make through firefox 33 released on 14 october 2014. see bug 530985 details.
Read more

gcc - Calling fftR4() in c from assembly -

-
i trying asm fft implementation www.embeddedsignals.com work. running make gives error: undefined reference fftr4(short*, short*, int) at top of asm have .syntax unified .thumb .global fftr4 .type fftr4, %function and there #define's associate c functions arguments registers followed macros fftr4 function uses. after that, fftr4 called .thumb_func fftr4: stmfd sp!, {r4-r11, lr} mov tmp0, #0 // bit reversed counter mov tmp1, #0 .word 0xf3a2fa92 //rbit r3,r2 //rbit r,n lsl r,#3 and c code follows: void fftr4(short *y, short *x, int n); short x[512]; short y[512]; int i; void loop() { (i=0;i<512;i++) x[i]=0; (i=0;i<512;i=i+8) { x[i+0]=16384; x[i+2]=16384; x[i+4]=-16384; x[i+6]=-16384;} fftr4(y, x, 256); serialusb.println(y[128]); serialusb.println(y[129]); serialusb.println(y[384]); serialusb.println(y[385]); // expected results: //y[128]is 8191; y[129] -8190 y[...
Read more

.htaccess - Matching full URL in RewriteCond -

-
i'm trying block post access site (and return 403), except 2 ip's , 1 url ( http://mydomain.com/about-us/contact-us/ ). here's have: rewritecond %{request_method} post rewritecond %{remote_addr} !=1.2.3.4 rewritecond %{remote_addr} !=4.3.2.1 rewritecond %{request_uri} !^http://mydomain.com/about-us/contact-us/$ rewriterule ^ / [f] these rules allowing access ip properly, contact page still not accessible. i'm not sure i'm using request_uri correctly? i've tried variations relative urls rewritecond %{request_uri} !^/about-us/contact-us$ , rewritecond %{request_uri} !^/about-us/contact-us/$ without luck. what doing wrong please? it looks me rule on file name specific. if relax bit, should work. made few other esthetic tweaks. give try: rewritecond %{request_method} post rewritecond %{remote_addr} !^1.2.3.4 rewritecond %{remote_addr} !^4.3.2.1 rewritecond %{request_uri} !about-us/contact-us rewriterule ^ - [f]
Read more