var express = require('express'); 
 
var router = express.Router(); 
 
var mysql = require('mysql'); 
 

 
var con = mysql.createConnection({ 
 
    host: "localhost", 
 
    user: "honolulu", 
 
    password: "honolulu", 
 
    database: "db" 
 
}); 
 

 

 
con.connect(function(err) { 
 
    if (err) throw err; 
 
    console.log("Connected to question database file 1!"); 
 
}); 
 
var but=20 
 
con.query('select count(*) from qpsc',function (err, result) { 
 
    if (err) throw err; 
 
    but=result; 
 
    console.log(but); 
 
    }); 
 
/* GET home page. */ 
 
router.get('/', function(req, res, next) { 
 
    res.render('index', { title: 'Express' }); 
 
}); 
 
router.get('/file', function(req, res, next) { 
 
    res.render('index2',{ num_buttons: '20'}); 
 
    // console.log("RENDERED FROM INDEX.js"); 
 
}); 
 

 
module.exports = router;