'throw err; ReferenceError: document is not defined

Router page

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

    /* GET home page */
    router.get('/', function(req, res, next) {
        res.render('mysql', {
            title: '',
        });
    });

    var connection = mysql.createConnection({
        host : '',
        user : '',
        password : '',
        database : ''
    });

    connection.connect();        
    connection.query('SELECT hashtag from recipients', function(err, rows, fields) {
      if (!err) {
        console.log(rows);        
            document.getElementById('recipients').innerHTML = rows;        
    }
      else {
        console.log('Error while performing Query.');
    }

    });        
    connection.end();        
    module.exports = router;

Views page

<html>
<head>

</head>
<body>
<p id='recipients'></p>
<p id='error'></p>

<script>
</script>

</body>

Solution 1:^[1]

// db.js
var connection = mysql.createConnection({
    host : '',
    user : '',
    password : '',
    database : ''
});
connection.connect();
module.exports = connection;

...
// router.js
var db = require('db.js')

router.get('/', function(req, res, next) {
    db.query('SELECT hashtag from recipients', function(err, rows, fields) {
        if (err) {
            return next(err); // or res.send(err.message);

        res.render('mysql.html', {
            title: '',
            recipients : rows   
        });
    }); 
});

module.exports = router;

// mysql.html
<html>
<head>
    <title>{{title}}</title>
</head>
<body>
    {{recipients}}
</body>
</html>

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Aikon Mogwai

'throw err; ReferenceError: document is not defined

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]