如何从数据库中获取自动递增的id值

Question

I am trying to insert the value in the database in codeigniter framework but getting this error.

A Database Error Occurred

Error Number: 1054

Unknown column '0' in 'field list'

INSERT INTO `admin_table` (`0`) VALUES ('')

Filename: C:\xampp\htdocs\CI\system\database\DB_driver.php

Line Number: 331

Admin_table

*ID int(10) auto-increment primary key

*Name:varchar(255)

*Email:varchar(255)

*Designation:varchar(255)

*Contact:int(10)

View:

<form>
<input type="hidden" name="ID">
<legend>Add Data</legend>
    <label>Name</label>
      <?php echo form_input(['name'=> 'Name','placeholder'=>'Name',]);?>
    <label>Email</label>
      <?php echo form_input(['name'=> 'Email','placeholder'=>'Email']);?>
    <label>Designation</label>
      <?php echo form_input(['name'=> 'Designation','placeholder'=>'Designation']);?>
    <label>Contact</label>
      <?php echo form_input(['name'=> 'Contact','placeholder'=>'Contact']);?>
    <?php echo form_reset(['name'=>'Reset','value'=>'Reset']); ?>
    <?php echo form_submit(['name'=>'submit','value'=>'Add']) ?>
</form>

Controller:

      $this->load->library('form_validation');
      $post= $this->input->post();
      $this->load->model('model');
      if( $this->model->add_data($post)){
          //insert succesfully
      }
      else{
         //insert failed
      }

Model:

    $this->db->insert('admin_table',$array);
    $last_id=$this->db->insert_id();
    return $last_id;

And when i use print_r($post) in controller,it's not printing the values of the field but show the value in url.Where i am wrong please tell me.

Thanks in advance.

Answer 1

Don't pass all post Request in model,make insert data array.

Check query by print last query.

$this->db->last_query();