HTML Code
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Web SQL — reusable insertItem()</title>
  <style>
    body {
      font-family: system-ui, sans-serif;
      margin: 0;
      padding: 1.5rem;
      background: #f8fafc;
      color: #334155;
      line-height: 1.6;
    }
    h1 { margin: 0 0 0.5rem; font-size: 1.25rem; color: #0f172a; }
    p { margin: 0 0 1rem; max-width: 460px; }
    .btns { display: flex; flex-wrap: wrap; gap: 0.5rem; }
    button {
      padding: 0.55rem 1rem;
      font-size: 0.9375rem;
      background: #2563eb;
      color: #fff;
      border: none;
      border-radius: 8px;
      cursor: pointer;
    }
    button.secondary { background: #64748b; }
    button:hover { filter: brightness(1.05); }
    #log {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 460px;
      background: #0f172a;
      color: #e2e8f0;
      border-radius: 8px;
      font-family: ui-monospace, Consolas, monospace;
      font-size: 0.8125rem;
      white-space: pre-wrap;
      min-height: 3rem;
    }
    .hint {
      margin-top: 1rem;
      font-size: 0.8125rem;
      color: #64748b;
      max-width: 460px;
    }
    code { background: #e2e8f0; padding: 0.1rem 0.35rem; border-radius: 4px; }
  </style>
</head>
<body>
  <h1>Reusable insertItem(id, name) function</h1>
  <p>One function, called for two different items: <code>Notebook</code> (id 2) and <code>Pen</code> (id 3).</p>

  <div class="btns">
    <button type="button" id="addNotebookBtn">1. insertItem(2, 'Notebook')</button>
    <button type="button" id="addPenBtn" class="secondary">2. insertItem(3, 'Pen')</button>
    <button type="button" id="addBothBtn">3. Insert Both</button>
  </div>

  <div id="log">Click a button to run insertItem(id, name).</div>
  <p class="hint">If Web SQL is not supported, the log will tell you.</p>

  <script>
    var logEl = document.getElementById('log');
    var firstLog = true;

    function log(line) {
      if (firstLog) {
        logEl.textContent = line;
        firstLog = false;
      } else {
        logEl.textContent += '\n' + line;
      }
    }

    if (!window.openDatabase) {
      logEl.textContent = 'Web SQL is not supported in this browser.';
    } else {
      var db = openDatabase('tryitDemo', '1.0', 'Try It DB', 1024 * 1024);

      db.transaction(function (tx) {
        tx.executeSql(
          'CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY, name TEXT)'
        );
      });

      function insertItem(id, name) {
        db.transaction(function (tx) {
          tx.executeSql(
            'INSERT OR REPLACE INTO items (id, name) VALUES (?, ?)',
            [id, name],
            function () {
              log('Saved: ' + name + ' (id ' + id + ')');
            },
            function (tx, error) {
              log('Insert error for id ' + id + ': ' + error.message);
              return true;
            }
          );
        });
      }

      document.getElementById('addNotebookBtn').addEventListener('click', function () {
        insertItem(2, 'Notebook');
      });
      document.getElementById('addPenBtn').addEventListener('click', function () {
        insertItem(3, 'Pen');
      });
      document.getElementById('addBothBtn').addEventListener('click', function () {
        firstLog = true;
        insertItem(2, 'Notebook');
        insertItem(3, 'Pen');
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL INSERT — Reusable insertItem Function
