Codeigniter dropdown values are not shown

Question

Codeigniter
I'm using a drop down and My problem is that i'm not getting the value from the database

Here is my code

Table Fields:

id, name,category_online

Model code - category_model.php

<?PHP   
   class category_model extends CI_Model{
       public function __construct() {
    parent::__construct();
    }
public function get_all_online_select() {
        $this->db->select('id, name'); //change this to the two main values you want to use
        $this->db->from('category');
        $this->db->where('category_online', 1);
        $query = $this->db->get();
        foreach($query->result_array() as $row){
            $data[$row['id']]=$row['name'];
        }
        return $query->result_array();
}
}
?>

Here is my Controller -Welcome.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Welcome extends CI_Controller {
   public function __construct() {
    parent::__construct();
    }
function add_content() {
        $data = array();
       $this->load->helper('form');
        $this->load->model('category_model');
        $data['select_options'] = $this->category_model->get_all_online_select();
        $this->load->view('add_content', $data);
}
}

Here is my view-add_content.php

<?php
   echo form_open('save_content');
   echo form_fieldset();
   echo form_dropdown('categories', $select_options);
   echo form_submit('category_submit', 'Submit');
   echo form_fieldset_close();
   echo form_close();
?>

This is what the out put looks like

http://jsbin.com/ecuzil/2/edit

No values from the database are being displayed

GautamD31 · Accepted Answer · 2013-05-30 11:48:31Z

1

You need to return $data from the model file like

public function get_all_online_select() {
    $this->db->select('id, name'); //change this to the two main values you want to use
    $this->db->from('category');
    $this->db->where('category_online', 1);
    $query = $this->db->get();
    $data = array();
    $my_data = $query->result_array();
    foreach($my_data as $row){
        $data[$row['id']]=$row['name'];
    }
    return $data;
 }

edited May 30, 2013 at 11:48

answered May 30, 2013 at 11:42

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

4 Comments

Sotero Aranguren Over a year ago

Now the error is A PHP Error was encountered Severity: Notice Message: Undefined variable: data Filename: models/category_model.php Line Number: 14 A PHP Error was encountered Severity: Warning Message: Invalid argument supplied for foreach() Filename: helpers/form_helper.php Line Number: 331

GautamD31 Over a year ago

then define the $data as array in model file

Sotero Aranguren Over a year ago

I changed the return $query->result_array(); to $data ..Now I am getting that error

Kyslik Over a year ago

note that, $data should be processed in controller not in model (explicitly I mean foreach loop).

Collectives™ on Stack Overflow

Codeigniter dropdown values are not shown

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related