How to parse the data from "rows" object in node.js,express.js,mysql2

Question

I m using the node,express,mysql2 packages .When i m using console.log(rows) ,it is giving me following output:

[{"userid": "test","password": "test"}]

And here is my Code :

var application_root = __dirname,
express = require("express"),
mysql = require('mysql2');
path = require("path");
var app = express();

var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '123',
database: "bbsbec"
 });
app.configure(function () {
app.use(express.bodyParser());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(path.join(application_root, "public")));
app.use(express.errorHandler({ dumpExceptions: true, showStack: true }));
});

connection.query('SELECT * from pass', function(err, rows) {
     res.json(rows);
     console.log(rows);
   });

I just want to know that how can i parse this "rows" object so that i can retrive both userid and password .

TimWolla · Accepted Answer · 2020-06-21 10:11:46Z

28

[{"userid": "test","password": "test"}]

This is an Array of Objects. So: First loop over the array to get a single object and then extract its properties:

for (var i = 0; i < rows.length; i++) {
    var row = rows[i];
    console.log(row.userid);
}

edited Jun 21, 2020 at 10:11

answered Mar 13, 2014 at 14:58

TimWolla

32.9k8 gold badges67 silver badges97 bronze badges

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

Comments

Tobi · Accepted Answer · 2014-03-13 14:58:41Z

19

Try this (this is really basic):

   connection.query('SELECT * from pass', function(err, rows) {
     res.json(rows);

     var user = rows[0].userid;
     var password= rows[0].password;

   });

answered Mar 13, 2014 at 14:58

Tobi

31.5k9 gold badges61 silver badges92 bronze badges

1 Comment

Tobi Over a year ago

Remember that this only works with one row in the resultset. If there will be more, please use the second answer!

Gtm · Accepted Answer · 2019-08-30 09:12:52Z

1

 connection.query('SELECT * from pass', function(err, rows) {
      data = rows[0];
     let user = data.userid;
     let password= data.password;
     res.json(rows);

   });

answered Aug 30, 2019 at 9:12

Gtm

2634 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to parse the data from "rows" object in node.js,express.js,mysql2

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related