• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Codeigniter with Ajax to load data to view.

#1
[eluser]afro[/eluser]
Hey guys, i would like your assistance in handling a problem with Ajax.
I have four fields in my view and i want when one of the field in filled, the other three field are load from the database
automatically using the Ajax, the page should refresh and load the three fields when the staffid field losses focus.

#2
[eluser]toopay[/eluser]
[quote author="afro" date="1303817822"]Hey guys, i would like your assistance in handling a problem with Ajax.
I have four fields in my view and i want when one of the field in filled, the other three field are load from the database
automatically using the Ajax, the page should refresh and load the three fields when the staffid field losses focus.[/quote]
:-S

#3
[eluser]afro[/eluser]
I have tried this but it is not working

Code:
$(document).ready(function() {
        
  staffid = prompt('Enter your Staff Id', $(this).find().html());
  if (staffid != null)
    {
function get_staff_data(staffid) {
  var p = {};
  p[staffid] = staffid
  $("input#staffid").load(index.php/user/load_staff_data,p,function(str){
});
}
}
            
            
});

My controller's method is here below

Code:
function load_staff_data()
    {    
$ID = $_POST[staffid];  

   $this->load->model('user_model');
   $results = $this->user_model->get_staff_data($ID);
  
   $this->load->view('leave',$results);
}

the model is as follows

Code:
public function get_staff_data($ID)
{
$this->db->select('StaffId,StaffName, Department, LeaveBalance');
$this->db->where('StaffId', $staffid);
$query = $this->db->get('staff');
   $row = $query->row();
$results[record][$row->StaffName][StaffName] = $row->StaffName;
$results[record][$row->Department][Department] = $row->Department;
$results[record][$row->LeaveBalance][LeaveBalance] = $row->LeaveBalance;

return $results;



}

can someone help me out from here


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.