Jump to content

Recommended Posts

Hi,

I need to create a form but I'm unsure what to create it with.

It needs to firstly display values for each item:

 

For example Red + £3, Blue -£2

 

It will then need to show a total at the bottom.

 

It then also needs to only show only items that value to the Model Chosen.

 

For Example if Model A is selected: Blue Green and Red display

If Model B is selected Blue, Yellow and purple display in the colour choice.

 

It then needs to be saved into a database and the values need to be easily changed.

 

Any suggestions?

Link to comment
https://forums.phpfreaks.com/topic/171827-calculating-form/
Share on other sites

CREATE TABLE models (
    models_id INTEGER NOT NULL AUTO_INCREMENT
);

CREATE TABLE colours (
    colours_id SMALLINT NOT NULL AUTO_INCREMENT
);

CREATE TABLE models_colours (
    models_colours_models_id INTEGER NOT NULL,
    models_colours_colours_id SMALLINT NOT NULL,
    PRIMARY KEY (models_colours_models_id, models_colours_colours_id)
);

INSERT INTO models_colours VALUES
(1, 1), # model A has color red
(1, 2), # model A has color green
(1, 3), # model A has color blue
(2, 3), # model B has color blue
(2, 4), # model B has color yellow
(2, 5); # model B has color purple

SELECT *
FROM colours
JOIN models_colours ON colours_id = models_colours_colours_id
WHERE models_colours_models_id = 1 # returns red, green and blue

Link to comment
https://forums.phpfreaks.com/topic/171827-calculating-form/#findComment-906097
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.