1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
   |  
function countRows(cb) {
        db.transaction(function (tx) {
            tx.executeSql('SELECT id FROM T_Photo', [], function (tx, results)
            {
                var len = results.rows.length;
                cb.call(this, len);
            });
        });
    }
    countRows(function (num)
    {
        switch (num)
        {
            case 1:
                {
                    db.transaction(function (tx)
                    {
                        tx.executeSql(SqlAffPhoto1, undefined, function (tx, result)
                        {
                            if (result.rows.length > 0)
                            {
                                for (var i = 0; i < result.rows.length; i++)
                                {
                                    var row = result.rows.item(i);
                                    var photo = row.PhotoBlob;
                                    $('#Mod_PhotoProfil').attr('src', photo);
                                }
                            }
                        }, erreur_bd);
                    });
                }
                break;
            case 2:
                {
                    db.transaction(function (tx)
                    {
                        tx.executeSql(SqlAffPhoto2, undefined, function (tx, result)
                        {
                            if (result.rows.length > 0)
                            {
                                for (var i = 0; i < result.rows.length; i++)
                                {
                                    var row = result.rows.item(i);
                                    var photo = row.PhotoBlob;
                                    $('#Mod_PhotoProfil').attr('src', photo);
                                }
                            }
                        }, erreur_bd);
                    });
                }
                break;
            default:
                {
                    console.log("Photo inexistante");
                }
                break;
        }
    }); | 
Partager