get data from server with node.js

Question

i want to do an ajax call to node.js with get method that the result of the ajax call will show in the same html page that i call the ajax function

this is the html code:

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Sing-in Page</title>
  <link rel="stylesheet" href="css/style.css">
  <script src="//code.jquery.com/jquery-1.10.2.js"></script>
  <script>
    $(function() {
      $("#myform").bind('ajax:complete', function() {
             // tasks to do 
             alert('1');
       });    
    });
  </script>
</head>
<body>
  <form method="get" action="http://localhost:8080/Login" id="myform" class="login">
    <p>
      <label for="login">Email:</label>
      <input type="text" name="login" id="login" value="">
    </p>
    <p>
      <label for="password">Password:</label>
      <input type="password" name="password" id="password" value="">
    </p>
    <p class="login-submit">
      <button type="submit" class="login-button">Login</button>
    </p>
    <p class="forgot-password"><a href="index.html">Forgot your password?</a></p>
  </form>
</body>
</html>

the is my node.js code, i know that i need to write something in the res.end function but i don't now what..

var express = require('express');
var app     = express();
var fs = require("fs");
var mysql      = require('mysql');
var pool = mysql.createPool({
    host     : 'XXXX',
    user     : 'XXXX',
    password : 'XXXX',
    database : 'XXXX',
});

app.use(express.bodyParser());

app.get('/Login', function(req, res) {
    pool.getConnection(function(err, connection) {
        var sql = 'select count(id) as ok from users where email=\''+req.body.login+'\' and password=\''+req.body.password+'\';';
        console.log("query: "+sql);
        connection.query( sql, function(err, rows) {
            console.log(rows[0].ok);
            connection.end();
        });
    });
    // what to write here that res.end() will return the result of console.log(rows[0].ok);
    res.end();
});

app.listen(8080, function() {
  console.log('Server running...');
});

i want to get the result of the sql query from the DB

Victor Parmar · Accepted Answer · 2014-06-13 15:20:45Z

2

You almost had it - just add res.send() after closing the connection :)

app.get('/Login', function(req, res) {
    pool.getConnection(function(err, connection) {
        var sql = 'select count(id) as ok from users where email=\''+req.body.login+'\' and password=\''+req.body.password+'\';';
        console.log("query: "+sql);
        connection.query( sql, function(err, rows) {
            console.log(rows[0].ok);
            connection.end();
            res.send(rows[0].ok); // you simply send your data after you're done your processing
        });
    });

});

On the client side you can bind the success event

$("#myform").bind('ajax:success', function(result) {
    alert(result);
});

edited Jun 13, 2014 at 15:20

answered Jun 13, 2014 at 14:21

Victor Parmar

744 bronze badges

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

2 Comments

royb Over a year ago

hi, after i use the send function how i can get the data in the html side? my jq myform function don't alert my anything.. =(

Victor Parmar Over a year ago

Edited to answer your question - bind the ajax:success event :)

Ferrakkem Bhuiyan · Accepted Answer · 2014-06-13 14:24:22Z

0

If you tryiny to trigger the data event on the server, you have to send data to the server, maybe using Jquery's post method as in:

var postSomething = function(){

    $.post
    (
        "http://127.0.0.1:3000/",
        {wooo:'wooo'},
        function(data)
        {
         console.log(data);
        }
    );
}

when 'data' event, you should write some data in the response object:

req.on('data', function(sock) {
      res.writeHead(200, {"Content-Type": "text/plain"});
      res.end("Hello!!");
});

answered Jun 13, 2014 at 14:24

Ferrakkem Bhuiyan

2,7932 gold badges25 silver badges39 bronze badges

1 Comment

danilodeveloper Over a year ago

$.post send a HTTP Post to server, but his '/Login' function is wating a HTTP Get. I think it's wrong, right?

Vivek Sharma · Accepted Answer · 2014-06-13 14:45:18Z

0

You could use something like this:

app.get('/Login', function(req, res) {
          pool.getConnection(function(err, connection) {
        var sql = 'select count(id) as ok from users where email=\''+req.body.login+'\' and password=\''+req.body.password+'\';';
        console.log("query: "+sql);
        connection.query( sql, function(err, rows) {
            console.log(rows[0].ok);
            connection.end();
            var returnData = {};
            returnData.message = rows[0].ok; 
            return res.json(200, returnData);
        });
        });


});

answered Jun 13, 2014 at 14:45

Vivek Sharma

5975 silver badges9 bronze badges

Comments

danilodeveloper · Accepted Answer · 2014-06-13 15:01:15Z

0

Send the HTTP Get to server:

$.get( "YOUR_URL_HERE/Login", function( data ) {
  alert( data );
});

To return a Json result, you can do something like this:

app.get('/Login', function(req, res) {
    var result;
    pool.getConnection(function(err, connection) {
        var sql = 'select count(id) as ok from users where email=\''+req.body.login+'\' and password=\''+req.body.password+'\';';
        console.log("query: "+sql);
        connection.query( sql, function(err, rows) {
            console.log(rows[0].ok);
            result = rows[0].ok;
            connection.end();
        });
    });
    res.writeHead(200, { 'Content-Type': 'application/json' });
    res.json({ status: result })
});

edited Jun 13, 2014 at 15:01

answered Jun 13, 2014 at 14:24

danilodeveloper

3,8902 gold badges39 silver badges56 bronze badges

Collectives™ on Stack Overflow

get data from server with node.js

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related