How to apply MD5 or SHA2 to a field
You can do this on client-side using a javascript MD5 library during a submit event such as "jqGridAddEditBeforeSubmit". See a list of full events here
First Method: Javascript
A popular javascript MD5 library
Follow the event handler example
Pseudo code:
$beforeSubmit = <<<BEFORESUBMITfunction (postdata, formid){
postData.password = md5(postData.password); return return[true,''];}BEFORESUBMIT;$dg->add_event("jqGridAddEditAfterSubmit", $beforeSubmit);Second Method: Database Trigger (SHA2)
CREATE TRIGGER `userInsert`BEFORE INSERT ON `database`.`users` FOR EACH ROWBEGIN IF LENGTH(NEW.password) != 64 THEN SET NEW.password = SHA2(NEW.password,0); SET NEW.date_inserted = now(); END IF;ENDCREATE TRIGGER `userUpdate`BEFORE UPDATE ON `database`.`users` FOR EACH ROWBEGIN IF LENGTH(NEW.password) != 64 THEN SET NEW.password = SHA2(NEW.password,0); SET NEW.date_updated = now(); END IF;END