Reputation: 11
$('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.
Upvotes: 1
Views: 179
Reputation: 1995
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();
}
Upvotes: -1