[Node.js] jQuery로 ajax 활용
function cartCheck() {
var cnum = $('#cartNum').val();
var uid = '<%=loginUser.userid%>';
$.ajax({
type: 'get',
url: "/cartCheck?userid=" + uid,
dataType: 'json',
cache: false,
success: function (res) {
console.log(JSON.stringify(res));
console.log(res.cartNum);
$('#cartNum').text(res.cartNum);
}, error: function (err) {
alert('error: ' + err.status);
}
})
}
///////////////////////////
exports.cartCheck = function (data, req, res) {
db.getConnection(dbconfig, (err, con) => {
if (err) throw err;
var sql = 'select count(userid) from cart where userid=:userid';
con.execute(sql, data, (err, result) => {
if (err) throw err;
con.close((err) => {
if (err) throw err;
// console.dir(result);
var n = result.rows.length;
var obj = {};
if (n > 0) {
// console.dir(result.rows);
obj.cartNum = result.rows;
} else {
obj.cartNum = 0;
}
res.json(obj)
})
})
})
}