1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| exports.createPost = function (req, res, next){
//const imageUrl = `${req.protocol}://${req.get('host')}/images/${req.file.filename}`;
const idPost = req.params.idPost;
const username = req.body.username;
const title = req.body.Title;
const postUser = req.body.postUser;
//'INSERT INTO post username = ?, title = ?, postUser = ?',('${username}','${title}','${postUser}'
//INSERT INTO `post`(`idPost`, `username`, `Title`, `attachment`, `likes`, `dislike`, `postUser`) VALUES (NULL,username,Title,'','','',postUser)
// const insertSql = `'INSERT INTO post(idPost, username, title, attachment, likes, dislike, postUser)`',('','username','title','','','','postUser');
connection.query ('INSERT INTO post SET idPost = ?, username = ?, title = ?,postUser = ?' , [idPost,username,title,postUser],function (error, results, fields) {
if(results){
res.status(201).json
}else{
res.status(401).json({message: 'la publication à échoué !'})
}
})
} |
Partager