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 https://www.npmjs.com/package/mysql#performing-queries ? You can try to add `console.log(JSON.stringify({ results, fields }));` within `if (result.length) { }` block — Dimitri Kopriwa, Dec 21 '18 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, Dec 21 '18 at 20:45

score 1 · Answer 1 · answered Dec 21 '18 at 20:14

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 '18 at 20:14

Nelson Teixeira

6,297
5
36
73

I guess this depends on how OP has set things up. – putvande Dec 21 '18 at 20:46
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 ? – Nelson Teixeira Dec 21 '18 at 20:55
As part of a response from say Express? – putvande Dec 21 '18 at 20:57
It's still an ajax call from js to Node isn't it ? – Nelson Teixeira Dec 21 '18 at 20:58
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. – putvande Dec 21 '18 at 21:06
Yes but that's only a request to the server directly by the browser. The OP asked how he can send a value from Node to Javascript. :) – Nelson Teixeira Dec 21 '18 at 21:09

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

1 Answers1