Data in Drop Down List Retrieve From DB in Codeigniter

Question

In creating dropdown in my project encounters problems(errors). I'm very new to codeigniter.

Please check and advise what is wrong with with my code?

Model

Public function get_region()
{
    $return = array();
    $query  = $this->db->get('region')->result_array();
    if( is_array( $query ) && count( $query ) > 0 ){
    $return[''] = 'please select';
    foreach($query as $row)
    {
        $return[$row['id']] = $row['r_e_name'];
    }
}

Controller

public function index()
{
    $this->load->model('country_model');
    $data['countries'] = $this->country_model->get(false);
    $data['page_title']  = "Countries"; 
    $data['return']=$this->country_model->get_region();
    $this->template->show('countries', $data);
}

View

<tr>
    <td>
        <?php echo form_label('Region Name *', 'r_e_name'); ?>
    </td>
    <td>
        <?php echo form_dropdown('r_e_name', $return);?>
    </td>
</tr>

Errors

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: return

Filename: views/countries_add.php

Line Number: 17

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: helpers/form_helper.php

Line Number: 331

I've never used $this->template->show() but based on my testing in my own CodeIgniter project, there isn't anything special about using return as an array key or variable name. It works fine. I cannot replicate your problem. — mickmackusa
– mickmackusa ♦, Commented Jul 9 at 9:37
Topically related: How to use query result set data in CodeIgniter's form_dropdown() helper function — mickmackusa
– mickmackusa ♦, Commented Jul 9 at 9:38

joni_demon · Accepted Answer · 2013-12-11 10:17:11Z

2

Model

function get_country() {
    $return[''] = 'please select';
    $this->db->order_by('c_e_name', 'asc'); 
    $query = $this->db->get('country'); 
    foreach($query->result_array() as $row){
        $return[$row['id']] = $row['c_e_name'];
    }
    return $return;
}

function get_region(){
    $return[''] = 'please select';
    $query  = $this->db->get('region');
    foreach($query->result_array() as $row){
        $return[$row['id']] = $row['r_e_name'];
    }
    return $return;
}

Controller

public function index()
{
    $this->load->model('country_model');
    $data['country'] = $this->country_model->get_country();
    $data['region']  = $this->country_model->get_region();
    $data['page_title']  = "Countries";
    $this->template->show('countries', $data);
}

View

<tr>
    <td><?php echo form_label('Country *', 'c_e_name'); ?></td>
    <td><?php echo form_dropdown('c_e_name', $country);?></td>
</tr>
<tr>
    <td><?php echo form_label('Region Name *', 'r_e_name'); ?></td>
    <td><?php echo form_dropdown('r_e_name', $region);?></td>
</tr>

edited Dec 11, 2013 at 10:17

answered Dec 11, 2013 at 5:32

joni_demon

6666 silver badges12 bronze badges

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

10 Comments

Rurouni Over a year ago

The same errors show again even when i add "return $return;".

Rurouni Over a year ago

only one error occur foreach loop A PHP Error was encountered Severity: Warning Message: Invalid argument supplied for foreach() Filename: helpers/form_helper.php Line Number: 331

joni_demon Over a year ago

it seems like the error is in this line $data['countries'] = $this->country_model->get(false);

Rurouni Over a year ago

I think foreach error come from foreach($query->result_array() as $row) { $return[$row['id']] = $row['r_e_name']; }

joni_demon Over a year ago

that method seems not returning valid array to be supplied in your dropdown, because I already tested the script and there is nothing wrong. Just comment that line and it will work fine.

|

user2936213 · Accepted Answer · 2013-12-11 05:46:50Z

0

You have not returned the result set from model. Just put

return $return;

at the end of your function get_region() in model.

answered Dec 11, 2013 at 5:46

user2936213

1,0111 gold badge8 silver badges19 bronze badges

2 Comments

Rurouni Over a year ago

The same errors show again even when i add "return $return;".

user2936213 Over a year ago

try changing your variable name as return is a reserved word

Collectives™ on Stack Overflow

Data in Drop Down List Retrieve From DB in Codeigniter

2 Answers 2

10 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related