Recover string in database in a dynamic form_dropdown

Question

I am trying to retrieve from the database a string in a field dropdown of a form on a page of update, my view goes below.

$option = array(NULL => 'Selecione uma categoria');

foreach ($categories_list->result() as $category):

$option[$category->categoryID] = $category->categoryTitle;

endforeach;

echo form_dropdown('categoryname', $option, set_value('categoryname', $post->categoryTitle));

However, the dropdown does not display the database string. Could someone help me?

Answer 1

From what I see in the code of your question, the only thing incorrect is the use of set_value(), if you remove it should work as expected.

Note: the set_value() serves to set the value of a regular input or text box. Does not work with check boxes.

You can learn more at Codeigniter: User’s Guide.

^{It’s almost the end of the page.}

---

In your controller you’ll have something like:

$categoriesList = $this->db->get('categories')->result();

Then you can generate your own select with the help of helper form_dropdown:

$options = array(null => "Selecione uma categoria");

foreach ($categoriesList as $cat) {
    $options[$cat->categoryID]=$cat->categoryTitle;
}

echo form_dropdown('categoryname', $options, $post->categoryTitle);

Answer 2

I discovered the problem that was located on this line:

$option[$category->categoryID] = $category->categoryTitle;

Which I corrected by swapping for:

$option[$category->categoryTitle] = $category->categoryTitle;

And it’s already working with the code:

echo form_dropdown('categoryname', $option, $post->categoryTitle); 

In the selection box did not have the Ids as value of each option but the text that is equal to the label displayed to the user.