创建一个使用Node Express + SQL的按名称搜索功能。

huangapple
go评论96阅读模式
英文:

Make a search function by name using Node Express + SQL

问题

以下是您提供的代码的翻译部分：

  1. // 搜索啤酒
  2. app.get('/search/:query', (req, res) => {
  3.     pool.getConnection((err, connection) => {
  4.         if(err) throw err
  5.         console.log(`连接成功，ID为 ${connection.threadId}`)
  7.         search = req.query.search
  8.         connection.query("SELECT * FROM beers WHERE name LIKE ?", [`%${search}%`], (err, rows) => {
  9.             connection.release() // 将连接返回到连接池
  11.             if(!err) {
  12.                 res.send(rows)
  13.             } else {
  14.                 console.log(err)
  15.             }
  17.         })
  18.     })
  19. })

这是您的代码的翻译部分。如果您需要任何进一步的帮助，请随时提出。

英文:

So i wanted to make an API with a search function with SQL queries using node express, this is what my code looked like:

  1. app.get('/search/:query', (req, res) => {
  2.     pool.getConnection((err, connection) => {
  3.         if(err) throw err
  4.         console.log(`connected as id ${connection.threadId}`)
  6.         search = req.query.search
  7.         connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
  8.             connection.release() // return the connection to pool
  10.             if(!err) {
  11.                 res.send(rows)
  12.             } else {
  13.                 console.log(err)
  14.             }
  16.         })
  17.     })
  18. })

And this is how my postman looked:
创建一个使用Node Express + SQL的按名称搜索功能。

The SQL query is correct but I dont know how to make the search routing in Node

答案1

得分: 1

  1. 你可以尝试这样做
  3. app.get('/search', async function(req, res) {
  4.     let page = req.query.page;
  5.     let limit = req.query.limit;
  6.     let search = req.query.q;
  7.     //
  8.     pool.getConnection((err, connection) => {
  9.         if (err) throw err
  10.         console.log(`connected as id ${connection.threadId}`)
  12.         connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
  13.             connection.release() // return the connection to pool
  15.             if (!err) {
  16.                 res.send(rows)
  17.             } else {
  18.                 console.log(err)
  19.             }
  20.         })
  21.     })
  22. });
  24. 并且像这样调用API http://localhost:5000/search?q=yoursearchterm，还要检查可能的SQL注入问题。
英文:

You can try this

  1. app.get('/search', async function(req, res) {
  2.     let page = req.query.page;
  3.     let limit = req.query.limit;
  4.     let search= req.query.q;
  5.     //
  6.     pool.getConnection((err, connection) => {
  7.     if(err) throw err
  8.     console.log(`connected as id ${connection.threadId}`)
  10.     connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
  11.         connection.release() // return the connection to pool
  13.         if(!err) {
  14.             res.send(rows)
  15.         } else {
  16.             console.log(err)
  17.         }
  19.     })
  20.   })
  21. });

and call api like this http://localhost:5000/search?q=yoursearchterm, also check for possible sql injection issue.

答案2

得分: 1

你可以通过以下方式从路径变量中获取参数：

  1. req.params.query

这样你的代码会像这样：

  1. app.get('/search/:query', (req, res) => {
  2.     pool.getConnection((err, connection) => {
  3.         if (err) throw err
  4.         console.log(`connected as id ${connection.threadId}`)
  6.         search = req.params.query
  7.         connection.query("SELECT * FROM beers WHERE name LIKE ?", [`%${search}%`], (err, rows) => {
  8.             connection.release() // 将连接返回到池中
  10.             if (!err) {
  11.                 res.send(rows)
  12.             } else {
  13.                 console.log(err)
  14.             }
  16.         })
  17.     })
  18. })
英文:

You can get the parameter from path variables by this

  1. req.params.query

so your code will be like this

  1. app.get('/search/:query', (req, res) => {
  2.     pool.getConnection((err, connection) => {
  3.         if(err) throw err
  4.         console.log(`connected as id ${connection.threadId}`)
  6.         search = req.params.query
  7.         connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
  8.             connection.release() // return the connection to pool
  10.             if(!err) {
  11.                 res.send(rows)
  12.             } else {
  13.                 console.log(err)
  14.             }
  16.         })
  17.     })
  18. })

huangapple
  • 本文由 发表于 2023年6月12日 19:56:27
  • 转载请务必保留本文链接：https://go.coder-hub.com/76456427.html
  • express
  • javascript
  • postman
  • sql
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定