I need to generate a random alphanumeric string that is unique to all values in a specific column in one of my tables in phpmyadmin. Also, I need it to be 20 characters long. There are many questions like this already posted but I didn't see any that needed a string unique to a column in phpmyadmin.
So how would I do this in php?
Something like this:
function isToken($token)
{
if (isset($token) && $token) {
//verification values in BD
$query = "SELECT id FROM table WHERE token='$token'";
$sql = mysql_query($query);
if (mysql_num_rows($sql) > 0) {
return true;
} else {
return false;
}
} else {
return false;
}
}
function generateUniqueToken($number)
{
$arr = array('a', 'b', 'c', 'd', 'e', 'f',
'g', 'h', 'i', 'j', 'k', 'l',
'm', 'n', 'o', 'p', 'r', 's',
't', 'u', 'v', 'x', 'y', 'z',
'A', 'B', 'C', 'D', 'E', 'F',
'G', 'H', 'I', 'J', 'K', 'L',
'M', 'N', 'O', 'P', 'R', 'S',
'T', 'U', 'V', 'X', 'Y', 'Z',
'1', '2', '3', '4', '5', '6',
'7', '8', '9', '0');
$token = "";
for ($i = 0; $i < $number; $i++) {
$index = rand(0, count($arr) - 1);
$token .= $arr[$index];
}
if (isToken($token)) {
return generateUniqueToken($number);
} else {
return $token;
}
}
$uniqueToken = generateUniqueToken(20);
There's no way to get unique random in a MySQL table automatically. You must create a unique random text in PHP and find it in the MySQL table, and if it exists generate it again.
protected function generateToken($length=6){
return substr(str_shuffle('abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ1234567890'),rand(0,60-$length),$length);
}
I think I could make it super simple:
echo md5(time());
