how can i print data of array?

Question

Here are my codes:

app.get('/index/:name',function(req, res){
    data = connection.query('SELECT * FROM deneme', function(err, rows, fields){
        if(err) throw err;
        veri = rows;
        return veri;
    });

    console.log(data);

    res.render('index', {
        title: req.params.name,
        para: data
    });
});

When i call localhost:8080/index/example it returns [object Object] I want to print data of array, how can i do this?

I can do it when I'm using php with print_r() function..

Meantime, array's data:

Id Name
1  yab
2  sad

Nelson Benítez León · Accepted Answer · 2012-12-02 15:44:07Z

2

I think OP just want to print the data for debugging purposes, for that you can use the following cross-browser way that uses JSON to print a nice representation of the data:

console.log( JSON.stringify(data, null, 4) );

answered Dec 2, 2012 at 15:44

Nelson Benítez León

51k8 gold badges70 silver badges84 bronze badges

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

Comments

user447356 · Accepted Answer · 2012-12-02 15:37:20Z

0

Something like this should work:

for (var colName in data) {
    console.log("column " + colName);
    var rows = data[colName];
    for (var i = 0; i < rows.length; i++) {
        console.log(rows[i]);
    }
}

You will have to tweak it for your needs, that's the general way to iterate such objects.

answered Dec 2, 2012 at 15:37

user447356

Comments

Yogendra Singh · Accepted Answer · 2012-12-02 15:38:04Z

0

You need to iterate the result collection and print the attributes

      $.each(resultArray, function() {
             this.id;//use this to write id
             this.name;//use this to write name
       });

answered Dec 2, 2012 at 15:38

Yogendra Singh

34.5k7 gold badges66 silver badges73 bronze badges

1 Comment

Yogendra Singh Over a year ago

@user1870012 This is JQuery syntax.

Jimadilo · Accepted Answer · 2012-12-02 15:43:55Z

To output to the console you could do something like:

for(var index in data) {
    var item = data[index];
    var output = [];
    for(var field in item) {
        output.push(item[field]);
    }
    console.log(output.join("\t"));
}

For outputting in html, you'd do something like similar, but creating actual HTML nodes. Maybe, something like:

var output = ["<table>"];
for(var index in data) {
    output.push("<tr>");
    var item = data[index];
    for(var field in item) {
        output.push("<td>");
        output.push(item[field]);
        output.push("</td>");
    }
    output.push("</tr>");
    console.log(output.join("\t"));
}
output.push("</table>");
element.innerHTML = output.join("");

I've not tried that in a browser, so there might be a couple of mistakes, but that should do it.

Let me know if you'd like any more help.

Collectives™ on Stack Overflow

how can i print data of array?

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related