How get 2 or more input values when dropdown changes by ajax jQuery in codeigniter

174 views Asked by At
$('document').ready(function () {
    $('.js-example-basic-single').select2();

    $('#empName').on('change', function() {
        var quan = $(this).val();
    
        $.ajax({
            url: '<?php echo base_url("index.php/emp_salary/ajaxReq"); ?>',
            type: 'post',
            data: {quan: quan}, 
        })
        .done(function(data) { //<---- we use .done here  
            $('#empId').val(data);
        })
    });

    $('#empName').on('change', function() {
        var dept = $(this).val();
    
        $.ajax({
            url: '<?php echo base_url("index.php/emp_salary/ajaxDept"); ?>',
            type: 'post',
            data: {dept: dept},
        })
        .done(function(data) {
            $('#department').val(data);
        })
    });
});

controller part

public function ajaxReq() {
  $quan = $this->input->post( 'quan' );
  $value = $this->salary_model->getVal($quan);
  echo $value['empId'];
}

public function ajaxDept() {
    $dept = $this->input->post( 'dept' );
    $value = $this->salary_model->getDept($dept);
    echo $value['department'];
}

model part

public function getVal($quan){
    $this->db->select('*');
    $this->db->from('employee');
    $where = array('empId' => $quan );
    $this->db->where($where);
    $query = $this->db->get();
    return $query->row_array();
}

public function getDept($dept){
    $this->db->select('*');
    $this->db->from('employee');
    $where = array('department' => $dept );
    $this->db->where($where);
    $query = $this->db->get();
    return $query->row_array();
}

Error

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: controllers/Emp_salary.php

Line Number: 133

how I can solve this?

I expect that when the dropdown changes I get another input value automatically.

1

There are 1 answers

0
KUMAR On

According to Your Question , what i Understand is you want, when the Select dropdown changes get 2 or more input value automatically by jQuery ajax in Codeigniter.

HTML Part :-

<select name="test" id="test" >
<option value="user1">user1</option>
<option value="user2">user2</option>
<option value="user3">user3</option>
<option value="user4">user4</option>
<option value="user5">user5</option>
</select>
<input type="text" placeholder="Address" id="address"/>
<input type="text" placeholder="Name" id="name"/>
<input type="text" placeholder="Contact" id="contact"/>

JQuery / Ajax Part:-

<script type="text/javascript">
    $('#test').change(function(){
    var test=$(this).val();
    $.ajax({
        type: "GET",
            url: '<?php echo base_url("index.php/emp_salary/ajaxReq"); ?>',
            data: {test:test},
            success:function(data)
            {
            var result = $.parseJSON(data);
            $("#address").val(result.address);
            $("#name").val(result.name);
           $("#contact").val(result.contact);     
            }
         })
    }); 
    </script>

controller part:-

public function ajaxReq() {
  $test = $this->input->post('test');
  $value = $this->salary_model->getVal($test);
  echo json_encode($value);
 }

Model part :-

public function getVal($test){
    $this->db->select('*');
    $this->db->from('employee');
    $where = array('empId' => $test );
    $this->db->where($where);
    $query = $this->db->get();
    return $query->row_array();
}