Getting a drop down list from a database in CodeIgniter [duplicate]

Question

I am new to CodeIgniter and I have been trying to populate the drop down list on the view page with data from the database with no success. I tried using the recomendations from this question but the drop down is still empty (display data from database to dropdown CodeIgniter)

Here is my view:

<label>City</label>
<select class="form-control>
    <option value="">All</option>
    <?php
    foreach($groups as $city)
    {
        echo '<option value="'.$city['cityidd'].'">'.$city['city'].'</option>';
    }
    ?>  
</select> <br/>

Here is my controller:

<?php 
class Main_controller extends CI_Controller 
{
    function __construct() 
    { 
         parent::__construct(); 
         $this->load->helper('url'); 
         $this->load->database(); 
    } 

      public function index() 
    { 
         $this->load->helper('form'); 
         $this->load->view('supplier_add'); 
    } 
}

Here is my model:

class Site_model extends CI_Model
{
    public function __construct() 
    {
        /* Call the Model constructor */
        parent::__construct();
    }
    function getAllGroups()
    {
        $query = $this->db->query('SELECT city FROM citys');

        return $query->result();
    }
}

The table name is "citys" then the corresponding column heads are "cityidd" and "city"

inside the construct() you load module like this $this->load->model('Site_model');. Then in index function $data['city']=$this->Site_model->getAllGroups(); — premi
– premi, Commented Oct 26, 2016 at 8:53

Rejoanul Alam · Accepted Answer · 2016-10-26 09:00:47Z

1

There are several issue found there. Make changes as below

 function __construct(){ 
    parent::__construct(); 
    $this->load->helper('url');
    $this->load_model('Site_model');
    $this->load->database(); 
} 
public function index(){ 
  $this->load->helper('form');
  $data['groups'] = $this->site_model->getAllGroups();
  $this->load->view('supplier_add',$data); 
}

Finally model

function getAllGroups(){
    $query = $this->db->query('SELECT cityidd,city FROM citys');
    return $query->result_array();
}

and now test

answered Oct 26, 2016 at 9:00

Rejoanul Alam

5,4004 gold badges42 silver badges71 bronze badges

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

2 Comments

ALFIE Over a year ago

What if I have many drop down lists that I want to populate from the database? Do I add the query for the other drop downs or how do I go about here? E.g the table is still "citys" then the other corresponding column heads are "id" and "paymentmodes" for another option

Rejoanul Alam Over a year ago

Yes use different query for that with different method like getAllGroups()

Mack4Hack · Accepted Answer · 2016-10-26 08:55:05Z

1

First change your SELECT query as

SELECT cityidd, city FROM citys

In the index() of controller change the code as

public function index() 
{ 
     $this->load->helper('form'); 
     $data['groups'] = $this->site_model->getAllGroups();
     $this->load->view('supplier_add',$data); 
}

answered Oct 26, 2016 at 8:55

Mack4Hack

1196 bronze badges

Comments

Darma · Accepted Answer · 2016-10-26 08:57:48Z

1

you have to call your model method and pass it to view in the controller, code:

public function index() 
{ 
$this->load->helper('form');
$this->load->model('site_model'); 
$data['groups'] = $this->site_model->getAllGroups();
$this->load->view('supplier_add',$data); 
}

if you are working on linux dont forget upper and lowercase names!

answered Oct 26, 2016 at 8:57

Darma

1131 gold badge2 silver badges5 bronze badges

Comments

premi · Accepted Answer · 2016-10-26 08:59:52Z

class Main_controller extends CI_Controller {

        function __construct() 
        { 
             parent::__construct(); 
             $this->load->helper('url'); 
             $this->load->database(); 
             $this->load->model('Site_model');
        } 

          public function index() 
        { 
             $this->load->helper('form'); 
             $data['groups']=$this->Site_model->getAllGroups();
             $this->load->view('supplier_add',$data); 
        } 
        }

Here is my model:

        class Site_model extends CI_Model
        {

        public function __construct() 
        {
            /* Call the Model constructor */
            parent::__construct();
        }
        function getAllGroups()
            {

                $query = $this->db->query('SELECT * FROM citys');


                return $query->result();

            }
        }

Try like this

mahethekiller · Accepted Answer · 2016-10-26 09:00:36Z

0

Make these changes

IN Model convert data to array as you are using it as array in view so change to this

function getAllGroups()
{
    $query = $this->db->query('SELECT * FROM citys');
    return $query->result_array();
}

In Controller

public function index() 
{ 
    $this->load->helper('form');
    $this->load->model('site_model'); 
    $data['groups'] = $this->site_model->getAllGroups();
    $this->load->view('supplier_add',$data); 
}

answered Oct 26, 2016 at 9:00

mahethekiller

5143 silver badges18 bronze badges

Comments

user6443475 · Accepted Answer · 2016-10-26 09:01:38Z

You are not loading model load the Model for example:-

        function __construct() 
        { 
             parent::__construct(); 
             $this->load->helper('url');
             $this->load->model('Site_model') 
             $this->load->database(); 
        } 

          public function index() 
        { 
             $this->load->helper('form');
             $data['record']=$this->Site_model->getAllGroups()
             $this->load->view('supplier_add', $data); 
        } 
        }

Model:- class Site_model extends CI_Model {

        public function __construct() 
        {
            /* Call the Model constructor */
            parent::__construct();
        }
        function getAllGroups()
            {

                $query = $this->db->query('SELECT city FROM citys');


                return $query->result();

            }
        }

Collectives™ on Stack Overflow

Getting a drop down list from a database in CodeIgniter [duplicate]

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related