How to count the number of elements in table sqlite phonegap

Question

can you please tell me how to count the number of elements in a table in sqlite.It is not giving correct result.

function Test(test){
alert(test)
var x;
    db.transaction(function (tx) {
            $yoursql = 'SELECT * FROM  "'+test+'"';
            tx.executeSql($yoursql, [], function (tx, results) {
                alert(results.rows.length+ "rows")
                x= results.rows.length+"TableName"+test;

            });
            return x;
});

score 3 · Answer 1 · answered Mar 24 '15 at 11:35

3

var countSql = "SELECT count(*) AS cnt FROM users";
$cordovaSQLite.execute(db, countSql, []).then(function (res) {
    console.log("count : " + res.rows.item(0).cnt);
});

answered Mar 24 '15 at 11:35

ehelvacikoylu

51
5

Lucas Willems · Accepted Answer · 2013-07-20T06:15:15.773

1

Try this code :

function Test(test){
    alert(test)
    var x;
    db.readTransaction(function (t) {
        t.executeSql('SELECT COUNT(*) AS c FROM ' + test, [], function (t, r) {
            alert(r.rows[0].c + "rows")
            x= r.rows[0].c+"TableName"+test;
        });
    });
    return x
}

I replaced db.transaction with db.readTransaction, added a COUNT(*) AS c instead of * and so I replaced results.rows.length with r.rows[0].c. For more information, you can have a look to the W3C documentation.

edited Jul 20 '13 at 06:15

answered Jul 20 '13 at 06:06

Lucas Willems

6,673
4
28
45

can you help in this question also..!! http://stackoverflow.com/questions/17752946/need-example-of-synchronous-data-fetch-from-database-in-sqlite – Ravi Aaaaaa Jul 20 '13 at 06:08
I don't understand. I answered to your question... Why also ? – Lucas Willems Jul 20 '13 at 06:10
Because i have one more problem biggest problem in this url http://stackoverflow.com/questions/17752946/need-example-of-synchronous-data-fetch-from-database-in-sqlite.same problem – Ravi Aaaaaa Jul 20 '13 at 06:13
http://stackoverflow.com/questions/17752946/need-example-of-synchronous-data-fetch-from-database-in-sqlite – Ravi Aaaaaa Jul 20 '13 at 06:15
check again..!! i have same problem in this question – Ravi Aaaaaa Jul 20 '13 at 06:16
Thanks man..!! this is more tougher question but having same concept – Ravi Aaaaaa Jul 20 '13 at 06:19
can we add check functionality if "test" not exist in db? then return 0.? – Ravi Aaaaaa Jul 20 '13 at 06:34
Yes you can. http://stackoverflow.com/questions/1601151/how-do-i-check-in-sqlite-whether-a-table-exists But why do you unvalidate my answer ? – Lucas Willems Jul 20 '13 at 06:38
SELECT name FROM sqlite_master WHERE type='table' AND name='test' like this ? – Ravi Aaaaaa Jul 20 '13 at 06:44
Ok. I will try to answer to your ask too. – Lucas Willems Jul 20 '13 at 06:44
No no. The response under. This : create table if not exists TableName (col1 typ1, ..., colN typN) – Lucas Willems Jul 20 '13 at 06:45
i don't want to create i want to return zero if table not exist..in same question – Ravi Aaaaaa Jul 20 '13 at 06:46
Ok. And what is it happened if you select rows in table which doesn't exist ? – Lucas Willems Jul 20 '13 at 06:51
you are tell about second question ..?If you have any answer post there.I am asking about this question that if you have "test" undefined then what will happen we need to check this.. – Ravi Aaaaaa Jul 20 '13 at 06:54
if test is undefined i need to return zero – Ravi Aaaaaa Jul 20 '13 at 06:55
So, you can check if it returns undefined, and that is it you return 0. – Lucas Willems Jul 20 '13 at 06:57
please answer my second question..!! that was critical question – Ravi Aaaaaa Jul 20 '13 at 06:59

score 1 · Answer 3 · answered Jul 20 '13 at 06:20

1

You can use callBack function also..

function Test(test, callBack){
    var x;
    db.transaction(function (tx) {
            $yoursql = 'SELECT * FROM  "'+test+'" ';
            tx.executeSql($yoursql, [], function (tx, results) {
                x = results.rows.length  + "TableName" + test;
                callBack(x);                
            });
    });

}

Call function like this..

Test('users',function(result_count){
  alert(result_count);
});

answered Jul 20 '13 at 06:20

Sunil Dodiya

2,605
2
18
21

users is table name.? result_count number of element ? – Ravi Aaaaaa Jul 20 '13 at 06:25
is this apply on this question also .http://stackoverflow.com/questions/17752946/need-example-of-synchronous-data-fetch-from-database-in-sqlite – Ravi Aaaaaa Jul 20 '13 at 06:26
can we add check functionality if "test" not exist in db? then return 0.? – Ravi Aaaaaa Jul 20 '13 at 06:33
i don't do that i think by mistake it happen sorry ..where your answer gone..:(please paste again.. – Ravi Aaaaaa Jul 20 '13 at 06:42
http://stackoverflow.com/questions/17762679/why-the-value-i-increase-by-own-i-this-loop-while-fetching-the-data-from-sqlite – Ravi Aaaaaa Jul 20 '13 at 13:55
do you have any idea of this question? – Ravi Aaaaaa Jul 20 '13 at 14:04

score 0 · Answer 4 · answered Jan 24 '18 at 10:40

May use this

var dBase = null;
function devicereadyFun(){
    dBase = window.sqlitePlugin.openDatabase({
        name: 'test.db',
        location: 'default'
    });
}

document.addEventListener('deviceready', devicereadyFun, false);

function Test(test){
    dBase.executeSql("select count(*) as cut from "+test, [], function(rsp){
        alert('Rows count in '+test+': '+rsp.rows.item(0).cut);
    });
}

How to count the number of elements in table sqlite phonegap

4 Answers4