js variable value into Web Sql db

Question

I cannot find a solution for passing JS variable value (text) into websql DB .. All i keep finding is some PHP solutions and I do not want to use it.

function store(){
    var x = document.getElementById('inp1').value;
    names.push(x);
    L10();
    $('#tt').text(names);
}


function Insert(){
    db.transaction(function(t){
    t.executeSql('INSERT INTO Followers(fNAME) VALUES (?)',[x]);//->here is my problem :) x variable
    });
}
$('#inp2').click(function(){

    store();

    Insert();
});

can you post the code when calling store() and Insert()? – heinob Aug 24 '14 at 11:46 — heinob, Aug 24 '14 at 11:46
var x gets the value from my input field – GoranCrO Aug 24 '14 at 11:50 — GoranCrO, Aug 24 '14 at 11:50
I would need to store value from my variable to web sql DB – GoranCrO Aug 24 '14 at 11:51 — GoranCrO, Aug 24 '14 at 11:51
getting : ReferenceError: x is not defined – GoranCrO Aug 24 '14 at 11:58 — GoranCrO, Aug 24 '14 at 11:58

GoranCrO · Accepted Answer · 2014-08-24T12:31:47.930

0

Found my error ,I used private variable x instead of global x .. duh!

x = document.getElementById('inp1').value;

edited Aug 24 '14 at 12:31

answered Aug 24 '14 at 12:24

GoranCrO

19
6

js variable value into Web Sql db

1 Answers1