Help Generating 6 Digit Unique Numeric Code!

[iPixel]

Below is my code... I'm new to OOP so forgive me if it's poorly designed. What i'm trying to do is make sure that asset_key never get's duplicated. So when time comes to insert a new record, i can rest assures that asset_key will not duplicate.

 

For some reason $random_number never get's back a value;

 

<?php
class Randomize
{
	function createRN()
		{
			$num = rand(100000,999999);

			$sql = "SELECT * FROM mer_asset_header WHERE asset_key = '$num'";
			$go = oci_parse($conn, $sql);
			oci_execute($go);
			$count = oci_num_rows($go);
			if($count = 1)
				$repeat = Randomize::createRN();
			else
				return $num;
		}
}

$random_number = new Randomize;
$random_number->createRN();
?>

 

I should also mention, that if the query finds that asset_key, it should also run createRN() again untill it gets a unique one.

 

Thanks for the help in advance!

[AbraCadaver]

if($count = 1)

 

Maybe:

if($count == 1)

 

Also, you might consider mt_rand().

[iPixel]

if($count = 1)

 

Maybe:

if($count == 1)

 

Also, you might consider mt_rand().

 

Unfortunately no .

[Zane]

$return = $num;
        if($count >= 1)
	$return = Randomize::createRN();
else
	return $return;

 

The main thing wrong with your code is your use of $repeat.  It is never declared beforehand AND you never use it when you do declare it.

[AbraCadaver]

Sorry, that was the first problem I saw, but there is more:

 

if($count == 1) {
   $num = Randomize::createRN();
}
return $num;

[iPixel]

I did this but still nothing... i dont understand why am i using $num = Randomize::createRN();

 

<?php
class Randomize
{
	function createRN()
		{
			$num = rand(100000,999999);

			$sql = "SELECT * FROM mer_asset_header WHERE asset_key = '$num'";
			$go = oci_parse($conn, $sql);
			oci_execute($go);
			$count = oci_num_rows($go);

			if($count == 1)
				{
					$num = Randomize::createRN();
				}
			return $num;
		}
}

$random_number = new Randomize;
$random_number->createRN();
?>

 

[Zane]

i dont understand why am i using $num = Randomize::createRN();

So the function runs recursively (again and again) until $count != 1 ... or in the case of my example... until count is less than 1

[iPixel]

Nevermind, i got it working... i just made a noobie mistake and was calling echo $random_number later on in the code after $random_number->createRN();

 

so i just did $random = $random_number->createRN() and echo $random whenever neede.

 

Thanks !!!