Nodejs with Mysql Database

Question

I'm using nodejs with MySQL for the first time , I'm struggling to properly preparing statements ,I have no problems when writing and executing some insertion statements but when i tried to write the selection statements i can't know what is the correct syntax .I can't find tutorial for the beginner This is the selection code

io.sockets.on('connection', function(client) {  
client.on('check_id', function(login_feilds) {

     console.log(login_feilds);

     var login_feilds_as_json = login_feilds ,
      Email = login_feilds_as_json.email ,
      password = login_feilds_as_json.password ;
    var sql = "SELECT * FROM ?? WHERE ?? = ? AND ?? = ?";
     var inserts = ['users', 'email', Email,'password',password];
            sql = mysql.format(sql, inserts);
                 console.log(sql);


  connection.query( sql , function(err, rows){
     if(error){

      console.log(error.message);
    }else{
      console.log('found it'); };

  });

}); 
});

when I run the above code I got this

{ email: '[email protected]', password: 'user' }
SELECT * FROM `users` WHERE `email` = '[email protected]' AND `password` =
 'user'

C:\Users\jiil\Desktop\our-project\node_modules\mysql\lib\protocol\Parser.js:82
        throw err;
              ^
ReferenceError: error is not defined

could you help me to figure out what i have to do or give me any good resources' links .

Naing Lin Aung · Accepted Answer · 2015-03-31 06:19:49Z

3

The problem is that you wrongly use variable name in your callback function. You need to change error to err.

connection.query(sql, function(err, rows){
    if (err) {  
      console.log(err.message);
    } else {
      console.log('found it'); 
    } 
  });

Hope it will be useful for you.

edited Mar 31, 2015 at 6:19

Naing Lin Aung

3,4404 gold badges34 silver badges51 bronze badges

answered Mar 24, 2015 at 5:14

Arkar Aung

3,5841 gold badge19 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Nodejs with Mysql Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related