Show Data from Database in a multiple Dropdown using PHP

Question

I'm using Chosen.js to show multi select dropdown menus in my forms. All these selected data by a user goes to a mysql database in a single string separated by a ";". So far, so good.

Now my problem is, I want to give my users a edit form, where they can edit all there given data. So I have to read out the data from the database and shown this up on the form. But what is the right way for a multi select dropdown menu?

<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>

Data saved in Database like: "21;22;23".

I'm really stuck at this...

syed suleman · Accepted Answer · 2015-06-26 06:30:09Z

2

Get your data in array like

$selected_items= explode( ";", "21;22;23" );

then use in_array( $option_value, $selected_items ); to detect if that option is selected.

answered Jun 26, 2015 at 6:30

syed suleman

5422 silver badges6 bronze badges

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

1 Comment

CallHimX Over a year ago

Yea, thats it...this is so embarrassing. Bring the data back to an array and search for the values...thank you for this thought-provoking impulse.

Swaraj Giri · Accepted Answer · 2015-06-26 06:29:40Z

0

Look into how you can- Normalize data

Till you do that, you can have a hack of splitting the string with ;

var data = "21;22;23"; var ids = data.split(';') will give you an array

of the ids ["21", "22", "23"]

Iterate over the ids and create your dropdown elements.

var html = '';
$.each(ids, function(id) {
   html += '<option value="' + id + "'>' + id + '</option>';
});

$('.some-dropdown').html(html);

answered Jun 26, 2015 at 6:29

Swaraj Giri

4,0372 gold badges30 silver badges45 bronze badges

Collectives™ on Stack Overflow

Show Data from Database in a multiple Dropdown using PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related