mysql保存没有斜杠的图像路径nodejs

Question

大家好，我正试图在mysql数据库中保存图像路径，但数据库保存的路径没有像这样的斜杠

image: 'publicimagesIMG-1610544689539.jpg'

我从结果中复制了它，但查询不包含任何问题！

INSERT INTO product (category,name,image,unit,price,stok,produce,end) VALUES ("Pastry" , "test" , "publicimagesIMG-1610544689539.jpg" , "Kilo" , "80" , "100" , "2021-01-06","2021-01-15")

我的代码只保存值，而不编辑中的任何内容

newProduct.post('/new' , upload.single('image') , async (req , res)=>{
if(!req.file){
res.redirect('/web')
}
const db = await newDB.connection()
let query = `INSERT INTO product (category,name,image,unit,price,stok,produce,end) VALUES ("${req.body.category}" , "${req.body.name}" , "${req.file.path}" , "${req.body.unit}" , "${req.body.price}" , "${req.body.stok}" , "${req.body.produce}" , "${req.body.end}")`
db.query(query)
res.redirect('/web');

})

连接代码。。

const pool = mysql.createPool(dbConfig);

const connection = () => {

return new Promise((resolve, reject) => {
pool.getConnection((err, connection) => {
if (err) reject(err);
console.log("MySQL pool connected: threadId " + connection.threadId);
const query = (sql, binding) => {
return new Promise((resolve, reject) => {
connection.query(sql, binding, (err, result) => {
if (err) reject(err);
resolve(result);
});
});
};
const release = () => {
return new Promise((resolve, reject) => {
if (err) reject(err);
console.log("MySQL pool released: threadId " + connection.threadId);
resolve(connection.release());
});
};
resolve({ query, release });
});
});
};
const query = (sql, binding) => {
return new Promise((resolve, reject) => {
pool.query(sql, binding, (err, result, fields) => {
if (err) reject(err);
resolve(result);
});
});
};

module.exports = { pool, connection, query };

谢谢

Answer 1

不使用单个斜杠"你可以尝试使用双斜线"\&"；。这可以通过在保存路径之前执行以下操作来实现：

let path = req.file.path
path = path.replace("", "\")
const db = await newDB.connection()
let query = `INSERT INTO product (category,name,image,unit,price,stok,produce,end) VALUES ("${req.body.category}" , "${req.body.name}" , "${path}" , "${req.body.unit}" , "${req.body.price}" , "${req.body.stok}" , "${req.body.produce}" , "${req.body.end}")`