mysql로 node.js 연동할때 req.body.id 값을 못 가져옵니다.

server.js

const express =require('express');
const app = express();
app.use('/public', express.static('public'))

const bodyParser= require('body-parser');

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

app.set('view engine', 'ejs');

const passport = require('passport');
const LocalStrategy = require('passport-local').Strategy;

const mysql = require('mysql2');
const methodOverride = require('method-override');
app.use(methodOverride('_method'));

const connection = mysql.createConnection({
host : 'localhost',  
user : 'root',
password : '*****8',
database : 'moonserver'
});

var session = require("express-session");
var MySQLStore = require('express-mysql-session')(session);
app.use(
  session({
    secret: 'g#1234!@#$asd',
    resave: false,
    saveUninitialized: true,
    store:new MySQLStore({
      host:'localhost',
      port:3306,
      user:'root',
      password:'*****',
      database:'moonserver'
    })
  })
);

app.use(passport.initialize());
app.use(passport.session());

server.js
app.get('/write',function(req, res){
  var id= parseInt(req.body.id);
  console.log(id);
  var sql = 'SELECT id, title, content FROM post WHERE id=?';
  connection.query(sql,[id],function(err,topics){
    console.log(topics);
    res.render('write.ejs',{posts : topics});
  })
})

app.post('/add', function(req, res){
  var id= parseInt(req.body.id);
  console.log(id);
  var title = req.body.title;
  var content = req.body.content;
  var numberid = 1;
  var sql = 'INSERT INTO post (id, title, content, numberid) VALUES(?, ?, ?, ?)';
  connection.query(sql, [[id], title, content, numberid], function(err, result){
    if(err)
    {
      console.log(err);
      res.status(500).send('Internal Server Error');
    }
    else
    {
      var sql = 'UPDATE count SET totalpost = totalpost +1';
      connection.query(sql,function(err,good){
        if(err)
        {
          console.log(err);
          res.status(500).send('Internal Server Error');
        }
        else
        {
          res.render('index.ejs',{posts : result});
        }
      })
    }
  })
})
write.ejs
<form action="/add" method="POST">
                
                <input value="<%= posts.id %>" name="id" style="display : none;">
                <label>제목</label>
                <input type="text" class="form-control" name="title" style="width: 770px;">
                <label>내용</label>
                <input type="text" class="form-control wow" name="content" style="width: 770px;">
                <button type="submit" class="btn btn-primary">Primary</button>
            </form>



에러
eferenceError: C:\Users\atolo\Desktop\server\node\views\write.ejs:28
26| <form action="/add" method="POST">
27|
>> 28| <input value="<%= posts.id %>" name="id" style="display : none">
29| <label>제목</label>
30| <input type="text" class="form-control" name="title" style="width: 770px;">
31| <label>내용</label>
posts is not defined


글 post 할때 글 번호 id값을 꼭 받고싶습니다
도대체 왜 req.body.id 가 안받아지는지 모르겠씁니다

새글 발행할시 req.body.id 는 무슨일이 있어도 받을수없는건가요?
지금 mysql FOREIGN KET 추가 해서 post.numberid 에 login.id 를 연결시키고싶습니다 


server.js
app.post('/add', function(req, res){
  var sql2='SELECT * FROM post INNER JOIN login ON id=numberid';
  connection.query(sql2, function(err, posts){
  console.log(posts);
  var title = req.body.title;
  var content = req.body.content;
  var numberid = parseInt(req.body.id);
  console.log(numberid);
  var sql = 'INSERT INTO post (title, content, numberid) VALUES(?, ?, ?)';
  connection.query(sql, [title, content, numberid], function(err, result){
    if(err)
    {
      console.log(err);
      res.status(500).send('Internal Server Error');
    }
    else
    {
      var sql = 'UPDATE count SET totalpost = totalpost +1';
      connection.query(sql,function(err,good){
        if(err)
        {
          console.log(err);
          res.status(500).send('Internal Server Error');
        }
        else
        {
          res.render('index.ejs',{posts : result});
        }
      })
    }
  })
})
})
write.ejs
 <form action="/add" method="POST">
                
                <input value="<%= posts.id %>" name="id" style="display : none;">
                <label>제목</label>
                <input type="text" class="form-control kim" name="title" style="width: 770px;">
                <label>내용</label>
                <input type="text" class="form-control wow" name="content" style="width: 770px;">
                <button type="submit" class="btn btn-primary">Primary</button>
            </form>

에러

ReferenceError: C:\Users\atolo\Desktop\server\node\views\write.ejs:28
    26|             <form action="/add" method="POST">
    27|
 >> 28|                 <input value="<%= posts.id %>" name="id" style="display : none;">
    29|                 <label>제목</label>
    30|                 <input type="text" class="form-control kim" name="title" style="width: 770px;">
    31|                 <label>내용</label>

posts is not defined

req.body.id 를 받아와야 numberid 값에 id를 넣고싶은데
req.body.id 를 못받아와서 지금 몇시간째 삽질만 하는중입니다. ㅠㅠ
생각해보니 app.post에서 id값 가져오는건 의미가 없겠네요
Mysql 결제해서 강의들었는데 서버쪽의 예시가 별로없어서 좀 헷갈리네요
post.numberid 에 login.id 값을 넣을 방법이 뭐가있을까요?

server.js
app.post('/add', function(req, res){
  var sql2= 'SELECT * FROM post INNER JOIN login ON id=numberid';
  connection.query(sql2, function(err, result){
  var title = req.body.title;
  var content = req.body.content;
  var numberid = req.user.id;
  console.log(numberid);
  var sql = 'INSERT INTO post (title, content, numberid) VALUES(?, ?, ?)';
  connection.query(sql, [title, content, numberid], function(err, result2){
    if(err)
    {
      console.log(err);
      res.status(500).send('Internal Server Error');
    }
    else
    {
      var sql = 'UPDATE count SET totalpost = totalpost +1';
      connection.query(sql,function(err,good){
        if(err)
        {
          console.log(err);
          res.status(500).send('Internal Server Error');
        }
        else
        {
          res.render('index.ejs',{posts : result});
        }
      })
    }
  })
})
})
에러
undefined
Error: Column 'numberid' cannot be null


일단 로그인 회원가입 로그아웃은 기능 잘됩니다
근데 왜 req.user 가 undefined 값을 못 받을까요
참고로 app app.post('/add', function(req, res){ 
는 passport 설정 아래에다 작성했습니다

passport 설정 문제인가요?