在CodeIgniter中的URL中获取Last Insert_ID

Question

我在应用程序中有一个要求。供应商单击链接我将页面重定向到登录页面..

所以我想做的是我想发送带有最后插入ID的电子邮件链接。

这是我的控制器：

public function requirement()

{

  $data["msg"]="";
  $this->load->model('RequirementModel');
  $data['user']=$this->RequirementModel->getusers();
  $data['rolename']=$this->RequirementModel->getrolename();

if($this->input->post())
 {
   $this->RequirementModel->add_requirement($this->input->post());
   $all_users = $this->input->post('user_id');
   foreach($all_users as $key)
      {
         $get_email = $this->RequirementModel->get_user_email_by_id($key);
         $req_id = $this->input->post('req_id');
         $role_name = $this->input->post('role_name');
         $vacancies = $this->input->post('vacancies');
         $experience = $this->input->post('experience');
         $jd = $this->input->post('jd');
         $hiring_contact_name = $this->input->post('hiring_contact_name');
         $hiring_contact_number = $this->input->post('hiring_contact_number');
         $config = Array(
          'protocol' => 'smtp',
          'smtp_host' => 'ssl://md-in-42.webhostbox.net',
          'smtp_port' => 465,
          'smtp_user' => '[e-mail]',
          'smtp_pass' => 'test3'
      );
         $this->load->library('email',$config);
         $this->email->set_mailtype("html");
         $this->email->from('[e-mail]', 'bharathi');
         $this->email->to($get_email); 
         $this->email->subject('this is our requirements pls go through it');
         $link = 'Click on this link - <a href="http://localhost/job_portal/index.php/Login/signin>Click Here</a>';
         $this->email->message($link);
         print_r($get_email);
         if($this->email->send())
         {
              echo "email sent";
          }
          else
          {
              echo "email failed";
          }
}

}

$ this-> load-> view（'要求/需求'，$ data）;

}

任何人都可以帮我吗。预先感谢..

Answer 1

您需要的是数据库助手函数insert_id（），它返回最后插入的ID：https：//www.codeigniter.com/userguide3/database/database/helpers.helpers.html？亮点= insert_id

具有您的add_requirement函数。

return $this->db->insert_id();

然后在调用函数时保存该值：

$insert_id = $this->RequirementModel->add_requirement($this->input->post());