Codeigniter: Using set_select() if dropdown data comes from the db

Question

I have a dropdown <select> field which gets its values from the db. I'm currently looking for a way to use set_select() but have been unsuccessful. Here's my existing view:

<select name="userbase">
    <?php echo $userbase_list; ?>
</select>

The variable $userbase_list is a string containing all the <option value="">text</option> html to be inserted. Since this <select> is generated from the db, does that mean I can't use the CI set_select() anymore?

Wait why are you storing them in a string like that if you already have the form helper built into CI? — Cyclone
– Cyclone, Commented Feb 14, 2012 at 21:09
I noticed that set_select() doesn't work if you place a default value in form_dropdown. I don't want to place a default but I need to get to the 4th parameter so I can apply a class or any other HTML attribute. Is there a way to bypass setting the default entirely? — enchance
– enchance, Commented Feb 14, 2012 at 21:46

Jordan Arsenault · Accepted Answer · 2012-02-15 00:30:31Z

3

$array_of_options= array("key_one"=>"val_one", "key_two"=>"val_two");

foreach($array_of_options as $k => $v)
{
    $selected = ($v === $db_result) ? 'selected=selected' : '';
    echo '<option '.$selected.' value='.$k.'>' . $v . '</option>';
}

edited Feb 15, 2012 at 0:30

Jordan Arsenault

7,4819 gold badges55 silver badges103 bronze badges

answered Feb 14, 2012 at 21:26

Philip

4,5822 gold badges22 silver badges28 bronze badges

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

1 Comment

gen_Eric Over a year ago

$selected needs to be concated to the string too. I fixed it for you :-)

Collectives™ on Stack Overflow

Codeigniter: Using set_select() if dropdown data comes from the db

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related