Untitled

app.post("/user", upload.single('file'), async (req, res, next) => {
  ty = req.body.ty
  console.log(ty)
  const file = req.file

  const allInfo = await getItems(req.file.originalname).then(pages => getAllInfo(pages))
  console.log(allInfo)
  console.log('AA')
  
  var sql = "INSERT INTO `files`( `file_name`,`author`,`subject`,`summary`,`year`,`project_name`,`keywords`,`mentor`,`jury`,`user_name`) VALUES (?,?,?,?,?,?,?,?,?,?)";
  connection.query(sql, [req.file.originalname,allInfo[2],allInfo[0],allInfo[3],allInfo[1],allInfo[4],allInfo[7],allInfo[5],allInfo[6],re], function (err, result) {
    if (err) {
      console.log("error")
    }
  })
  res.redirect('/user')
});