Save data with websql

websql-savedata

function saveLocally(dataToSave){
  	db.transaction(function (tx) { // this is nasty but truncate is not available on sqllite
			tx.executeSql('DROP TABLE data ');
			tx.executeSql('CREATE TABLE IF NOT EXISTS data (id unique, text)');
		});
		$.each(dataToSave, function(key, val) { // loop through each item in savedData
			if (val){
				db.transaction(function (tx) {
					tx.executeSql('INSERT INTO data (id, text) VALUES (?, ?)', [val['label'], val['value']]);
				});
			}
		});
		showListItems(); // refresh the list display
		showLocalData(); // update localdata display
	}