const expres = require('express');
const mysql = require('mysql');
const app = expres();

var connection = mysql.createConnection({
host: "localhost",
user: "root",
password: "",
database: "sistemizin"
});
console.log("Connected!");

app.set('view engine', 'hbs'); app.use(expres.static('publik'));

app.get('/', (req, res) => {
res.render('cobaview');
});

app.post('/', (req, res) => {
    var contoh = `SELECT namamatkul FROM matkul_dosen WHERE       idmatkuldosen = 70`;
    connection.query(contoh, (err, results, fields) => {
    if (err) {
        return console.error(err.message);
    }
    console.log('Results counted:' + results.affectedRows);
    });
    connection.end();
    res.end();
});

 app.listen(8084);
 console.log("server is running at http://127.0.0.1:8084/");