Create a unique number class through auto-incrementing id in php-PHP Tutorial-php.cn

During the development process, our data tables generally use self-increasing numbers as the primary key of id, and id is a numeric type, which is not easy to understand. After we convert the ID into a number according to a certain format, it is easy to know what the content represents based on the number.

For example, the order table id=20160111197681234. We don’t know that this id is the id of the order table just by looking at the id. However, if it is converted to the numberO-20160111197681234, it is very complicated. It is easy to see that it is a record of the order table, and then it can be searched in the order table based on the id.

Rules for number creation

1. Unique
Use auto-increment id to ensure uniqueness

2.Short as possible
You can use the remainder of the number to find the corresponding letter to create a shorter number

Algorithm principle

1. Add a custom prefix for identification

2. The format is composed of prefix + letters + numbers. Only N digits are reserved for numbers. If the number exceeds the number, use the remainder method of numbers and use letters corresponding to

. For example:
id=1
Prefix=F
Keep 3 digits in the number
The created number is:F-A-001

##The code is as follows:

IDCode.class.php

Copy after login

demo.php

'; }?>

Copy after login

Output:

1 = F-A-0019 = F-A-00910 = F-A-01099 = F-A-099100 = F-A-100999 = F-A-9991000 = F-B-0001009 = F-B-0092099 = F-C-0993999 = F-D-9999999 = F-J-99914999 = F-O-99999999 = F-VD-999

Copy after login

Source code download address: Click to view

During the development process, our data tables generally use self-increasing numbers as the id primary key, and the id is Numerical type, not easy to understand. After we convert the ID into a number according to a certain format, it is easy to know what the content represents based on the number.

For example, the order table id=

20160111197681234. We don’t know that this id is the id of the order table just by looking at the id. However, if it is converted to the numberO-20160111197681234, it is very complicated. It is easy to see that it is a record of the order table, and then it can be searched in the order table based on the id.

Rules for number creation

1. Unique

Use auto-increment id to ensure uniqueness

2.Short as possible

You can use the remainder of the number to find the corresponding letter to create a shorter number

Algorithm principle

1. Add a custom prefix for identification

2. The format is composed of prefix + letters + numbers. Only N digits are reserved for numbers. If there are more than 10 digits, use letters to find the remainder

For example:

id=1
Prefix= F
Keep 3 digits for the number
Then the created number is:
F-A-001

The code is as follows:

IDCode.class.php

Copy after login

demo.php

'; }?>

Copy after login

Output:

1 = F-A-0019 = F-A-00910 = F-A-01099 = F-A-099100 = F-A-100999 = F-A-9991000 = F-B-0001009 = F-B-0092099 = F-C-0993999 = F-D-9999999 = F-J-99914999 = F-O-99999999 = F-VD-999

Copy after login

This article explains how to create a unique number class through the auto-increment id in php. For more related content, please pay attention to the php Chinese website.

Related recommendations:

Explanation on php optimized page output, compatible with examples of search engine robot access

Through php Call ffmpeg to obtain video information

Use mysql to determine whether the point is within the specified polygon area

The above is the detailed content of Create a unique number class through auto-incrementing id in php. For more information, please follow other related articles on the PHP Chinese website!