Create a unique number class through auto-incrementing id in php

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.

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

<?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 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 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

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!