CodeIgniter get values from database in select box?

Question

I am new to CodeIgniter, so I dont know how to do this. I want to display values dynamically in a select box and after selecting the value it displays a textbox and then it then pass the textbox value and and the option( the names which is displayed on dropdown list) id to controller,so briefly what I want to do:

dynamically show the values in select box
after selecting the value dynamically create textBox
passing the selected or track the 'id' of dropdown list and textbox value to controller

here is my Model

function getAllCategories(){
    $this->db->select('cat_name');
    $q = $this->db->get('category');

    if ($q->num_rows() > 0){
        foreach($q->result() as $row) {
            $data[] = $row;
        }
        return $data;
    }

}

my controller

function showCategoryNames(){
    $data = array();
    $this->load->model('categoryModel');
    $query = $this->categoryModel->getAllCategories();
    if ($query){
        $data['records'] = $query;  
    }    
    $this->load->view('itemsView',$data);   
 }

View: this is showing the simple list

<?php if(isset($records)) : foreach($records as $row) :?>
    <h2><?php echo $row->cat_name; ?></h2>
    <?php endforeach;?>
    <?php else :
endif;?>

moveax · Accepted Answer · 2013-01-11 13:34:43Z

3

how about

<select name="mySelect">
<?php foreach($records as $row) { ?>
<option value="<?=$row->id?>"><?=$row->cat_name?></option>
<?php } ?>
</select>

in your view?

Here is a tutorial about working with jQuery, Ajax and Codeigniter:

http://www.jotorres.com/2012/01/using-jquery-and-ajax-with-codeigniter/

edited Jan 11, 2013 at 13:34

answered Jan 11, 2013 at 13:08

moveax

1337 bronze badges

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

2 Comments

mynameisjohn Over a year ago

yeah thanks it works .. now i want to implement the onchange function and without refreshing it creates a text box by using ajax or jquery

moveax Over a year ago

than you've to build a controller function which returns the data you need, you can use jQuery.Post() to do your request and build the textbox dynamicly. I've added a tutorial on my answer. But i think you should use a view and not inline HTML like in the Tutorial.

Raul Rene · Accepted Answer · 2014-01-07 13:59:17Z

0

after loading form helper class, your view should be for creating dropdown

form_dropdown('size', $data_array, 'large');

edited Jan 7, 2014 at 13:59

Raul Rene

10.3k9 gold badges56 silver badges79 bronze badges

answered Jan 7, 2014 at 13:39

Khandad Niazi

2,4163 gold badges27 silver badges22 bronze badges

Comments

cakan · Accepted Answer · 2018-10-04 08:19:56Z

0

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Trip_model extends CI_Model{

    var $table = 'tbl_trip';

    public function __construct(){
        parent::__construct();
        $this->load->database();
    }

    public function get_all_trips(){
        $this->db->from('tbl_trip');
        $query=$this->db->get();
        return $query->result();
    }

    public function get_by_id($id){
        $this->db->from($this->table);
        $this->db->where('trip_id',$id);
        $query = $this->db->get();
        return $query->row();
    }

    public function trip_add($data){
        $this->db->insert($this->table, $data);
        return $this->db->insert_id();
    }

    public function trip_update($where, $data){
        $this->db->update($this->table, $data, $where);
        return $this->db->affected_rows();
    }

    public function delete_by_id($id){
        $this->db->where('trip_id', $id);
        $this->db->delete($this->table);
    }
}

edited Oct 4, 2018 at 8:19

cakan

2,1175 gold badges33 silver badges45 bronze badges

answered Oct 4, 2018 at 7:11

Harsh Lad

12 bronze badges

1 Comment

Nico Haase Over a year ago

Just like at the other place where you've posted such code without explanation: how does this solve the original question? How does it populate data for a select field? Why do you need a delete_by_id method for this?

Collectives™ on Stack Overflow

CodeIgniter get values from database in select box?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related