Monday, 9 January 2017

ENCRYPT AND DECRYPT PASSWORD IN PHP USING SQL

ENCRYPTION CODE  :

$user_name = mysqli_real_escape_string($link, $_POST['username']);
$email_address = mysqli_real_escape_string($link, $_POST['email']);
$password  = mysqli_real_escape_string($link, $_POST['password']);
$phone_no = mysqli_real_escape_string($link, $_POST['phone']);

$image_person = mysqli_real_escape_string($link, $_POST['image']);


$sql = "INSERT INTO table_ name(username,    email          , password        ,phone    , image) VALUES

                        ('$user_name',  '$email_address',AES_ENCRYPT('$password', 'phpallcode'), '$phone_no','$image_person')";





DECRYPTION CODE: 


                           $email_address = mysqli_real_escape_string($link, $_POST['email']);
                          $password = mysqli_real_escape_string($link, $_POST['password']);

   $sql = "SELECT * FROM table_name WHERE email= '$email_address'  AND password = AES_ENCRYPT('$password', 'phpallcode') ";