CODEWITHSUNDEEP
javascriptindexeddb
wayzz
wayzz

Reputation: 627

Why is db.transaction not working with indexeddb?

I am new at using inxededdb and am trying to get data out of a store. The store contains data, but for some reason the code stops after trying to set the var tx. If I am missing anything please let me know. Here is the function with which I am trying to get the book: 

function getBook(){
    var tx = db.transaction("book", "readonly");
    var store = tx.objectStore("book");
    var index = store.index("by_getid");

    var request = index.get("<?php echo $_GET['book'] ?>");
    request.onsuccess = function() {
      var matching = request.result;
      if (matching !== undefined) {
         document.getElementById("text-container").innerHTML = matching.text;
      } else {
        alert('no match');
        report(null);
      }
    };
}

Solved Version:

function getBook(){
  var db;
  var request = indexedDB.open("library", 1);  

  request.onsuccess = function (evt) {
    db = request.result; 
    var transaction = db.transaction(["book"]);
    var objectStore = transaction.objectStore("book");
    var requesttrans = objectStore.get(<?php echo $_GET['book'] ?>);

    requesttrans.onerror = function(event) {

    };

    requesttrans.onsuccess = function(event) {
      alert(requesttrans.result.text);
    };      
  };
}

Upvotes: 8

Views: 9085

Answers (3)

stepanenkoalex91
stepanenkoalex91

Reputation: 11

I has problem with transaction, it's return error db.transaction is not a function or return undefined. You will try like this, it's working for me:

const table = transaction.objectStore('list');
const query = table.getAll();
query.onsuccess = () => {
  const list = query?.result;
  console.log(list);
};

Upvotes: 0

Josh
Josh

Reputation: 18710

The problem is probably your db variable. You are probably accessing a closed or null instance of a connection object.

Try instead to create the db connection right inside the function. Do NOT use a global db variable.

Upvotes: 6

Kyaw Tun
Kyaw Tun

Reputation: 13151

index.get yields primary key. You have to get record value using the resulting primary key.

Upvotes: 0

Related Questions