Sql insert into question

Dear experts

I'd like to insert into my table unique user key
Every row has data but my uuk coloumn is empty

I have 4 coloumns on my table
_key, uid, pwd, uuk

My uuk coloumn is emty and i need unique user key for every user for cookie

How can i insert below formula to my database for each user?
I use php and mysql database

My table name is KullaniciBilgileri

// MAKE THE UNIQUE USER KEY
        $uuk = md5($uid . $pwd . rand());
LVL 1
BRMarketingAsked:
Who is Participating?
 
Ray PaseurCommented:
Here is how I would do it...

FIrst, modify the existing code so that any new registrations automatically build the "uuk" value and store it in the database.  That will keep you from having a "regression" later.

Next, write a short and simple PHP script to do the following...

1. SELECT _key, uid, pwd FROM your database table WHERE uuk = '' /* This is an empty string */
2. Iterate over the results set.   With each row:
3. $uuk = md5($uid . $pwd . rand());
4. UPDATE your database table SET uuk = '$uuk' WHERE _key = $_key LIMIT 1

This will take on a second or two to run, and you'll only need to run it once.  Then you can use the "uuk" values as described in the article.
0
 
BRMarketingAuthor Commented:
I used this article for my page which is really good

PHP Client Registration, Login, Logout and Easy Access Control

Written by:Ray Paseur
0
 
BRMarketingAuthor Commented:
I have direct access to mysql database, can i do it with sql script or do i have to use php to do this?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Marco GasiFreelancerCommented:
I'd use php:
$uuk = md5($uid . $pwd . rand());
$query = "INSERT INTO KullaniciBilgileri (_key, uid, pwd, uuk) VALUES ('$key', '$uid', '$pwd', '$uuk')";

Open in new window

0
 
BRMarketingAuthor Commented:
Thank you
0
 
Julian HansenCommented:
Why not use UUID() for your unique key?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.