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 number O-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.
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
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
IDCode.class.php
<?php/** * php 根据自增id创建唯一编号类 * Date: 2016-11-27 * Author: fdipzone * Ver: 1.0 * * Func * Public create 创建编号 */class IDCode{ // class start /** * 创建编号 * @param Int $id 自增id * @param Int $num_length 数字最大位数 * @param String $prefix 前缀 * @return String */ public static function create($id, $num_length, $prefix){ // 基数 $base = pow(10, $num_length); // 生成字母部分 $pision = (int)($id/$base); $word = ''; while($pision){ $tmp = fmod($pision, 26); // 只使用26个大写字母 $tmp = chr($tmp + 65); // 转为字母 $word .= $tmp; $pision = floor($pision/26); } if($word==''){ $word = chr(65); } // 生成数字部分 $mod = $id % $base; $digital = str_pad($mod, $num_length, 0, STR_PAD_LEFT); $code = sprintf('%s-%s-%s', $prefix, $word, $digital); return $code; } } // class end?>
demo.php
<?phprequire 'IDCode.class.php';$test_ids = array(1,9,10,99,100,999,1000,1009,2099,3999,9999,14999,99999);foreach($test_ids as $test_id){ echo $test_id.' = '.IDCode::create($test_id, 3, 'F').'<br>'; }?>
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
Source code download address: Click to view
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 number O-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.
Use auto-increment id to ensure uniqueness
You can use the remainder of the number to find the corresponding letter to create a shorter number
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
IDCode.class.php
<?php/** * php 根据自增id创建唯一编号类 * Date: 2016-11-27 * Author: fdipzone * Ver: 1.0 * * Func * Public create 创建编号 */class IDCode{ // class start /** * 创建编号 * @param Int $id 自增id * @param Int $num_length 数字最大位数 * @param String $prefix 前缀 * @return String */ public static function create($id, $num_length, $prefix){ // 基数 $base = pow(10, $num_length); // 生成字母部分 $pision = (int)($id/$base); $word = ''; while($pision){ $tmp = fmod($pision, 26); // 只使用26个大写字母 $tmp = chr($tmp + 65); // 转为字母 $word .= $tmp; $pision = floor($pision/26); } if($word==''){ $word = chr(65); } // 生成数字部分 $mod = $id % $base; $digital = str_pad($mod, $num_length, 0, STR_PAD_LEFT); $code = sprintf('%s-%s-%s', $prefix, $word, $digital); return $code; } } // class end?>
demo.php
<?phprequire 'IDCode.class.php';$test_ids = array(1,9,10,99,100,999,1000,1009,2099,3999,9999,14999,99999);foreach($test_ids as $test_id){ echo $test_id.' = '.IDCode::create($test_id, 3, 'F').'<br>'; }?>
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
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!