Запуск функций на загружаемой странице, но они не работают [закрыто]

    
     `let db = new sqlite3.Database('mcm');
     db.exec('CREATE TABLE IF NOT EXISTS workers(id INTEGER PRIMARY KEY,names VARCHAR(30) NOT NULL,position VARCHAR(30) NOT NULL,date VARCHAR(10) NOT NULL,salary INTEGER)');
     function insertValues() {
        const name = document.getElementById('addName');
        const Nposition = document.getElementById('addPosition');
        const startDate = document.getElementById('addStartDate');
        const Nsalary = document.getElementById('addSalary');
        db.exec('CREATE TABLE IF NOT EXISTS workers(id INTEGER PRIMARY KEY,names VARCHAR(30) NOT NULL,position VARCHAR(30) NOT NULL,date VARCHAR(10) NOT NULL,salary INTEGER)');
        db.exec('INSERT INTO workers (id,names,position,date,salary) VALUES (NULL,?,?,?,?)', [name,Nposition,startDate,Nsalary]);
     }
     function myFunction2(num) {
        var fName = db.exec("SELECT names FROM workers WHERE id = num");
        var fPosition = db.exec("SELECT position FROM workers WHERE id = num");
        var fStartDate = db.exec("SELECT date FROM workers WHERE id = num");
        var fSalary = db.exec("SELECT salary FROM workers WHERE id = num");
        var inputF1 = document.getElementById("addName");
        var inputF2 = document.getElementById("addPosition");
        var inputF3 = document.getElementById("addStartDate");
        var inputF4 = document.getElementById("addSalary");
        function gfg_Run(Gname,Gposition,Gdate,Gsalary) {
            inputF1.value = Gname;
            inputF2.value = Gposition;
            inputF3.value = Gdate;
            inputF4.value = Gsalary;
            window.onload = function() {
                var button = document.getElementById('addRowButton');
                button.form.submit();
        }
     }
     function called() {
        alert('ok');
        var number = db.exec("SELECT COUNT(DISTINCT c) FROM workers");
        for (i = 0; number; i++){
            myFunction2(i+1);
        }
     }
     db.close();
     window.onload = called;`

Вернуться на верх