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

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Related