如何从00001生成唯一的随机数并在Codeigniter MySQL中维护序列号

Question

I know it's a quite common question. But I have got no solution for CodeIgniter.

I use below MySQL code. I want to know how can I use this code directly in Codeigniter view. It shows error.

SELECT FLOOR(RAND() * 99999) AS random_num
FROM glf_invoice 
WHERE "random_num" NOT IN (SELECT patient_reg FROM glf_invoice)
LIMIT 1

This code shows a number of 5 digits in phpmyadmin SQL.

And how can I maintain serial from 00001 to 00002...

Answer 1

On the ID column, set it to "Auto Increment". It may be noted down as "A_I".