ExpressJs perform MySQL select query with ? parameters

Question

I'm new in the use ExpressJs, I created my own project to train myself. I would like to do a search bar so perform a select query with MySQL.

Here's my code :

let query = req.params.q;

console.log(query);

//var sql = "SELECT * FROM Movies WHERE movie_title like '%" + query + "%' OR movie_originalTitle like '%"+ query+"%'";

var sql = "SELECT * FROM Movies WHERE movie_originalTitle like ? OR movie_title like ?";
var values = [
    ['%' + query + '%', '%' + query + '%']
];

console.log(values[0]);

connection.query(sql, [values], (err, result, fields) => {
    console.log(sql);
    if (err) {
        throw err;
    };

    JSON.stringify(result);
    res.send({ movies: result });
});

I would like to do it with '?' parameter. I succeed to do it with one '?' but everytime I try to add the second parameter I got a MySQL Error

ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1

I don't know why the second '?' parameter throws me an error ...

Do I miss something ? Can anyone help me ? :)

Tim Biegeleisen · Accepted Answer · 2017-11-04 09:31:35Z

1

From what I have seen elsewhere, the second parameter should be an array containing the query parameters. You are passing this:

[values]

but values is already an array. Can you try passing values directly:

connection.query(sql, values, (err, result, fields) => {
    console.log(sql);
    if (err) {
        throw err;
    };

    JSON.stringify(result);
    res.send({ movies: result });
});

answered Nov 4, 2017 at 9:31

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hurobaki Over a year ago

Thank you that was my mistake ! It works perfect now !

Collectives™ on Stack Overflow

ExpressJs perform MySQL select query with ? parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related