Bladephp: Now with 7+ codeigniter, php, and laravel project 7+ php project From $18/Year From Rs. 1000/Year

How to create unique random string in PHP with check mysql

by
Category:php
php mysql
How to create unique random string in PHP with check mysql

When building web software applications I sometimes need a way to generate unique random strings. Unique random strings can be used as character keys or tokens to identify database records without having to give away the database records ID number. I personally use unique random strings to produce clickable links in my “Request lost password” emails. The unique random string can be matched to a user record and the password can be re-created and sent to the user.

define('DB_SERVER', "localhost");
define('DB_USER', "root");
define('DB_PASS', "");
define('DB_DATABASE', "student");
$con = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);

function refercode()
{
	$string = '';
	$characters = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
	$max = strlen($characters) - 1;
	for ($i = 0; $i < 6; $i++) {
		$string .= $characters[mt_rand(0, $max)];
	}
	$refer = "select * from user_detail where refer_code = '".$string."' ";
	$coderefertest = mysqli_query($con,$refer);

	if(mysqli_num_rows($coderefertest)>0)
	{
		return refercode();
	}
	else
	{
		return $string;
	}
}
$refer_by = refercode();

0 Comments


Html code work in comment box


Related Post