Re: Random Unique ID

2007. 03. 23, péntek keltezéssel 08.13-kor Robert Cummings ezt írta: > On Fri, 2007-03-23 at 09:15 +0100, Németh Zoltán wrote: > > > // method 2 > > $time = microtime(TRUE); > > for ($i = 1; $i <= 5000; $i++) { > > $done = FALSE; > > while (!$done) { > > $id = md5((microtime(TRUE) * (rand(1,1000) / 100))); > > $sql = "INSERT INTO idtest (id,cnt) VALUES ('$id', $i)"; > > $result = mysql_query($sql); > > if ($result) { $done = TRUE; } > > } > > } > > $end = microtime(TRUE) - $time; > > echo "method 2 time: " . $end . "<br>"; > > One of the problems with the above style is that if the query fails for > some other reason (typo, no permissions, database temporarily > unavailable, etc) the code will run indefinitely (or until it gets > killed for too much time). That's a very dirty way to manage failed > inserts due to dupes. yes, of course. that's good only for this small test, not for real life use ;) for real use one should check mysql_errno end take action based on that greets Zoltán Németh > > Cheers, > Rob.