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 — LIMIT / OFFSET pagination</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; align-items: center; gap: 0.5rem; margin-bottom: 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; }
    button:disabled { background: #94a3b8; cursor: not-allowed; }
    .page-label { font-size: 0.875rem; font-weight: 600; color: #475569; }
    ul {
      margin: 1rem 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;
    }
    #status.err { border-left: 4px solid #ef4444; }
    code { background: #e2e8f0; padding: 0.1rem 0.35rem; border-radius: 4px; }
  </style>
</head>
<body>
  <h1>Paginate with LIMIT / OFFSET</h1>
  <p>Seeds 12 users, then loads 5 rows at a time with <code>SELECT * FROM users ORDER BY id LIMIT ? OFFSET ?</code>.</p>

  <div class="btns">
    <button type="button" id="prevBtn">&larr; Prev</button>
    <span class="page-label" id="pageLabel">Page 1</span>
    <button type="button" id="nextBtn">Next &rarr;</button>
  </div>

  <ul id="dataList"></ul>
  <p id="status">Loading page 1&hellip;</p>

  <script>
    var listEl = document.getElementById('dataList');
    var statusEl = document.getElementById('status');
    var pageLabelEl = document.getElementById('pageLabel');
    var pageSize = 5;
    var page = 0; /* 0-based */
    var totalRows = 12;

    if (!window.openDatabase) {
      statusEl.textContent = 'Web SQL is not supported in this browser.';
      statusEl.className = 'err';
      document.getElementById('prevBtn').disabled = true;
      document.getElementById('nextBtn').disabled = true;
    } 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)');
        for (var i = 1; i <= totalRows; i++) {
          tx.executeSql(
            'INSERT OR IGNORE INTO users (id, name, age) VALUES (?, ?, ?)',
            [i, 'User ' + i, 20 + i]
          );
        }
      }, null, function () {
        loadPage();
      });

      function loadPage() {
        listEl.innerHTML = '';
        db.transaction(function (tx) {
          tx.executeSql(
            'SELECT * FROM users ORDER BY id LIMIT ? OFFSET ?',
            [pageSize, page * pageSize],
            function (tx, results) {
              var len = results.rows.length;
              if (len === 0) {
                listEl.innerHTML = '<li>No more rows.</li>';
              }
              for (var i = 0; i < len; i++) {
                var row = results.rows.item(i);
                var li = document.createElement('li');
                li.textContent = 'ID: ' + row.id + ', Name: ' + row.name + ', Age: ' + row.age;
                listEl.appendChild(li);
              }
              var totalPages = Math.ceil(totalRows / pageSize);
              pageLabelEl.textContent = 'Page ' + (page + 1) + ' of ' + totalPages;
              statusEl.textContent = 'Loaded ' + len + ' row(s) — OFFSET ' + (page * pageSize) + '.';
              document.getElementById('prevBtn').disabled = page === 0;
              document.getElementById('nextBtn').disabled = (page + 1) * pageSize >= totalRows;
            },
            function (tx, error) {
              statusEl.textContent = 'Error: ' + error.message;
              statusEl.className = 'err';
              return true;
            }
          );
        });
      }

      document.getElementById('prevBtn').addEventListener('click', function () {
        if (page > 0) { page--; loadPage(); }
      });
      document.getElementById('nextBtn').addEventListener('click', function () {
        if ((page + 1) * pageSize < totalRows) { page++; loadPage(); }
      });
    }
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
Web SQL SELECT — Paginate with LIMIT and OFFSET
