Codeigniter Multi Select insert values into database

Question

I have a form that uses a multi select so you can select multiple options, how would I make it so that if you pick 2 options, it adds them both into the database as

option1,option2,option3

I'm kind of still new to PHP, I know I will have to put it as an array, I'm just not sure exactly how to do it.

Muhammad Raheel · Accepted Answer · 2012-04-25 13:51:08Z

1

Use varchar field in data base table and then insert it. First take a php variable and assign all values to it should be comma seperated. then use this variable in your query to insert. When you get values by select use explode function there.

answered Apr 25, 2012 at 13:51

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

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

2 Comments

WittyPleb Over a year ago

Thanks, I got the rest from there :)

Muhammad Raheel Over a year ago

While being on the stack overflow you should accept answers vote up etc this will increase your and others reputation

Christian Giupponi · Accepted Answer · 2012-04-25 13:54:04Z

1

If you whant to have an array you can use the php explode function:

$your_options = "option1,option2,option3";
$array = explode(",", $your_option);

now you can access with $array[0], $array[1] and so on...

answered Apr 25, 2012 at 13:54

Christian Giupponi

7,62811 gold badges76 silver badges120 bronze badges

Collectives™ on Stack Overflow

Codeigniter Multi Select insert values into database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related