create a select dropdown from database in codeigniter [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 5 months ago.

Improve this question

I am new with codeigniter.I want to make a select dorpdown that gets its value and title from database.I tried some codes but it did not work.There are my codes:

Model

function get_sec_info(){
$records=$this->db->query('SELECT sec_id,name FROM section');
if($records->num_rows() > 0)
return $records->result();}

Controller

  function sec_ifo(){
$data['rec']=$this->mymodel->get_sec_info();
$this->load->view('article',$data);}

View

 <select name="section">
<?php foreach($rec as $row) {?>
<option value="<?php echo $row->sec_id?>"><?php echo $row->name ?></option>"
<?php } ?>

It does not show any error and any option to show

possible duplicate of making a select dropdown from database in codeigniter — Samutz
– Samutz, Commented Feb 25, 2014 at 17:25
Topically relevant: How to use query result set data in CodeIgniter's form_dropdown() helper function — mickmackusa
– mickmackusa ♦, Commented Jul 9 at 14:38

Gonz · Accepted Answer · 2014-02-25 17:27:28Z

1

In the controller you set "red" $data['red'] and in the view you access "rec" foreach($rec

answered Feb 25, 2014 at 17:27

Gonz

1,20913 silver badges26 bronze badges

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

Comments

Ahmed iqbal · Accepted Answer · 2014-02-25 17:41:59Z

0

Model:

function get_sec_info(){

$this->db->select('sec_id,name');

$records = $this->db->get('section');

return $records->result();

}

Controller:

function sec_ifo(){

$this->load->model('mymodel');

$this->data['red'] = $this->mymodel->get_sec_info();

$this->load->view('article',$this->data);

}

View:

<select name="section">
<?php foreach($red as $row) { ?>
    <option value="<?php echo $row->sec_id; ?>"><?php echo $row->name; ?></option>
<?php } ?>

answered Feb 25, 2014 at 17:41

Ahmed iqbal

5971 gold badge8 silver badges29 bronze badges

Comments

Daniel Lucena · Accepted Answer · 2014-02-25 18:39:34Z

0

Model

public function getClasse() {
    $query(`enter code here`);       
    $result = $this->db->query($query)->result_array();

    foreach ($result as $key => $rows) {
        $resultado[] = $rows['DescricaoClasse'];
    }
    return $resultado;
}

Controller:

public function getClasse() {
    $this->load->model('Decisao_monocratica_model');
    return $this->Decisao_monocratica_model->getClasse();
}

View

<select id="ClasseProcesso" class="input-xlarge" name="classeProcesso">
    <option value="0">Todos os Tipos</option>
        <? foreach ($classeProcesso as $key => $classe) { ?>
            <option value="<? echo $classe ?>"><? echo $classe ?></option>
        <? } ?>
</select>

answered Feb 25, 2014 at 18:39

Daniel Lucena

113 bronze badges

Collectives™ on Stack Overflow

create a select dropdown from database in codeigniter [closed]

I am new with codeigniter.I want to make a select dorpdown that gets its value and title from database.I tried some codes but it did not work.There are my codes:

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

I am new with codeigniter.I want to make a select dorpdown that gets its value and title from database.I tried some codes but it did not work.There are my codes:

3 Answers 3

Comments

Comments

Comments

Linked

Related