Re: [PHP] Creating alphanumeric id for a table

[Lupus Michaelis]

aveev wrote:
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;
    }

  You can create a stored procedure or a trigger on inserting that 
implement your id logic.

--
Mickaël Wolff aka Lupus Michaelis
http://lupusmic.org

Seeking for a position <http://lupusmic.org/pro/>

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