Advertisement
Guest User

Untitled

a guest
Nov 20th, 2019
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. app.post('/search-result', function (req,res) {
  2.  
  3.  
  4. // saving data in database
  5. let sqlquery = "SELECT * FROM myBookshop.books WHERE name LIKE '%" + req.body.keyword + "%'";
  6.  
  7. // execute sql query
  8.  
  9.  
  10.  
  11. db.query(sqlquery, (err, result) => {
  12. if (err) {
  13. return console.error(err.message);
  14. }
  15. else
  16. res.send(JSON.stringify(result));
  17. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement