PHP Unique random string generator

Question

How to make a random string unique to the string in the column below?

<?php
$n=10;
function getName($n) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $randomString = '';

    for ($i = 0; $i < $n; $i++) {
        $index = rand(0, strlen($characters) - 1);
        $randomString .= $characters[$index];
    }

    return $randomString;
}

echo getName($n);
?>

Does this answer your question? PHP/MySQL - Best way to create unique random string? — user3783243
– user3783243, Commented Mar 6, 2022 at 12:16
Yes, But sometimes it will randomize the already existing string causing an error when saving. — Noso Sanas
– Noso Sanas, Commented Mar 6, 2022 at 12:28
You mean you randomize the random string? Not sure I know what you mean.. whats the error? — user3783243
– user3783243, Commented Mar 6, 2022 at 12:34
If I want to randomize one number from "1,2,3", But there is already a row with the value 2 in the "String" column, the random value must be either 1 or 3. — Noso Sanas
– Noso Sanas, Commented Mar 6, 2022 at 12:40

Khandaker Sajjat · Accepted Answer · 2022-03-06 12:07:19Z

0

<?php
    $n = 10;
    function getName($n) {
        $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
        $randomString = '';
        for ($i = 0; $i < $n; $i++) {
            $index = rand(0, strlen($characters) - 1);
            $randomString .= $characters[$index];
        }
        return $randomString;
    }
    function getUniqueString($length, $dbConnection){
        $string = getName($length);
        $count  = $dbConnection->query("SELECT * FROM TABLE_NAME WHERE string='$string')")->num_rows;
        while($count != 0){
            $string = getName($length);
            $count  = $dbConnection->query("SELECT * FROM TABLE_NAME WHERE string='$string')")->num_rows;
        }
        return $string;
    }

    echo getUniqueString($n, $dbConnection);
?>

answered Mar 6, 2022 at 12:07

Khandaker Sajjat

11 bronze badge

Sign up to request clarification or add additional context in comments.

2 Comments

Noso Sanas Over a year ago

If the table name is "test', how should I add the table name?

Khandaker Sajjat Over a year ago

Replace TABLE_NAME with what your actual table name is.

Alaindeseine · Accepted Answer · 2022-03-06 14:26:50Z

0

You can use openssl_random_pseudo_bytes() or random_bytes() PHP fonction to generate random strings.

You can also rely on MySQL to generate uniq IDs :

INSERT INTO mytable (alphaID) VALUES (REPLACE( UUID(), '-', '' ));

answered Mar 6, 2022 at 14:26

Alaindeseine

4,6341 gold badge17 silver badges31 bronze badges

Collectives™ on Stack Overflow

PHP Unique random string generator

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related