i made a system to encrypt the data in database using AES-128. after the AES code applied, the data didnt insert into my system and database. can someone help me ? this for my final year project. i dont know what to do anymore. if i fail this subject, i might quit my bachelor degree. no one can help me, even my friends. i dont know what to do anymore. What I have tried:
What I have tried:
$sql="INSERT INTO aes.employee (
emp_id,
name,
ic,
gender,
email,
phoneNo,
kwsp,
salary,
dept
)
VALUES (
null,
aes_encrypt('$emp_id','33433'),
aes_encrypt('$name',''33433),
aes_encrypt('$ic','33433'),
aes_encrpyt('$gender',''33433'),
aes_encrpyt('$email','33433'),
aes_encrypt('$phoneNo','33433'),
aes_encrypt('$kwsp','33433'),
aes_encrypt('$salary','33433'),
aes_encrypt('$dept','33433')
)";