var postObjc = JSON.parse(postData);
var userSql = "SELECT * FROM user_cart WHERE product_id=" + postObjc.product_id + " AND cart_sku=" + `"${postObjc.cart_sku}"`
console.log(userSql)
// SELECT * FROM user_cart WHERE user_id=2 LIMIT 0,10
db.query(userSql, function(error, results, fileds) {
if (error) throw error;
res.writeHead(200, {
"Content-Type": "text/json;chartset=utf-8"
})
console.log(results.length)
successData.data = results
res.end(JSON.stringify(successData))
})
nodejs连接数据库,根据id和sku查询数据库
最新推荐文章于 2024-10-02 12:42:27 发布