var my = require('mysql');
var d = '';
var md = function (tt, cb) {
    var bg = my.createConnection({host: "192.168.99.100", user: "root", password: "12345", database: "vt"});
    d = '';
    var q = bg.query("select*from icerik");
    q.on('result', function (r) {
            d += r["baslik"];
        })
        .on('end', function () {
            cb(false, d)
        })
        .on('error', function (err) {
            cb(err, false);
        });
};
module.exports.fnk = md;


var express = require('express');
var router = express.Router();
var f = require('./md');

router.get('/:id', function (req, res, next) {

    f.fnk('test', function (err, result) {
        if (err) {
            console.error('Error occurred: ', err);
            res.render('500', {err: err});
        } else {
            res.render('index', {title: result});
        }
    });

});
module.exports = router;