Monday 1 May 2017

Assign variables to query mysql on NodeJS

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