Server 연결 전체 JS 구문

require('dotenv').config();

const express = require('express');
const nunjucks = require('nunjucks');
const bodyParser = require('body-parser');
const mysql = require('mysql');

const app = express();

const port = process.env.SERVER_PORT;

 

app.set('veiw engine','html');

 

app.use(bodyParser.urlencoded({extended:false}));

nunjucks.configure('views',{
    express:app,
    autoescape:true,
});

let connection = mysql.createConnection({
    host:'localhost',
    user:'root',
    password:'root',
    database:'ingoo',
});

connection.connect();

app.get('/',(req,res)=>{

connection.query("select * from user",(error,results) => {

if (error) {

//error가 생기면 이쪽 실행

console.log(error);

}else{

//error가 안생기면 이쪽 실행

console.log(results);

//결과값 배열형태 객체

results.forEach(ele=>{

console.log(ele.userid,ele,userpw,ele.username);

)};

}

})

res.render('index.html',{

name:'ingoo',