CODEWITHSUNDEEP
phpcodeigniter
user7047368
user7047368

Reputation: 167

Fetching data in codeigniter getting fatal error for dropdown

Fetching data in codeigniter getting fatal error for dropdown.

Fatal error: Call to undefined method Blogs_model::where() in C:\xampp\htdocs\project\admin\application\models\blogs_model.php on line 32

Blogs:

function add()
{
    $data['categorylist']=$this->blogs_model->categories_dropdown();
    $data['mainpage']='blogs';
    $data['mode']='add';
    $this->load->view('templates/template',$data);
}

function addblogs()
{
    $this->load->library('form_validation');
    $this->form_validation->set_error_delimiters('<br /><span class="error"> ','</span>');
    $this->form_validation->set_rules('category_id','Category Name' , 'required');
    $this->form_validation->set_rules('blog_title','Blog Title');
    $this->form_validation->set_rules('description','Blog Description');
    if($this->form_validation->run()== FALSE)   
    {   
    $data['categorylist']=$this->blogs_model->categories_dropdown();
    $data['mainpage']='blogs';
    $data['mode']='add';
    $this->load->view('templates/template',$data);
    }
    else
    {
        $this -> blogs_model -> insertblogs();
        $this->flash->success('<h2>blogs Added Successfully!</h2>');
        redirect('blogs');
    }
}

Blogs_model

function categories_dropdown()  
{       
    $this->table = 'category';      
    $this->where('status',1);       
    $categorylist=$this->dropdown('category_id','category_name');       
    return $categorylist;
}

View:

<div class="element">
    <label for="categoryname"><font color="black">Category Name</font></label>
    <?php
            $categorylist['']='--Select Category Name--';
            $category_id="id='category_id'";
            if($this->input->post('category_id')) $selected=$this->input->post('category_id');else $selected='';
            echo form_dropdown('category_id',$categorylist,$selected,$category_id);
            ?>
            <?php echo form_error('category_id', '<div class="error">', '</div>'); ?><br/><br/>     
    </div>

Upvotes: 0

Views: 51

Answers (1)

Wasim Akhtar
Wasim Akhtar

Reputation: 9

Please update your model as follows.

    function categories_dropdown()  
    {       

        $this->db->select('category_id','category_name');
        $this->db->from('category');
        $this->db->where('status',1);
        $result =   $this->db->get();
        return $result->result();

    }

Upvotes: 0

Related Questions