How to Get Data Dropdown From Static Dropdown Codeigniter

Question

How to Get Data by id or other value From Static Dropdown? This My View :

        <select name="status" id="status" class="form-control">
            <option selected="selected" value="1">ACTIVE</option>
            <option value="2">INACTIVE</option>
        </select>

        <!--- GET DATA FROM DB WHERE STATUS DROPDOWN --> 
        <select name="result" id="result">
          <option selected="selected" value="">ALL</option>
        </select>

My Model :

function get($status){
    $query = $this->db->get_where('people', array('status' => $status));
    return $query;
}

My Controller :

function getresult(){
    $status= $this->input->post('status',TRUE);
    $data = $this->people_model->get($status)->result();
    echo json_encode($data);
}

and My Ajax :

I tried This but no Working Please Help

sauhardnc · Accepted Answer · 2020-05-02 15:32:44Z

1

I think you should get the value of id instead of status in your controller function because that's what you're sending via ajax-

function getresult(){
    $status= $this->input->post('id',TRUE);
    $data = $this->people_model->get($status)->result();
    echo json_encode($data);
}

See if this works for you, everything else seems fine to me.

answered May 2, 2020 at 15:32

sauhardnc

1,9612 gold badges8 silver badges16 bronze badges

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

3 Comments

sauhardnc Over a year ago

That's weird. Everything else seems fine to me, I even made a demo and it's working for me. The only thing I can say at this point is to check the path(url) of the controller function getresult() and name of the model people_model, also make sure that you've loaded people_model before calling it. See if it helps.

R.Drum Over a year ago

ops, my bad i got mistake in writing code.. Thank you very much sir.. You Save My Day

sauhardnc Over a year ago

Happy to help. :)

Collectives™ on Stack Overflow

How to Get Data Dropdown From Static Dropdown Codeigniter

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related