Home  >  Article  >  Backend Development  >  PHP creates a unique number class based on an auto-incremented ID

PHP creates a unique number class based on an auto-incremented ID

黄舟
黄舟Original
2017-02-17 09:46:231338browse


During the development process, our data tables generally use auto-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.

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

<?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 = &#39;&#39;;        while($pision){            
        $tmp = fmod($pision, 26); // 只使用26个大写字母
            $tmp = chr($tmp + 65);      // 转为字母
            $word .= $tmp;            $pision = floor($pision/26);
        }        if($word==&#39;&#39;){            $word = chr(65);
        }        // 生成数字部分
        $mod = $id % $base;        $digital = str_pad($mod, $num_length, 0, STR_PAD_LEFT);        
        $code = sprintf(&#39;%s-%s-%s&#39;, $prefix, $word, $digital);        return $code;

    }

} // class end?>

demo.php

<?phprequire &#39;IDCode.class.php&#39;;$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.&#39; = &#39;.IDCode::create($test_id, 3, &#39;F&#39;).&#39;<br>&#39;;
}?>

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



Source code download address: Click to view

During the development process, our data tables generally use auto-incrementing numbers as the primary key of id. The id is a numeric type and 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.

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

<?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 = &#39;&#39;;        while($pision){            
        $tmp = fmod($pision, 26); // 只使用26个大写字母
            $tmp = chr($tmp + 65);      // 转为字母
            $word .= $tmp;            $pision = floor($pision/26);
        }        if($word==&#39;&#39;){            $word = chr(65);
        }        // 生成数字部分
        $mod = $id % $base;        $digital = str_pad($mod, $num_length, 0, STR_PAD_LEFT);        
        $code = sprintf(&#39;%s-%s-%s&#39;, $prefix, $word, $digital);        return $code;

    }

} // class end?>

demo.php

<?phprequire &#39;IDCode.class.php&#39;;$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.&#39; = &#39;.IDCode::create($test_id, 3, &#39;F&#39;).&#39;<br>&#39;;
}?>

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


The above is the content of PHP creating a unique number class based on the self-increasing ID. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn