87,907
社区成员
发帖
与我相关
我的任务
分享
var query_sql = function(req, res, next) {
sql = 'SELECT gid,name,price,create_time,describes,selluid FROM goods WHERE status=? LIMIT ?,?';
connection.query(sql, [0,0,6], function(err, rows, fields) {
if (err) throw err;
for(var i=0;i<rows.length;i++){
sql = "SELECT tag_name FROM tag,tag_goods WHERE tag_goods.gid=? AND tag_goods.tagid=tag.tagid";
(function(rows, i){
connection.query(sql, rows[i].gid, function(err, rows2, fields){
if (err) throw err;
rows[i].tags = rows2;
rows[i].price = one.price / 100;
})});
}
console.log(rows);
next();
});
};
var async = require('async');
var send_data = function(req,res){
sql = 'SELECT gid,name,image_url,price,create_time,describes,selluid FROM goods WHERE status=? LIMIT ?,?';
connection.query(sql, [0,0,6], function(err, rows, fields) {
if (err) throw err;
async.map(rows, function(item, callback) {
sql = "SELECT tag_name FROM tag,tag_goods WHERE tag_goods.gid=? AND tag_goods.tagid=tag.tagid";
connection.query(sql, item.gid, function(err, tags, fields){
item.tags = tags;
callback(null, item);
});
}, function(err,results) {
res.render('index', {supplies:results, login:req.session.login});
});
});
};