Re: Creating alphanumeric id for a table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



At 3:17 PM -0700 9/10/09, aveev wrote:
I want to create user generated id like this :
AAA0001
AAA0002
...
AAA0009
AAA0010

where the id consists of 3 alphanumeric characters and 4 numerical digits in
the beginning (for numerical digit, it can grow like this AAA10001). I try
to use php script to generate id like this, where I use the following
script.

<?
    function generate_id($num) {
        $start_dig = 4;
        $num_dig = strlen($num);
$id = $num;
        if($num_dig <= $start_dig) {
            $num_zero = $start_dig - $num_dig;
for($i=0;$i< $num_zero; $i++) {
                $id = '0' . $id;
            }
        }
        $id = 'AAA' . $id;
        return $id;
    }

    $app_id = generate_id(1);

?>

I assume that I can get increment value/sequence from db  (I used harcoded
increment value  in the code above (generate_id(1))),
but I don't know how I can get this incremental value from db.I use mysql
5.0.
Or has anyone had another solution to create this alphanumeric id  ?

Any help would be much appreciated
Thanks

aveev:

Why get an incremental value from the database? What information does that give you? Why do you want it? And what are you going to do with it?

When those questions are answered, then we can help with more informed advice.

Cheers,

tedd

--
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux