Q: How can encrypt and decript in mysql .

AES_DECRYPT() Decrypt using AES
AES_ENCRYPT() Encrypt using AES

$query = "insert into member (spid,uname,pss) values ('$xyz','$username',aes_encrypt('$password','password'))";

$query = "select uname,aes_decrypt(pss,'password') as password from member where spid='$xyz'";