Welcome to WebmasterWorld Guest from 54.144.107.83

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

generating unique number

unique number, php, no same value in database

     
6:21 am on Feb 15, 2008 (gmt 0)

New User

5+ Year Member

joined:Jan 23, 2008
posts: 18
votes: 0


hello,

does anyone know on how to generate a unique number like for example an employee id or student id. that id is unique right, and it doesnt have the same value in the database. please teach me how...tnx

6:26 am on Feb 15, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 9, 2005
posts:817
votes: 0


$c = uniqid (rand (),true);
echo $c;
7:47 am on Feb 15, 2008 (gmt 0)

New User

5+ Year Member

joined:Jan 23, 2008
posts: 18
votes: 0


tnx, but the output is too long. i want to limit the number in 6 digits.

how to do that? please help..

10:28 am on Feb 15, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


$randNum = uniqid(rand(100000,999999),true);
10:30 am on Feb 15, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Apr 20, 2006
posts:109
votes: 0


<?php

$randNum = rand(100000,999999);
echo $randNum;

?>

2:10 pm on Feb 15, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Dec 9, 2003
posts:3416
votes: 0


If you set an auto incrementing field in your database, you can just do an insert (with that value set to null) then use mysql_insert_id() [php.net] to find out what number was assigned by MySQL.