Multiple values in the select field going into multiple database columns

Question

i'm kind of new to coding so I came here for help.

I'm making a website and I've done all the variables correctly prior to this and everything is working but I'm a bit lost on one part.

I have a select field that shows [4D SEDAN, AUTOMATIC, 6208 CC, V8]

Am I able to do some code that makes; - 4D go into the 'Doors' column - SEDAN go into the 'Body' column - AUTOMATIC go into the 'Transmission' column - 6208 CC go into the 'Engine Size' column - V8 go into the 'Cylinders' column

Appreciate any help.

Welcome to Stack Overflow. Please read How to Ask. What have you tried? Could you please post your code? — Ben
– Ben, Commented Jan 6, 2016 at 9:39
I haven't put code in for it yet, I didn't want to do it and then find out that it wasn't actually possible. What I posted is an example of what I am going to do and was wondering if it is possible to do it. I also tried looking through other posts but couldn't find anything. Sorry for sounding noobish. — Brandon
– Brandon, Commented Jan 6, 2016 at 9:44

Daniel PurPur · Accepted Answer · 2016-01-06 09:48:58Z

1

Anything is possible BUT! That is not a write way of doing it but if you insist you can use if and else statement!

// To separate 4D and SEDAN you must write a strpos() or a regex!
if ($selectValue == '4D SEDAN'){
 $doorsColumn = $selectValue;
}elseif($selectValue == 'AUTOMATIC'){
 $TransmissionColumn = $selectValue;
}

Best way is to have a separate dropdown menu for each category.

answered Jan 6, 2016 at 9:48

Daniel PurPur

5293 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Brandon Over a year ago

Thanks for that, I will try it out!

Brandon Over a year ago

With separate values it makes it more time consuming for the users when theyre selecting what car to sell. I made seperate drop down menus for make, model and badge. However, when I've looked at other websites, after they have selected the make, model and badge, there is another dropdown which has multiple values showing [4D SEDAN, AUTOMATIC, 6208 CC, V8]. Wasn't sure how they made this value go into seperate database columns.

Daniel PurPur Over a year ago

separating above will help the user to sell or search for a very specific car. like that you are generalising it. Also it will help you to collect data more easily. a good example of a car selling website is Autotrader.co.uk. everything is separate and distinct.

Daniel PurPur Over a year ago

In www.Autotrader.co.uk click on more options and enter a UK post code if you dont know any use NW8 9AY

Collectives™ on Stack Overflow

Multiple values in the select field going into multiple database columns

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related