在nodejs中,有一个使用multi上传图片的文件。我想把mysql中的这个图像路径打印到客户端view.But,我不知道该怎么办。请让我知道。
控制器
export const getBoardCreate = (req, res) =>
res.render("boardCreate", {
homeName: "watchingame",
pageName: "boardCreate",
routers
});
export const postBoardCreate = (req, res) => {
try {
let sql =
"insert into board(folder,title,content, nicName,writeDate,views,comments) values(?,?,?,1,now(),0,0)";
dbConnection.query(
sql,
[req.body.folder, req.body.title, req.body.content],
(err, result) => {
if (err) {
console.log(err);
} else {
const {
body: { folder, title, content },
file
} = req;
console.log(file);
}
}
);
res.redirect(`/board${routers.boardDetail(result.insertId)}`);
} catch (err) {
console.log(err);
}
};视图
extends layouts/layout
block content
form(method="post" action=`/board${routers.boardCreate}` enctype="multipart/form-data")
select(name="folder")
option(value="select") select
option(value="wg") ~
option(value="news") ~
input(type="text" name="title" placeholder="title" required=true)
textarea(name="content" rows="20" cols="100%" required=true)
input(type="file" name="pictureFile" required=true accept="image/*")
input(type="submit" value="submit")发布于 2019-06-20 13:02:01
使用multer npm软件包,它会将文件存储在本地文件夹中,并返回路径,您可以将该路径存储在MySQL数据库中
https://stackoverflow.com/questions/56679202
复制相似问题