Generate Unique Codes

[lanredoyes]

Hello,

 

I am working on a personal project which is to generate a set of unique codes and store them in a database. The concept of the project is for me to be able to determine the numbers of codes I want to generate and insert each of them into the database. I have been able to come up with something with the help of a tutorial which is working but not inputting into database and it allows one generation at a time. Please see my code below

 

$username = "root";
$password = "password";
$hostname = "localhost";
$database = "gencode";
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
$selected = mysql_select_db($database,$dbhandle)
or die("Could not select $database");


$unique_ref_length = 11;


$unique_ref_found = false;


$possible_chars = "23456789ABCDFGHJKLMNPQRSTWXYZ";



while (!$unique_ref_found) {



$unique_ref = "";


$i = 0;


while ($i < $unique_ref_length) {


 $char = substr($possible_chars, mt_rand(0, strlen($possible_chars)-1), 1);

 $unique_ref .= $char;

 $i++;

}


$query = "SELECT `order_ref_no` FROM `orders`
       WHERE `order_ref_no`='".$unique_ref."'";
$result = mysql_query($query) or die(mysql_error().' '.$query);
if (mysql_num_rows($result)==0) {


 $unique_ref_found = true;

}


}


echo 'Our unique reference number is: '.$unique_ref;

 

Your assistance will be greatly appreciated.

[Jessica]

http://php.net/manual/en/function.uniqid.php