php的mysql5加密_使用mcrypt，PHP和MySQL进行加密

$salt = time(); // I would use something other than time(), something more random

// store it in the db and redirect user

connect();

$query = mysql_query("INSERT INTO user VALUES

('".mysql_real_escape_string($username)."',

'".mysql_real_escape_string(sha1($password . $salt))."',

'".mysql_real_escape_string($salt)."') ");

// returning user

$username = $_POST['username'];

$password = $_POST['password'];

// retrieve stored password

connect();

$result = mysql_query("SELECT * FROM user WHERE username = '".mysql_real_escape_string($username)."' ");

$row = mysql_fetch_assoc($result);

if (!$result) {

// user doesn't exist

}

$storedPassword = $row['password'];

$salt = $row['salt'];

$hashedPassword = sha1($password . $salt);

if ($storedPassword != $hashedPassword) {

// exit

}

else {

// redirect user

}我并不是说这是最安全的，它只是一个用盐进行哈希散列的小例子。