Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var router = express.Router();
- router.get('/', function(req, res) {
- // Establish Connection with Database
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host : '127.0.0.1',
- user : 'root',
- password : 'xxxxxxx',
- database : 'my_db'
- });
- connection.connect();
- // // Query and post result to console
- connection.query('SELECT * FROM products', function(error, results, fields) {
- if (error) throw error;
- doSomething(results[0]);
- });
- connection.end();
- var finalResult = ['hello'];
- function doSomething(results) {
- console.log(results.name);
- finalResult.push(results.name);
- }
- console.log(finalResult);
- // Render/make accessible to views
- res.render('index', {
- pageTitle: 'Home',
- result: finalResult
- });
- });
- module.exports = router;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement