rizkylab / node-mysql-aes Goto Github PK

APP_KEY = yourkey

import { encrypt } from '@/utils/crypt.js'
...
...
const first_name = req.body.first_name
const query = `INSERT INTO user SET first_name = ${encrypt(first_name)}`

INSERT INTO user SET first_name = HEX(AES_ENCRYPT('Test Nama', 'app_key') ), last_name = HEX(AES_ENCRYPT('Last Name', 'app_key') ), phone = HEX(AES_ENCRYPT('0811111111', 'app_key') ), email = HEX(AES_ENCRYPT('[email protected]', 'app_key') ), comments = 'comment';

import { decrypt } from '@/utils/crypt.js'
...
...
const query = `SELECT *, ${decrypt('first_name')} FROM user`

SELECT *, AES_DECRYPT( UNHEX(first_name), 'app_key' ) as first_name FROM user;

SELECT *, AES_DECRYPT( UNHEX(first_name), 'app_key' ) as first_name FROM user WHERE AES_DECRYPT(UNHEX(first_name), 'app_key') like '%Test%';