how to get data in dropdown from database in CodeIgniter

Question

Hi any one help me how to get data in drop down from database in codeigniter.below is my code it is not work working. The below code is not working properly the drop down not appearing when click please help me to get data. I am doing it in codeigniter. I want to get data from database in dropdown. I think the code is perfect am new to codeigniter the below code is not working properly the drop down not appearing when click please help me to get data. I am doing it in codeigniter. I want to get data from database in dropdown. I think the code is perfect am new to codeigniter

Model:

public function getdepartment() {
     $query = $this->db->query("select department from object_data");
     $result = $this->executeSelectQuery($query);
     return $result;
}

View:

<div class="col-md-4">
    <h4> Courses:</h4>
    <?php $dp = $this->base_model->getdepartment(); ?>
</div>
<div class="col-md-8">
      <select name="report_type" class="form-control">
      <?php foreach($dp as $row) { 
            echo '<option value="'.$row->department.'">'.$row->department.'</option>';
      }?>
      </select>
</div>

Controller:

public function employe() {
     $data['title'] = 'title'; 
     $this->load->model('base_model');
     $data['groups'] = $this->base_model->getCourseAll();
     $data['dprtmnt'] = $this->base_model->getdepartment();
     $this->load->view('employe', $data);
}

the above code is not working properly the drop down not appearing when click please help me to get data

Possible duplicate of display data from database to dropdown CodeIgniter — Himanshu Upadhyay
– Himanshu Upadhyay, Commented Nov 3, 2017 at 4:06

Janak Developer · Accepted Answer · 2017-11-03 04:53:23Z

0

Model

 public function getdepartment() {
 $query = $this->db->query("select department from object_data");
 return $query->result();
 }

controller

 public function employe() {
 $data['title'] = 'title'; 
 $this->load->model('base_model');
 $data['groups'] = $this->base_model->getCourseAll();
 $data['dprtmnt'] = $this->base_model->getdepartment();
 $this->load->view('employe', $data);
 }

views

<div class="col-md-4">
<h4> Courses:</h4>
<?php $dp = $this->base_model->getdepartment(); ?>
</div>
<div class="col-md-8">
  <select name="report_type" class="form-control">
  <?php foreach($dprtmnt as $row) { 
        echo '<option value="'.$row->department.'">'.$row-
 >department.'</option>';
  }?>
  </select>
</div>

answered Nov 3, 2017 at 4:53

Janak Developer

262 bronze badges

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

Comments

NikuNj Rathod · Accepted Answer · 2017-11-03 06:39:14Z

0

you should try codeigniter own methods it is the good way for practice.

Model :

public function getdepartment() {
     $query = $this->db->select('department')->from('object_data')->get();
     return $query->result();
 }

Controller :

public function employe() {
     $data['title'] = 'title'; 
     $this->load->model('base_model');
     $data['groups'] = $this->base_model->getCourseAll();
     $data['dprtmnt'] = $this->base_model->getdepartment();
     $this->load->view('employe', $data);
 }

Views :

<select name="report_type" class="form-control">
    <?php foreach($dprtmnt as $row) { 
      echo '<option value="'.$row->department.'">'.$row-
>department.'</option>';
    }?>
</select>

edited Nov 3, 2017 at 6:39

NikuNj Rathod

1,6381 gold badge19 silver badges29 bronze badges

answered Nov 3, 2017 at 5:04

hasnain

1271 silver badge10 bronze badges

Collectives™ on Stack Overflow

how to get data in dropdown from database in CodeIgniter

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related