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 — update from form input</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; margin-bottom: 1rem; }
    label {
      display: block;
      font-size: 0.8125rem;
      font-weight: 600;
      color: #475569;
      margin-bottom: 0.25rem;
    }
    .field { margin-bottom: 0.75rem; max-width: 260px; }
    input {
      width: 100%;
      padding: 0.5rem 0.65rem;
      font-size: 0.9375rem;
      border: 1px solid #cbd5e1;
      border-radius: 8px;
      box-sizing: border-box;
    }
    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); }
    #status {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 460px;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
    }
    #status.ok { border-left: 4px solid #22c55e; }
    #status.err { border-left: 4px solid #ef4444; }
    code { background: #e2e8f0; padding: 0.1rem 0.35rem; border-radius: 4px; }
  </style>
</head>
<body>
  <h1>Update from form input</h1>
  <p>Add the sample user first, then edit the fields below and click Save to run <code>UPDATE users SET name = ?, age = ? WHERE id = ?</code>.</p>

  <div class="btns">
    <button type="button" id="seedBtn" class="secondary">1. Add Sample User (id 1)</button>
  </div>

  <div class="field">
    <label for="nameInput">Name</label>
    <input type="text" id="nameInput" value="Jane Doe">
  </div>
  <div class="field">
    <label for="ageInput">Age</label>
    <input type="number" id="ageInput" value="26">
  </div>

  <div class="btns">
    <button type="button" id="saveBtn">2. Save Changes</button>
  </div>

  <p id="status">Add the sample user, then edit the fields and save.</p>

  <script>
    var statusEl = document.getElementById('status');

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

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

      document.getElementById('seedBtn').addEventListener('click', function () {
        db.transaction(function (tx) {
          tx.executeSql(
            'INSERT OR REPLACE INTO users (id, name, age) VALUES (?, ?, ?)',
            [1, 'John Doe', 25],
            function () {
              statusEl.textContent = 'Added: John Doe, age 25 (id 1)';
              statusEl.className = 'ok';
            }
          );
        });
      });

      document.getElementById('saveBtn').addEventListener('click', function () {
        var name = document.getElementById('nameInput').value.trim();
        var age = parseInt(document.getElementById('ageInput').value, 10);

        if (!name || isNaN(age)) {
          statusEl.textContent = 'Enter a valid name and age.';
          statusEl.className = 'err';
          return;
        }

        db.transaction(function (tx) {
          tx.executeSql(
            'UPDATE users SET name = ?, age = ? WHERE id = ?',
            [name, age, 1],
            function (tx, result) {
              if (result.rowsAffected) {
                statusEl.textContent = 'Saved! ' + name + ', age ' + age;
                statusEl.className = 'ok';
              } else {
                statusEl.textContent = 'User not found — add the sample user first.';
                statusEl.className = 'err';
              }
            },
            function (tx, error) {
              statusEl.textContent = 'Error: ' + error.message;
              statusEl.className = 'err';
              return true;
            }
          );
        });
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL UPDATE — Update from Form Input
