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') ";