Hi I have some problem on nodejs to get data on mysql
My question is 'How can I add var n into "%drawing eye%" to get data on database?'
function showResult(req, res){
var n = req.query.query
mysql_conn.query('SELECT query_text FROM catalogsearch_query WHERE query_text LIKE "%drawing eye%" ORDER BY popularity DESC LIMIT 0 , 10', function(error, rows){
res.render('result.html',{result:n , related: rows.map(row => row.query_text)})
})
}
via Moomoo Soso
No comments:
Post a Comment