CODEWITHSUNDEEP
mysqlcodeigniter
Anu
Anu

Reputation: 630

Codeigniter:How to get the last inserted id?

Hi I am using codeigniter.I need to get the last inserted id and increment it and use it in my view page, My controller code:

public function add_tickets()
     {


        $status = $this->input->post("status_button");
        $emp_array = $this->input->post("employee");
        $start_array = $this->input->post("start_time");
        $pid_array = $this->input->post("pid");
        $total_array = $this->input->post("total");
        if($status == "leave_open")
        {
            $button_status="open";
        }
        else
        {
            $button_status="";
        }
       $insert_id = $this->billing_model->store_bill($data_to_store);
      /*Here I am tring to get the last inserted id*/
    for ($i = 0; $i < count($pid_array); $i++) {
        if(isset($pid_array[$i])&& $pid_array[$i]!=""){
        $data_to_store = array(
        'id' => $insert_id +1,
        'employee' => $emp_array[$i],
         'start_time' => $start_array[$i],
         'pid' => $pid_array[$i],

         'total' => $total_array[$i],
         'status' => $button_status,
         );

        $this->billing_model->store_bill($data_to_store);
       }
    }
    $data['ticket_new_id'] = $data_to_store['id'];
    $data['bill']=$this->billing_model->get_bill();
        $data['main_content'] = 'admin/billing/list';
        $this->load->view('includes/template', $data);  

     }

This is my controller function where I insert my bill. Here is my model function,

function store_bill($data)
    {
        $insert = $this->db->insert('bill', $data);
         $insert_id = $this->db->insert_id();
        return $insert_id;

    }

Here I am using $this->db->insert_id() to get the last inserted id. I am getting a error like this,

You must use the "set" method to update an entry.

Filename: C:\xampp\htdocs\elfanto\elfanto_billing\system\database\DB_active_rec.php

Line Number: 1174

Can someone help me? Thanks in advance

Upvotes: 1

Views: 3483

Answers (2)

Ricky
Ricky

Reputation: 568

I think this is your solution:

<?php 

public function add_tickets()
     {


        $status = $this->input->post("status_button");
        $emp_array = $this->input->post("employee");
        $start_array = $this->input->post("start_time");
        $pid_array = $this->input->post("pid");
        $total_array = $this->input->post("total");
        if($status == "leave_open")
        {
            $button_status="open";
        }
        else
        {
            $button_status="";
        }

        /*beore inserting first get the last ID of the table*/

            $this->db->select('*');
            $this->db->from('bill');
            $this->db->order_by('id','desc');
            $result = $this->db->get()->result();

            $last_id = $result[0]->id;//This is the last ID of the table


      /*now insert the data with incremented ID and send it to your view */




$data_to_store = array(
    'id' => $insert_id +1,
    'employee' => $emp_array,
     'start_time' => $start_array,
     'pid' => $pid_array,

     'total' => $total_array,
     'status' => $button_status,
     );


    $this->billing_model->store_bill($data_to_store);

 $insert_id =  $last_id + 1;//this will be your last inserted ID
$data['ticket_new_id'] = $insert_id ;
$data['bill']=$this->billing_model->get_bill();
    $data['main_content'] = 'admin/billing/list';
    $this->load->view('includes/template', $data);  

 }

For more reference how to get last ID using codeigniter check this

Upvotes: 2

Mitul
Mitul

Reputation: 3427

I have check your code not initialize the variable

    $status = $this->input->post("status_button");
    $emp_array = $this->input->post("employee");
    $start_array = $this->input->post("start_time");
    $pid_array = $this->input->post("pid");
    $total_array = $this->input->post("total");
    if($status == "leave_open")
    {
        $button_status="open";
    }
    else
    {
        $button_status="";
    }
    // $data_to_store is not initialized and you are trying to store the value that's why it give you error
   $insert_id = $this->billing_model->store_bill($data_to_store);

Upvotes: 0

Related Questions