Page 1 of 1
How to apply password and encrypt functions in MySQL on PHP?
Posted: Sun May 23, 2004 10:29 pm
by crypdude
Can anyone do my favour? I'm very stuck here..!!! pls.. Miouw......!! Miaauw.....!(cat voice)

Posted: Sun May 23, 2004 11:19 pm
by Steveo31
So... whats the question?
Posted: Mon May 24, 2004 3:21 am
by crypdude
The question in on the topic above.. hehe! Miauuuuwww...!!
Posted: Mon May 24, 2004 3:30 am
by Wayne
that doesnt really help .... and Miauwwww at people isnt really going to motivate them to help .... what are you trying to do, post an example, are you just trying to store a password in a mysql table and try and match it afterwards etc. ???
Posted: Mon May 24, 2004 4:55 am
by crypdude
Sorry, but what i'm trying to say is, how to make password can't be retrieve by other users in mySQL database?.. How could i do???
Several ways
Posted: Mon May 24, 2004 4:58 am
by Lord Sauron
There are several ways to do so.
Encrypt the passwords in your database. Or you could even right your own encrypting system if you know something of math. Or even both.
And even if you did so, you must take precaution for e.g. sql injection.
So please, be a little more specific with your question.
Posted: Mon May 24, 2004 10:01 pm
by crypdude
Ok, recently..after looked at mySQL database, i found some function for it.. Before, I just key in the data without thinking about it security or something more secure. Then after press insert button or toolbar, then insert the data manually, (u can try it by phpmyadmin or etc) then there are about 4 columns. One of them is function column. Then after i clicked dropdown itself, i found so many stuffs include password and encrypt. I'm very interested to know it. But how could i apply it in my programming...?
Posted: Mon May 24, 2004 10:35 pm
by Joe
Use MD5.
$password = md5($string);
And to ask about people retrieving your password from the database. Well if your site is secured from sql injection, etc.. you wouldn't need to worry much.