php - 使用 Codeigniter 中的最后插入 ID 生成唯一的代码？

Question

我需要使用最后一个插入ID以规定的格式创建一个drcode，以前我使用 cor php 来获取代码，但现在在 codeigniter 中无法获取前一个代码。我怎样才能做到这一点？我正在提供我的 Controller 和模型

Controller

public function newdoctor_post() {
            $employee_id = $this->post('EMPLOYEE_ID');
            $doctorname = $this->post('DOCTOR_NAME');
            $mobilenumber = $this->post('DRMOBILE');
            $users_data = $this->Rest_user_model->doctor_exists($mobilenumber);
            if ($users_data == 1) {
                $message = ['status' => 2,
                // 'result' => array(),
                'message' => 'Doctor already registered'];
            } else {
                $speciality = $this->post('SPECIALITY');
                $longitude = $this->post('LONGITUDE');
                $latitude = $this->post('LATITUDE');
                $drcode = $this->post('DRCODE');
                $createdon = date('Y-m-d H:i:s');
                $insert_array = array('EMPLOYEE_ID' => $employee_id, 'DOCTOR_NAME' => $doctorname, 'DRMOBILE' => $mobilenumber, 'SPECIALITY' => $speciality, 'LONGITUDE' => $longitude, 'LATITUDE' => $latitude, 'CREATEDON' => $createdon);
                $users_data = $this->Rest_user_model->doctorregistration($insert_array);
                $message = ['status' => 1, // 'result' => $users_data,
                'message' => 'Doctor Registered Successfully'];
            }
            $this->set_response($message, REST_Controller::HTTP_OK);
        }

型号

public function doctorregistration($data) {
        if (!empty($data)) {
            $this->db->insert('DOCTORDETAILS', $data);
            return $this->db->insert_id();
        }
        return 0;
    }

代码生成

$sql1="SELECT DRCODE FROM DOCTORDETAILS  ORDER BY DRCODEDESC LIMIT 1";
    $query=mysql_query($sql1);
    if (!$sql1) { // add this check.
    die('Invalid query: ' . mysql_error());
    }
    $output_array2=array();
    while($row=mysql_fetch_assoc($query))
    {
    $ids=$row['DRCODE'];

    }
    // echo $ids;
    if($ids){
        $su=1;
        $num =$num = 'DR' . str_pad($su + substr($ids, 3), 6, '0', STR_PAD_LEFT);;
        $unique=$num;
    }else{
        $unique='DR000001';     
    }

Answer 1

试试这个 - 将下面的代码替换为您的代码生成代码。

$sql1="SELECT DRCODE FROM DOCTORDETAILS  ORDER BY DRCODEDESC LIMIT 1";
    $query=$this->db->query($sql1);
    if (!$sql1) { // add this check.
        die('Invalid query');
    }
    $output_array2=array();
    foreach($query->result_array() as $row)
    {
        $ids=$row['DRCODE'];
    }
    // echo $ids;
    if($ids){
        $su=1;
        $num =$num = 'DR' . str_pad($su + substr($ids, 3), 6, '0', STR_PAD_LEFT);;
        $unique=$num;
    }else{
        $unique='DR000001';     
    }