JSFiddle - React, Tailwind, and code Playground
by fourFath3r
HTML
<p>
<input type="button" class="create" value="CREATE" />
</p>
<p>
<input type="button" class="insert" value="INSERT"/>
<input type="text" class="text" placeholder="enter value" />
</p>
<p>
<input type="button" class="delete" value="DROP"/>
</p>
JavaScript
var db = openDatabase('demodb', '1.0', 'webmeet demo', 2 * 1024 * 1024);
var model = function() {
var m = {};
m.create = function() {
db.transaction(function(tx) {
tx.executeSql('CREATE TABLE "demotable" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE , "text" VARCHAR)');
});
};
m.insert = function(text) {
db.transaction(function(tx) {
tx.executeSql('INSERT INTO demotable (text) VALUES("' + text + '")');
});
};
m.select = function() {
db.transaction(function(tx) {
tx.executeSql('SELECT * FROM "demotable"');
});
};
m.deletefunction = function() {
db.transaction(function(tx) {
tx.executeSql('DROP TABLE "demotable"');
});
};
return m;
}();
$(function() {
$('.create').click(function() {
model.create();
});
$('.insert').click(function() {
model.insert($('.text').val());
});
$('.delete').click(function() {
model.deletefunction();
});
});
//model.create();