Generate 11 digit serial numbers in codeigniter

Question

Here is my model function for generate serial numbers

public function getmax($field_name,$table_name){

        $this->db->select_max($field_name);
        $res1 = $this->db->get($table_name);
        if ($res1->num_rows() > 0) {
            $res2 = $res1->result_array();                  
        }
        $max = $res2[0][$field_name];
        if($max == NULL) return 1; else return $max+1;
    }

Here is my controller Function

$CardNo = $this->general_model->getmax('card_number','digicardusers');

I want to set serial numbers starting from 00000000001.How to change the code to get 11 digit serial numbers.Any one please help

we can do it through mysql if you are ok i can give you solution from mysql side — suresh, Aug 03 '18 at 07:32
Looks like possible duplicate of your question, https://stackoverflow.com/questions/4527237/how-to-generate-5-digit-alphanumeric-unique-id-using-codeigniter — Vinod Selvin, Aug 03 '18 at 08:16

score 0 · Accepted Answer · answered Aug 03 '18 at 07:34

0

Presuming your just looking for the 0'padding, use sprintf()

<?php
for ($i = 1; $i < 25; $i++) {
    echo sprintf("%'.011d", $i).PHP_EOL;
}

https://3v4l.org/UanaJ

00000000001
00000000002
00000000003
00000000004
00000000005
00000000006
00000000007
00000000008
00000000009
00000000010
00000000011
...

answered Aug 03 '18 at 07:34

Lawrence Cherone

46,049
7
62
106

Where can i use it – Aug 03 '18 at 07:36
After its returned from the function, `$CardNo = sprintf("%'.011d", $CardNo);` – Lawrence Cherone Aug 03 '18 at 07:37
Note: you should only use it for display, weird things happen if you try to work on the value or it gets casted: https://3v4l.org/CXdD9 – Lawrence Cherone Aug 03 '18 at 07:39

score 0 · Answer 2 · answered Aug 03 '18 at 12:28

0

you can use this function just pass param $digit

function randomXDigit($digits = 11) {
    return str_pad(rand(0, pow(10, $digits)-1), $digits, '0', STR_PAD_LEFT);
}

answered Aug 03 '18 at 12:28

manish

423
3
9

Generate 11 digit serial numbers in codeigniter

2 Answers2