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 Retrieve Example</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.75rem; font-size: 1.25rem; color: #0f172a; }
    ul {
      margin: 0.5rem 0 0;
      padding: 0;
      list-style: none;
      max-width: 460px;
    }
    li {
      padding: 0.6rem 0.85rem;
      margin-bottom: 0.5rem;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
    }
    #status {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 460px;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
      min-height: 1.5rem;
    }
    #status.ok { border-left: 4px solid #22c55e; }
    #status.err { border-left: 4px solid #ef4444; }
  </style>
</head>
<body>
  <h1>Data from users table</h1>
  <ul id="dataList"></ul>
  <p id="status"></p>

  <script>
    if (!window.openDatabase) {
      document.getElementById('status').textContent =
        'Web SQL is not supported in this browser.';
      document.getElementById('status').className = 'err';
    } else {
      const db = openDatabase('myDatabase', '1.0', 'Test DB', 2 * 1024 * 1024);

      db.transaction(function (tx) {
        tx.executeSql('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)');
        tx.executeSql('INSERT OR IGNORE INTO users (id, name, age) VALUES (?, ?, ?)', [1, 'John Doe', 25]);
        tx.executeSql('INSERT OR IGNORE INTO users (id, name, age) VALUES (?, ?, ?)', [2, 'Jane Smith', 32]);
      });

      db.transaction(function (tx) {
        tx.executeSql('SELECT * FROM users', [], function (tx, results) {
          const list = document.getElementById('dataList');
          for (let i = 0; i < results.rows.length; i++) {
            const row = results.rows.item(i);
            const li = document.createElement('li');
            li.textContent = 'ID: ' + row.id + ', Name: ' + row.name + ', Age: ' + row.age;
            list.appendChild(li);
          }
          document.getElementById('status').textContent =
            'Loaded ' + results.rows.length + ' row(s).';
          document.getElementById('status').className = 'ok';
        }, function (tx, error) {
          document.getElementById('status').textContent = 'Error: ' + error.message;
          document.getElementById('status').className = 'err';
          return true;
        });
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL SELECT — Complete HTML Page
