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 — SELECT by id</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; }
    label { display: block; margin-bottom: 0.35rem; font-size: 0.875rem; font-weight: 600; }
    input {
      display: block;
      width: 100%;
      max-width: 120px;
      padding: 0.5rem 0.65rem;
      margin-bottom: 0.75rem;
      border: 1px solid #cbd5e1;
      border-radius: 8px;
      font-size: 1rem;
    }
    button {
      padding: 0.55rem 1rem;
      font-size: 0.9375rem;
      background: #2563eb;
      color: #fff;
      border: none;
      border-radius: 8px;
      cursor: pointer;
    }
    button:hover { background: #1d4ed8; }
    #result {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 420px;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
    }
    #result.ok { border-left: 4px solid #22c55e; }
    #result.err { border-left: 4px solid #ef4444; }
  </style>
</head>
<body>
  <h1>Fetch one row by id</h1>

  <label for="userId">User id</label>
  <input type="number" id="userId" value="2" min="1">
  <button type="button" id="fetchBtn">Get User</button>

  <p id="result">Enter an id (1–3) and click Get User.</p>

  <script>
    var resultEl = document.getElementById('result');

    if (!window.openDatabase) {
      resultEl.textContent = 'Web SQL is not supported in this browser.';
      resultEl.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)');
        [[1, 'John Doe', 25], [2, 'Jane Smith', 32], [3, 'Alex Kim', 28]].forEach(function (row) {
          tx.executeSql('INSERT OR IGNORE INTO users (id, name, age) VALUES (?, ?, ?)', row);
        });
      });

      document.getElementById('fetchBtn').addEventListener('click', function () {
        var id = parseInt(document.getElementById('userId').value, 10);

        db.transaction(function (tx) {
          tx.executeSql(
            'SELECT * FROM users WHERE id = ?',
            [id],
            function (tx, results) {
              if (results.rows.length === 0) {
                resultEl.textContent = 'No user with id ' + id + '.';
                resultEl.className = 'err';
              } else {
                var row = results.rows.item(0);
                resultEl.textContent =
                  'ID: ' + row.id + ', Name: ' + row.name + ', Age: ' + row.age;
                resultEl.className = 'ok';
              }
            },
            function (tx, error) {
              resultEl.textContent = 'Error: ' + error.message;
              resultEl.className = 'err';
              return true;
            }
          );
        });
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL SELECT — Fetch One Row by ID
