Node.js mysql access column

Question

var authUser = function (email, password) { connection.connect(); var query = connection.query("SELECT * FROM users_admin WHERE email='"+email+"' and user_password='"+password+"'", function (error, result) { if (error) { throw error } else { setValue(result); } }); connection.end(function (error) { if (error) throw error; }); } function setValue(value) { someVar = value; console.log(someVar); }

The result displays as needed:

 [ RowDataPacket { id: 1, user_name: 'qwerty', user_surname: 'qwerty', user_password: 'qwerty', number_phone: 'qwerty', email: 'qwerty' } ]

How do I refer to a specific field? If I write console.log (someVar ['user_name']), it writes undefined.

Perfecto Web Perfecto Web 625 2 15 · Accepted Answer · 2018-07-23T18:01:49

As an example, you can study this piece of code:

 /*----------------------------------------------------------------- | MySQL Connect ------------------------------------------------------------------*/ var mysql = require('mysql'); var connection = mysql.createConnection({ host : my_host, user : my_user, password : my_password, database : my_dbname, port : 3306, }); /*----------------------------------------------------------------- | Query ------------------------------------------------------------------*/ var login; connection.query('SELECT `login` FROM `users` WHERE `id`="1" ', function (error, rows) { for(i in rows) { login = rows[i].login; } });

Node.js mysql access column

1 answer 1

More articles: