Create a search feature based on names utilizing Node Express in conjunction with SQL database

Question

Create a search feature based on names utilizing Node Express in conjunction with SQL database

After deciding to create an API with a search feature using SQL queries in node express, this is how I structured my code:

app.get('/search/:query', (req, res) => {
    pool.getConnection((err, connection) => {
        if(err) throw err
        console.log(`connected as id ${connection.threadId}`)

        search = req.query.search
        connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
            connection.release() // return the connection to pool

            if(!err) {
                res.send(rows)
            } else {
                console.log(err)
            }

        })
    })
})

When testing it on Postman, this is what my setup looked like: https://i.stack.imgur.com/wE1wm.png

The SQL query appears to be correct, but I am unsure how to properly implement the search routing in Node.

javascript sql express postman

Answer 1

Answer №1

If you want to extract path variables, use the following code snippet:

req.params.query

Here's an example of how you can implement this in your code:

app.get('/search/:query', (req, res) => {
    pool.getConnection((err, connection) => {
        if(err) throw err
        console.log(`connected as id ${connection.threadId}`)

        search = req.params.query
        connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
            connection.release() // return the connection to pool

            if(!err) {
                res.send(rows)
            } else {
                console.log(err)
            }

        })
    })
})

Answer 2

If you want to extract path variables, use the following code snippet:

req.params.query

Here's an example of how you can implement this in your code:

app.get('/search/:query', (req, res) => {
    pool.getConnection((err, connection) => {
        if(err) throw err
        console.log(`connected as id ${connection.threadId}`)

        search = req.params.query
        connection.query("SELECT * FROM beers WHERE name LIKE '%${search}%' ", (err, rows) => {
            connection.release() // return the connection to pool

            if(!err) {
                res.send(rows)
            } else {
                console.log(err)
            }

        })
    })
})

Answer 3

Answer №2

Give this a shot

app.get('/search', async function(req, res) {
    let page = req.query.page;
    let limit = req.query.limit;
    let search= req.query.q;
    //
    pool.getConnection((err, connection) => {
    if(err) throw err
    console.log(`connected as id ${connection.threadId}`)

    connection.query("SELECT * FROM books WHERE title LIKE '%${search}%' ", (err, rows) => {
        connection.release() // return the connection to pool

        if(!err) {
            res.send(rows)
        } else {
            console.log(err)
        }

    })
  })
});

Then access the api at http://localhost:5000/search?q=searchterm, and ensure to watch out for potential sql injection vulnerabilities.

Answer 4

Give this a shot

app.get('/search', async function(req, res) {
    let page = req.query.page;
    let limit = req.query.limit;
    let search= req.query.q;
    //
    pool.getConnection((err, connection) => {
    if(err) throw err
    console.log(`connected as id ${connection.threadId}`)

    connection.query("SELECT * FROM books WHERE title LIKE '%${search}%' ", (err, rows) => {
        connection.release() // return the connection to pool

        if(!err) {
            res.send(rows)
        } else {
            console.log(err)
        }

    })
  })
});

Then access the api at http://localhost:5000/search?q=searchterm, and ensure to watch out for potential sql injection vulnerabilities.

Create a search feature based on names utilizing Node Express in conjunction with SQL database

Answer №1

Answer №2

Similar questions

Adjusting images of various sizes within a single row to fit accordingly

CSS to target every second visible tr element using the :nth-child(2n)

The Jquery tooltip feature consistently displays the title of the header as the tooltip

Stop zombie.js from loading exclusively third-party resources

Guide for invoking a servlet via a navigation bar hyperlink and implementing a jQuery feature for smooth scrolling upon clicking

Whenever I make a move in the Towers of Hanoi javascript game, I always ensure that both towers are updated simultaneously

In vuex, dynamic modules share common data and do not have unique data

Achieving the functionality of making only one list item in the navbar bolded upon being clicked using React and Typescript logic

arranging data in various categories with React.js

What could be causing my SectionList to occasionally display only a single section?

Troubleshooting a Problem with JSON Array in JavaScript/jQuery - Understanding Undefined Values

Stop accidental form submissions on iOS devices by disabling the return button

Integrating a conditional statement into the existing for loop code to conceal the covers

"Having trouble with Node.js and ExpressJS where the req.files from Multer are coming

Best practices for outputting objects within an array using jQuery and JavaScript

Tips for getting information from firestore by implementing a where clause specific to a field within an object?

It appears that the SignalR proxy is not defined

There was an issue locating a declaration file for the module 'clarifai'

Is there a way to update an array within my class and access its updated output from outside the class?

No testing detected, ending with code zero - NPM and YARN