error in sql syntax mysql node js?

Question

 { Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''mom12345'' at line 1}

I am trying to write a log in query in mysql using node js but for some reason, I keep getting the above error. Kindly can anyone assist me.

var logininfo={
username:username,
password:password

};
con.query('SELECT id FROM userinfo WHERE username=? and password ?',logininfo, function (error, results, fields) {
            if (error) {
                console.log("error ocurred",error);

            } else {
                console.log('The solution is: ', results);
                if (results.length > 0) {
                    if ([0].password == password) {
                       console.log("Login Successful");

                    }
                    else {
                        console.log("Username and password donot match");
                    }
                }
            }
        })

    }

Jaydip Jadhav · Accepted Answer · 2017-07-03 08:15:08Z

1

You forgot equal to sign

WHERE username=? and password = ?
                           ---^

answered Jul 3, 2017 at 8:15

Jaydip Jadhav

12.3k6 gold badges26 silver badges41 bronze badges

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

Comments

SPlatten · Accepted Answer · 2017-07-03 08:18:50Z

0

Your second parameter should be an array of parameters not an object.

So change:

    var logininfo={
    username:username,
    password:password
    };

To:

    var logininfo=[
    username,
    password
    ];

answered Jul 3, 2017 at 8:18

SPlatten

5,85913 gold badges79 silver badges140 bronze badges

Collectives™ on Stack Overflow

error in sql syntax mysql node js?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related