How to get a RowDataPacket object from MySQL?

Question

I would like to get the amount of a MySQL-database, then I query "SELECT COUNT(*) FROM articles_table" and got "[ RowDataPacket { 'COUNT(*)': 13 } ]"

I have tried to 'console.log(data[0].COUNT)', but I got a undefined message....

Could anyone tell me How do I do to get the number 13 with javascript?

Thank you very much!

You can store the value in php variable then just echo to the javascript variable. — Bibhudatta Sahoo, May 04 '18 at 11:25
possible duplication: https://stackoverflow.com/questions/31221980/how-to-access-a-rowdatapacket-object — Christian Felix, May 04 '18 at 11:29
I have tried to 'console.log(data[0].COUNT)', but I got a undefined message....@Christian Felix — Sylvia, May 04 '18 at 11:34

score 4 · Accepted Answer · answered May 04 '18 at 11:41

4

First, give the aliases to your expression column in SELECT statement i.e. for "COUNT(*)" as below.

SELECT COUNT(*) as cnt FROM articles_table

Then, try to use

console.log(data[0].cnt)

answered May 04 '18 at 11:41

How to get a RowDataPacket object from MySQL?

1 Answers1