[Resolved] Generate 18 Char unique ID????

[ehask]

Hey all,

I have to generate a max 18 char unique id to send with orders.  I was using

$stamp = strtotime ("now");
   $orderid = "$stamp$ipaddy"; 
   $orderid = str_replace(".", "", "$orderid");

But it can genrate more than 18 characters. This site will be processing alot so I am afraid of using last_insert_id

as there is a chance more than 2 people could be processing a transaction at the same time.

any ideas

thx

[tsinka]

Hi,

AFAIK (according to the manual) the LAST_INSERT_ID() query returns the last id on a per connection basis. So even if two different users execute an insert query at the same time you should always get the correct id. I didn't have any problems with this so far but I didn't test that in detail.

Thomas

[Frederick]

if you are using mysql, then set your id field to:
int(18) UNASSIGNED-ZEROFILL

This will place zeros before your id and the users will get your char count.

[intenz]

Try this...

<?php
echo substr( md5( uniqid() ), 0, 18 );
?>

[ehask]

I love this place!!

Thanks for all the help

Eric