PHP GUID Generator for MySQL.

Anon

Does anyone have, or know where I can get, a PSP script which will generate a 32 character Hexadecimal GUID (Global Unique Identifier) which I can then use for MySQL.

If the script which generates such a GUID could be provided, or some pointers on how to do this (functions to call, etc.) then that would be greatly appreciated.

Thank you,

Abdul-Rehman

toma42

md5() returns a 32 char string. Just seed it with the microtime() plus some string to get your value.

Anon

Will this work with PostgreSQL>

toma42

The procedure I described is php code, not sql code, so it will work fine.

Anon

here is a not very well tested function:

function generate()
{
global $SERVER_ADDR;

	// get the current ip, and convert it to its positive long value
	$long_ip = ip2long($SERVER_ADDR);
	if($long_ip < 0) $long_ip += pow(2,32);

	// get the current microtime and make sure it's a positive
	// long value
	$time = microtime();
	if($time < 0) 
	{
		$time += pow(2,32);
	}

	// put those strings together
	$combined = $long_ip . $time;

	// md5 it and throw in some dashes for easy checking
	$guid = md5($combined);
	$guid = substr($guid, 0, 8) . "-" .
	substr($guid, 8, 4) . "-" .
	substr($guid, 12, 4) . "-" .
	substr($guid, 16, 4) . "-" .
	substr($guid, 20); 

	return $guid;
}

wkearney99

These aren't the same thing as a GUID. For info on creating genuine GUID strings see the RFC at:
http://www.opengroup.org/dce/info/draft-leach-uuids-guids-01.txt