I need asymmetric encryption to also encrypt pre-exisiting form entries

  • skylinedesigns

    (@skylinedesigns)


    9 years, 8 months ago

    Dear Goff,
    For a doctor who needs to have gravity forms stored in a hipaa compliant manner, I need asymmetric encryption to also encrypt pre-exisiting form entries stored on her database. Currently it is only successfully encrypting/decrypting new form entries submitted AFTER I installed and set up the plugin. Can you please guide me.
    Thanks a lot,
    Asli C Theobald, developer

    https://wordpress.org/plugins/gravitate-encryption/

Viewing 1 replies (of 1 total)
  • dhefley

    (@dhefley)

    9 years, 7 months ago

    This is what I’m starting with, but so far I’m not sure it is working 100%:

    require_once('/var/www/po/wp-load.php');
 if(!class_exists('GDS_Encryption_Class')) die('NO ENCRYPTION CLASS');
 global $wpdb;
 $forms = $wpdb->get_results( 'SELECT id FROM '.$wpdb->prefix.'rg_lead WHERE form_id = 4', OBJECT );
 foreach ($forms as $f) {
        $results = $wpdb->get_results( 'SELECT * FROM '.$wpdb->prefix.'rg_lead_detail WHERE form_id = 4 AND lead_id = '.$f->id .'', OBJECT );
        foreach ($results as $r) {
            echo 'Encrypting '.$r->id.':'.$r->value."<hr />";
            $eData=GDS_Encryption_Class::encrypt($r->value);
            $wpdb->update($wpdb->prefix.'rg_lead_detail',array('value'=>$eData),array('id'=>$r->id));
        }
    }
Viewing 1 replies (of 1 total)
  • The topic ‘I need asymmetric encryption to also encrypt pre-exisiting form entries’ is closed to new replies.