Re: Re: Create unique non-autoincrement key for 700,000 records?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Monday, December 15, 2008 7:29 PM, gouldimg@xxxxxxx wrote:

I have a mySQL database with 700,000 records in it, which are presently keyed with an "auto-increment" field.

What I'd like to do is create another field with a field where each and every record number has a unique keyvalue. Example: "su5e23vlskd" for records 1, and "34fdfdsglkdj4" for record 2. All that matters is that it's unique, and isn't a number that can be guessed or an "autoincrement" number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value?


Here is my answer to your question.
You can use this same logic to create unique id's for many things.
Hope this comes out okay in an email, if not I also put it online here:
http://www.bigdoghost.com/downloads/php-284646.html

<?php

error_reporting(E_ALL);
ini_set('error_reporting', E_ALL);
ini_set('display_startup_errors','1');
ini_set('display_errors','1');


function dec2base($dec)
{
$digits = "23456789ABCDEFGHJKLMNPQRSTUVWXYZ";
$value = "";
$base  = strlen($digits);
while($dec>$base-1)
{
 $rest = $dec % $base;
 $dec  = $dec / $base;
 $value = $digits[$rest].$value;
}

$value = $digits[intval($dec)].$value;
return (string) $value;
}

/*
// Step 1) define database connection

define('DB_HOST', 'localhost'); // Change this to the proper DB Host name
define('DB_USERNAME', 'myusername');  // Change this to the proper DB User
define('DB_PASSWD', 'mypassword'); // Change this to the proper DB User password
define('DB_NAME', 'mydatabase');  // Change this to the proper DB Name

@mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWD) or die("Error: Database connection information is incorrect"); @mysql_select_db(DB_NAME) or die("Error: Database connection information is incorrect");

*/

/*
// Step 2) create test schema

CREATE TABLE IF NOT EXISTS `test` (
 `id` int(11) NOT NULL auto_increment,
 `mykey` varchar(20) NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

*/


/*
// Step 3) create 700,000 records

for ($i=1; $i <= 700000; $i++)
{
@mysql_query("INSERT INTO test VALUES ('', '')");
}

*/

/*
// Step 4) update 700,000 records


// The larger this number is detrmines the size of "mykey"
$int = 1000000;

$result = @mysql_query("SELECT id FROM test ORDER BY id ASC");

if (@mysql_num_rows($result) > 0)
{
while ($row = @mysql_fetch_object($result))
{
 // Add the two numbers together and base it
 $mykey = dec2base($int+$row->id);
@mysql_query("UPDATE test SET mykey='".$mykey."' WHERE id='".$row->id."'");
}
}

*/

?>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux