What alternative method can be used to ensure uniqueness of generated numbers before database entry in PHP?

To ensure uniqueness of generated numbers before database entry in PHP, one alternative method is to query the database to check if the generated number already exists. If it does, generate a new number until a unique one is found. This way, you can guarantee that each number being inserted into the database is unique. 

// Generate a random number
$randomNumber = mt_rand(1000, 9999);

// Check if the number already exists in the database
$query = "SELECT COUNT(*) FROM table_name WHERE column_name = $randomNumber";
$result = mysqli_query($connection, $query);
$count = mysqli_fetch_row($result)[0];

// Generate a new number if the current one already exists
while ($count > 0) {
    $randomNumber = mt_rand(1000, 9999);
    $query = "SELECT COUNT(*) FROM table_name WHERE column_name = $randomNumber";
    $result = mysqli_query($connection, $query);
    $count = mysqli_fetch_row($result)[0];
}

// Insert the unique number into the database
$insertQuery = "INSERT INTO table_name (column_name) VALUES ($randomNumber)";
mysqli_query($connection, $insertQuery);

Keywords

UUID uniqid hash collision database entry

Related Questions