var multer = require('multer');
const path = require("path");
var storage = multer.diskStorage({
    destination: function (req, file, cb) {
      cb(null, "/public/uploads/thumb/");
    },
    filename: function (req, file, cb) {
      const ext = path.extname(file.originalname);
      cb(null, path.basename(file.originalname, ext) + "-" + Date.now() + ext);
    },
  });
  
var upload = multer({ storage: storage });

router.use(multipart({uploadDir: __dirname +'../../../public/uploads'}));

router.get('/create', controller.create);
router.post('/create', upload.single('thumb'), controller.createPost);

module.exports = router;

let createPost = function(req, res, next) {
    const body = req.body;
    querySnt = 'insert into gallery (title, writer, content, REG_DT, MOD_DT, thumbnail) values(?,?,?,now(),now(),?)';
    db.query(querySnt, [body.title, body.writer, body.content, Date.now(), Date.now(), req.files.thumb.path], (error) => {
        if(error) {
            console.log("error:",error);
        }
        res.send('create success');
    });
};

<form method="POST" enctype="multipart/form-data" action="/gallery/create">
    <label for="title">제목</label>
    <input type="text" id="title" name="title" required>

    <label for="writer">작성자</label>
    <input type="text" id="writer" name="writer" required>

    <label for="content">내용</label>
    <textarea name="content" id="content" cols="30" rows="10"></textarea>

    <label for="thumb">썸네일</label>
    <input type="file" name="thumb" id="thumb" accept="image/png, image/jpeg">

    <input type="submit" value="글쓰기" >
    
</form>

썸네일을 이미지 파일로 업로드 한 뒤 db에 저장하려고 합니다.

multer, mysql을 사용하고요..

근데 이렇게 하니 title값부터 받아오지 못하더군요

router.post('/create', upload.single('thumb'), controller.createPost);

이 코드에서 upload.single('thumb') 이 부분만 지우면 다른건 db에 저장이 됩니다.

어떤게 문제일까요..?

도와주세요..

0개의 답변

Q&A 목록