How to display mysql query result in html table in nodejs?

Question

Following is an example of a query result in Nodejs.

Nodejs:

 [ RowDataPacket {
           id: 1,
booktitle: 'Leading',
bookid: '56353',
bookauthor: 'Sir Alex Ferguson' },
 RowDataPacket {
id: 2,
booktitle: 'How Google Works',
bookid: '73638',
bookauthor: 'Eric Smith' },
RowDataPacket {
id: 3,
booktitle: 'The Merchant of Venice',
bookid: '37364',
bookauthor: 'William Shakespeare' } ]

I need this data to be displayed in the following html format

booktitle               bookid         bookauthor
-----------------------------------------------------------
Leading                  56353          Sir Alex Ferguson
How Google Works         73638          Eric Smith
The Merchant of Venice   37364          William Shakespeare

I tried to get the key and value separately using the following code

 for(var i = 0; i < JSONObject.length; i++) {
 for(var val in JSONObject[i]) {
 console.log(JSONObject[i][val])
   }
}

But this doesn't worked as expected. My data will be dynamic. The key and value will be keep on changing. So i can't access the value with JSONObject[i].booktitle like that. How can i get a general solution? How can i display the data in table format.

Add what npm module you are using for mysql ?

Himanshu sharma
– Himanshu sharma

2017-12-21 05:40:51 +00:00
Commented Dec 21, 2017 at 5:40 — Himanshu sharma
– Himanshu sharma, Commented Dec 21, 2017 at 5:40

user1197250 · Accepted Answer · 2017-12-21 06:01:19Z

1

for(var i = 0; i < JSONObject.length; i++) {
    for(var j = 0; j < JSONObject[i].length; j++) {
        for(var val in JSONObject[i][j]) {
            alert(val)
            alert(JSONObject[i][j][val])
        }
    }
}

answered Dec 21, 2017 at 6:01

user1197250

335 bronze badges

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

Comments

ahoang18 · Accepted Answer · 2017-12-21 05:35:57Z

0

  for(var i = 0; i < JSONObject.length; i++) {
     console.log("booktitle: " + JSONObject[i].booktitle)
     console.log("bookid: " + JSONObject[i].bookid)
     console.log("bookauthor: " + JSONObject[i].bookauthor)
  }

answered Dec 21, 2017 at 5:35

ahoang18

1437 bronze badges

1 Comment

Anuja vinod Over a year ago

booktitle.bookid.bookauthor these keys are dynamic.In other case key will be different ,so need a general format.

Collectives™ on Stack Overflow

How to display mysql query result in html table in nodejs?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related