Json object access in Node server

Question

I am new to Node server. In my program I fetched some data from data base as

connection.query("SELECT * from login where username='" + uname + "' and password='" + pwd + "' ", [uname, pwd], function (err, rows)
    {
        var employees = (JSON.stringify(rows));
        console.log("Inside server "+employees  )
    });

Now in console i got some thing like

[{"user_id":7,"username":"vb","password":"vbv"}]

Now my Question is how i could get the value username from employees. I have tried few things like employees[0]["username"] OR employees.username etc..

Tuan Anh Tran · Accepted Answer · 2015-11-30 09:53:51Z

1

Because you stringify it, it becomes string so you can't access like that. Just use it as is.

answered Nov 30, 2015 at 9:53

Tuan Anh Tran

7,2797 gold badges39 silver badges57 bronze badges

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

Comments

Cyrbil · Accepted Answer · 2015-11-30 09:54:33Z

0

JSON.stringify(rows) only allow you to pretty print the data.

To access it you were right with employees[0]["username"]

connection.query("SELECT * from login where username='" + uname + "' and password='" + pwd + "' ", [uname, pwd], function (err, employees)
    {
        console.log("Inside server " + JSON.stringify(employees));
        console.log('Employee 1: ' + employees[0]["username"]);
    });

answered Nov 30, 2015 at 9:54

Cyrbil

6,5081 gold badge27 silver badges42 bronze badges

Collectives™ on Stack Overflow

Json object access in Node server

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