Get 500 Internal Server Error in Codeigniter insert data

Question

i want to insert data using Ajax to databse. But I got 500 Internal Server Error. After I check I get Call to undefined method Hire_model::InserData(). Can anyone help me to correct my code. Any help is appreciated Thanks!

  $('#button-smt').click(function(){
    var form_data = $('#myform').serialize();
       $.ajax({
        url:"<?php echo base_url('Hire/submit_hire');?>",
        method:"POST",
        data:form_data,

        success:function(data){
      console.log(data);
            if (data.status) {
              alert('sukses!');

            }
          },
        error:function(){
            alert('error ... ');

            //console.log(data);
            $('#myModal').hide();
            $('.modal-fade').hide();
            $(".modal-backdrop").remove();
        }
    });
});

My Controller

public function submit_hire(){
$total = $this->input->post('total');
$workdate = $this->input->post('workdate');
$data = array(
  'NumberOfPlacement' => $total,
  'ExpectedWorkStartDate' => $workdate
  );
$res = $this->hire_model->InserData('dbo.RequisitionTable' , $data);
if ($res) {
  echo json_encode(array('status'=>true));
}else
echo json_encode(array('status'=>false));
}

My Model

public function InsertData($tabelName, $data){
$res = $this->db->insert($tabelName, $data);
return $res;
 }

enable error reporting and see what is the error. also check you have loaded model `hire_model` or not and may be issue is here `dbo.RequisitionTable` — Devsi Odedra, Sep 20 '19 at 07:22
see this https://stackoverflow.com/questions/845021/how-can-i-get-useful-error-messages-in-php — Devsi Odedra, Sep 20 '19 at 07:24
why the issue is in dbo.RequisitionTable ? I've load hire_model in constuct — kitcat, Sep 20 '19 at 07:36
**Try This** [Hope this link help to find your suggestion](https://stackoverflow.com/questions/17875706/how-to-create-codeigniter-batch-insert-array) — Praveen Gehlot, Sep 20 '19 at 13:15

score 0 · Answer 1 · answered Sep 20 '19 at 12:28

0

Problem is in method name: (spelling mistake) $res = $this->hire_model->InserData('dbo.RequisitionTable' , $data);

It should be $this->hire_model->InsertData('dbo.RequisitionTable' , $data);

answered Sep 20 '19 at 12:28

Reena

1

score 0 · Accepted Answer · answered Sep 23 '19 at 02:54

0

Finally I found the mistake. Its the naming of the method in model. I changed InserData to Insert_data and it works now

answered Sep 23 '19 at 02:54

kitcat

157
1
17

Get 500 Internal Server Error in Codeigniter insert data

2 Answers2