simpler version for incryption

[mankolele]

Since MD5 is not recommended which other can be used.

[ronverdonk]

Try SHA1, it is better then MD5.

http://nl2.php.net/manual/en/function.sha1.php

Ronald :cool:

[Banfa]

Try SHA1, it is better then MD5.

If you read the MySQL documentation it says that SHA1 is not much(any) better than MD5 for security

[tbb9216]

AES is the new defacto standard. it is in both PHP and mysql by default, i find the mysql method a LOT easier to use. its the same enc type that the US govt uses, there are only 2 HYPOTHETICAL breaks to it in existence. in php it is part of the mcrypt library, and it goes as rhijndahl or something like that, after the 2 people who created it, and make sure to use the 128bit version, as that is the AES version.

in mysql its just:

INSERT INTO table
(field)
VALUES
(AES_ENCRYPT('value', 'secret_key'));

and to retrieve it (warning, you MUST have the same key you stored it with):

SELECT 
AES_DECRYPT('field', 'secret_key')
FROM table

simple as that.

-tim