Node MySQL Express to Json
我有一个带有INNER JOIN的mySQL查询,我想与Handlebars一起使用,尽管它是单返回,但它仍然返回多结果,因为图像表包含更多结果。
如何返回单个结果,然后将图像放在单独的json字符串中?
这里是查询:
app.get("/car/:brand-:model-:id", function (req, res) {
let userName;
if (req.user != undefined) {
userName = req.user.displayName;
}
const carSql = `SELECT * FROM cars INNER JOIN carimage ON cars.id = carimage.carId WHERE carimage.carId = ${req.params.id}`;
const carQuery = db.query(carSql, (err, results) => {
if (err) throw err;
const data = {
car: results,
username: userName
}
//res.render("pages/car", data);
res.send(data);
});
});
回答如下:app.get("/car/:brand-:model-:id", function (req, res) {
let userName;
if (req.user != undefined) {
userName = req.user.displayName;
}
const carSql = `SELECT * FROM cars WHERE car.id = ${req.params.id}`;
const carQuery = db.query(carSql, (err, car) => {
if (err) throw err;
const imagesSql = `SELECT * FROM carimage WHERE carimage.carId = ${req.params.id}`;
const imageQuery = db.query(carSql, (err, results) => {
if (err) throw err;
const data = {
car: car[0],
images: results,
username: userName
}
res.send(data);
});
});
});
与本文相关的文章
评论列表(0)
- 暂无评论