var mysql = require('mysql');

email = 'Mien@mail.nl';
var programmeur1 = 0;
var zaalbeheerder1 = 0;
var connection = mysql.createConnection({
    host:       'localhost',
    user:       'root',
    password:   '',
    port:       3306,
    database:   'inloggenv1_0'
});

connection.connect(function(err){
    if(err){
        console.error('error stack: '+err.stack);
        return;
    }
    console.log('verbinding');
});

connection.query('select rol from gebruikersrol as g where g.gebruiker=?', [email], function (err, results, fields){
        if(err){
            console.error('FOUT in gebruikersrol: ' + err.stack);
            throw err;
        } else{
            var rollen = [];
            for( var teller = 0; teller < results.length; teller++){
                rollen.push(results[teller].rol);

                for(var i = 0; i < rollen.length; ++i){
                if(rollen[i] == "Programmeur"){
                    zaalbeheerder1++;
                }
                }
            }


            }
            console.log(zaalbeheerder1);
            connection.end();
    });