Getting values into dropdown from DB

Question

I want to use my db values of table (Category) into a product/add form, but not able to get the values.

Model :
 function getAllCategories()
    {
        $query = $this->db->get('category');
        return $query->result_array();
    }

 Controller:

function getAllCategories()
   {
      $data['groups'] = $this->productmodel->getAllCategories();

       $this->load->view('admin/product/add',$data);
   }   

  View:

<div class="form-group">
                  <label for="exampleInputEmail1">Brand </label>
                  <select class="form-control">
                <?php 
                $i = 0;
                while($i < count($groups)){
                  $val= $groups[$i]['value'];
                  $des = $groups[$i]['category_name'];
                  echo "<option value='$i'>$des</option>";
                }?>
               </select>
 </div>

Help me please it is urgent.I took reference from stack overflow only, but was not able to do it.

Lets-c-codeigniter · Accepted Answer · 2019-08-27 11:28:34Z

1

Use foreach loop for array data type

<select class="form-control">
<?php 
foreach($groups as $group)
{
   $val= $group['value']; 
   $des = $group['category_name'];
   echo "<option value='$val'>$des</option>";
} ?>
</select>

answered Aug 27, 2019 at 11:28

Lets-c-codeigniter

7142 gold badges7 silver badges19 bronze badges

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

2 Comments

Himanshu Over a year ago

The <option> value is coming blank. The values from db are not getting print.

Lets-c-codeigniter Over a year ago

Print the $groups variable using print_r($groups); , you will get clear data.

Riosant · Accepted Answer · 2019-08-27 11:19:25Z

0

Himanshu, Simply replace your code with this one in your view. The thing is that you are not incrementing the value of $i

<div class="form-group">
    <label for="exampleInputEmail1">Brand </label>
    <select class="form-control">
        <?php
        $i = 0;
        while ($i < count($groups)) {
            $val = $groups[$i]['value'];
            $des = $groups[$i]['category_name'];
            echo "<option value='".$i."'>$des</option>";
            $i++;
        } ?>
    </select>
</div>

answered Aug 27, 2019 at 11:19

Riosant

3443 silver badges16 bronze badges

Comments

Lets-c-codeigniter · Accepted Answer · 2019-08-28 12:11:24Z

0

No panic it's should be easy. Do you get some data from model in controller ?
First, var_dump this line $this->productmodel->getAllCategories();
Second, I think you should do $i++ in your while cycle

Like this

<?php 
$i = 0;  
while($i < count($groups)){ 
  $val= $groups[$i]['value']; 
  $des = $groups[$i]['category_name']; 
  echo "<option value='$i'>$des</option>"; 
  $i++; 
}?>

edited Aug 28, 2019 at 12:11

Lets-c-codeigniter

7142 gold badges7 silver badges19 bronze badges

answered Aug 27, 2019 at 11:09

MTakumi

3403 silver badges11 bronze badges

1 Comment

Himanshu Over a year ago

Okay will check it sir.

Collectives™ on Stack Overflow

Getting values into dropdown from DB

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related