Data view for tizen table

This function puts data from database into table.
        function dataView(db) {
            var doc = document.getElementById("tb1");
            var docH = document.getElementById("docTitle");
            doc.innerHTML = "";
            docH.innerHTML = "";
            db.transaction(function (t) {
                t.executeSql("SELECT * FROM tizenTable", [],
                function (trans, r) {
                    docH.innerHTML = "<option value='all'>all</option>";
                    for (var i = 0; i < r.rows.length; i++) {
                        var id = r.rows.item(i).id;
                        var title = r.rows.item(i).title;
                        var content = r.rows.item(i).content;
                        if (doc) {
                            doc.innerHTML += "<tr><td>" + id + "</td><td>" + title + "</td><td>" + content + "</td></tr>";
                        }
                        if (docH) {
                            docH.innerHTML += "<option value=" + id + ">" + title + "</option>";
                        }
                    }
                },
                function (t, e) { alert("Error:" + e.message); }
             );
            });
        }

Responses

0 Replies