| 12
 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;
        }
    }); |