0

2 fields in my table are encrypted (email, name) and the other not.

I use the function $email = decrypt('email'); to get the original String.

How to use the function into mysql?

the question: how can I insert this function : decrypt('email') into this query below ? :

$query = mysqli_query($con, "select 'name', 'tel', 'adress', 'email' from users where id = 10");

for Encrypting works :

INSERT INTO `users` (`name`, `tel`, `adress` , `email`) VALUES (encrypt($name),$tel, $adress, encrypt($email));
user9212972
  • 39
  • 2
  • 8

0 Answers0