How can I retrieve the data object using SQL package on Node.JS?

Question

I have a mysql query executed from NodeJS using mysql npm package.

Upon success, I want to read the value in Javascript.

Both are on the same domain.

On console.log the value I read is 3.

How can I retrieve the data object values?

var mysql      = require('mysql');
var connection = mysql.createConnection(connectionOptions);

connection.query(
  "SELECT * FROM pruebas.Usuarios2 where RFC = '123'", 
  (err, result, fields) => { 
     if (result.length) { 
       // here I need an instruction that can send me the result of 3
       // to my javascript console
     } else { 
       console.log('no login');
     }
   }
 );

Have you read npmjs.com/package/mysql#performing-queries ? You can try to add console.log(JSON.stringify({ results, fields })); within if (result.length) { } block — Dimitri Kopriwa
– Dimitri Kopriwa, Commented Dec 21, 2018 at 19:58
How are you calling this? From where? Is this running on some sort of server? Think we need some more explanation. — putvande
– putvande, Commented Dec 21, 2018 at 20:45

Nelson Teixeira · Accepted Answer · 2018-12-21 20:14:09Z

1

You don't send from Node to Javascript. You call Node from Javascript using an Ajax call and return a value.

The answer to this question is a good exemple of how to do it: Basic Ajax send/receive with node.js

answered Dec 21, 2018 at 20:14

Nelson Teixeira

6,6366 gold badges46 silver badges90 bronze badges

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

6 Comments

putvande Over a year ago

I guess this depends on how OP has set things up.

Nelson Teixeira Over a year ago

The only way I can think this can work in another way is setting a socket connection. Can you give an example of what you're thinking ?

putvande Over a year ago

As part of a response from say Express?

Nelson Teixeira Over a year ago

It's still an ajax call from js to Node isn't it ?

putvande Over a year ago

Can just be on a page load. If you make a call to certain endpoint, let the page refresh, and let express do its work (including the query) and return it. Not AJAX required.

|

Collectives™ on Stack Overflow

How can I retrieve the data object using SQL package on Node.JS?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related