Encryption

Web SQL cipher mechanism

by nirus

HTML

<script src="https://raw.github.com/bitwiseshiftleft/sjcl/master/sjcl.js"></script>
<div><h1>Sample Written by Niranjan Kumar using standfor encrytion library</h1></div>
<a href="https://github.com/bitwiseshiftleft/sjcl">Standford Link</a>

JavaScript

var Edata;
        function createDB(tx){
                tx.executeSql('CREATE TABLE IF NOT EXISTS SurveyClient_table (question_id varchar(5) PRIMARY KEY,answer TEXT)');
                alert(Edata);
               //tx.executeSql("INSERT INTO SurveyClient_table(question_id, answer) VALUES (?,?)",[1, "Niranjan"]);
               tx.executeSql("INSERT INTO SurveyClient_table(question_id, answer) VALUES (?,?)",[1, Edata]);
               
            }
            
            //to delete the table
           /*db.transaction(function(tx){
               tx.executeSql("DROP TABLE SurveyClient_table");
           },errorCB,successCB);*/
          
          
        function errorCB(err){
            alert("Error : "+err.message);
            }
        function successCB(tx,Edata){
            alert('created and inserted');
        
        }
        
               function init(){
                  Edata =  JSON.stringify(sjcl.encrypt("niranjan", "1234567890"),null,2);   //gets the encrypted data
                    
               
                    alert(Edata);
                    
           
            
            db.transaction(createDB, errorCB, successCB);
            db.transaction(function(tx){
               tx.executeSql('SELECT * FROM SurveyClient_table', [], function(tx, results){ 
                   alert(sjcl.decrypt('niranjan',JSON.parse(results.rows.item(0).answer)));
                  
               });
            });
            
             }