JSFiddle - React, Tailwind, and code Playground

by mgibsonbr

HTML

<input id="list" />
<button onclick="teste()">Teste</button>
<ul id="exlist"></ul>

JavaScript

function teste() {
    var db = openDatabase('mydb', '1.0', 'my first database', 2 * 1024, function () {
        db.transaction(function (tx) {
            tx.executeSql('CREATE TABLE exercicios (se_id unique, ex_nome)');
            tx.executeSql('INSERT INTO exercicios (se_id, ex_nome) VALUES (1, "foo")');
            tx.executeSql('INSERT INTO exercicios (se_id, ex_nome) VALUES (2, "bar")');
            tx.executeSql('INSERT INTO exercicios (se_id, ex_nome) VALUES (3, "baz")');
        });
    });
    var myTest = parseInt(document.getElementById("list").value, 10);
    db.transaction(function (tx) {
        tx.executeSql(
            'SELECT * FROM exercicios WHERE se_id = ?', [myTest],

        function (tx, results) {
            var exlist = document.getElementById("exlist");

            for (var i = 0; i < results.rows.length; i++) {
                var row = results.rows.item(i);
                exlist.innerHTML += "<li>" + row.se_id + " - " + row.ex_nome + "</li>";
            }
        });
    });
}