grocery crud with AES Encryption

Question

How to match data in table using mysql AES decrypt in grocery CRUD ?

Error getting on crud set realtion as follows:

$crud->set_relation(AES_DECRYPT(departments.department_id,'key'),'users.department_id','deparmtnet_name');

Not Found: departments.AES_DECRYPT(departments.department_id,'key')

select user_name,department_name from users as j333 left join departments jd333 on departments.AES_DECRYPT(departments.department_id,'key')=j333.department_id

score 1 · Answer 1 · answered Jul 25 '13 at 13:26

1

Grocery Crud doesn't recognize "AES Decrypt" function

answered Jul 25 '13 at 13:26

Rinor Veseli

116
1
6

Then how we implement this? – cideveloper Jul 26 '13 at 11:43

grocery crud with AES Encryption

1 Answers1