Creating a dropdown using database in codeigniter

Question

Hi I am trying to create a dropdown using a CI forms. I have a table reseller and in that i have a field called Key. Now I have another table Users where i store user's information. I want to create a new user and in that user creation form i have a drop down field called Key where i want to fetch the key of all the resellers. So that i can identify which user is mapped to which reseller using that key.

For Controller I have done this :

$data = $this->user_m->array_from_post(array('sip_id','sip_pass','name','key','email', 'password','phone','status','created','balance'));


                $this->load->model('reseller_m');

                $this->data['resellers'] = $this->reseller_m->get('key');

                $data['password'] = $this->user_m->hash($data['password']);




                $key=$this->user_m->save($data, $id);
                redirect('admin/user');


                }

                $this->data['subview'] = 'admin/user/add';
                $this->load->view('admin/_layout_main', $this->data);

The View is

<tr>
    <td>Key</td>
    <?php if(count($resellers)): foreach($resellers as $reseller) ?>
    <td><?php echo form_dropdown('key', set_value('key', $user->key));?></td>
</tr>

But i dont get anything on screen. So How to create this drop-down?

is the : after if(count($resellers)) a typo or intentional? — Blip
– Blip, Commented Sep 12, 2015 at 6:52
@Blip actually i copied it from an example : <tr> <td>Status</td> <td><?php echo form_dropdown('status', array('Active' => 'active', 'Inactive' => 'inactive', 'Delete' => 'delete'), $this->input->post('status') ? $this->input->post('status') : $user->status ); ?></td> </tr> — Rajan
– Rajan, Commented Sep 12, 2015 at 6:54
in your last comment, there is a ternary if else operator (condition)?true : false which you are not using in your method that you have posted. So remove the : and check out. — Blip
– Blip, Commented Sep 12, 2015 at 6:59
i did that as well but not working i also did this <tr> <td>Key</td> <?php if(count($resellers)): foreach($resellers as $reseller) ?> <td><?php echo form_dropdown($reseller = array($reseller->id,$reseller->key));?></td> </tr> — Rajan
– Rajan, Commented Sep 12, 2015 at 7:02

Nisse Engström · Accepted Answer · 2015-09-20 18:54:11Z

3

Can you please try it like this:

    <tr>
        <td>Key</td>
        <?php if(count($resellers) > 0) {
                  foreach($resellers as $reseller) { ?>
                  <td>
                      <?php echo form_dropdown('key', set_value('key', $user->key));?>
                  </td>
                 <?php } 
                 } ?>
    </tr>

Is this variable right: $user->key? I think you need to use: $reseller->key.

edited Sep 20, 2015 at 18:54

Nisse Engström

4,76323 gold badges29 silver badges44 bronze badges

answered Sep 12, 2015 at 7:42

user2439481

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

11 Comments

Rajan Over a year ago

thanks for the answer in my crontroller i do this : $this->data['resellers'] = $this->reseller_m->get(); but then also i get an error undefined value Reseller

user2439481 Over a year ago

@Rajan Can you please tell me what value store in this array $resellers ? i mean in this $this->data['resellers'] = $this->reseller_m->get();

Rajan Over a year ago

i should have been blank coz i am trying to fetch the reseller values in user controller

Rajan Over a year ago

how do i pass that key of reseller from my controller to view?

Rajan Over a year ago

any idea where i am wrong in my controller i did this :$this->data['resellers'] = $this->reseller_m->get()

|

Collectives™ on Stack Overflow

Creating a dropdown using database in codeigniter

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related