Express js - How to get response from ajax call?

Question

I am trying to send form data to server side using ajax (sending a username), and in the server side perform SQL query and pass back the result to my template (EJS).

In my server side (ajaxTest.js)

router.post('/', function(req, res){
console.log(req.body);
var query = connection.query("select * from account where username='" + req.body.username+ "'",function  (err,result) {
    console.log(query.sql);
    if (err)   {
        console.error(err);
        return;
    }
    console.error(result);

    res.send("Result "+JSON.stringify(result));
});

});

In my template (ajaxTest.ejs)

$(document).ready(function  () {
$("#submit").on("submit",function  (e) {
    e.preventDefault();
    data = {};
    data.username = 'user101'; 
    $.ajax({
        type: 'POST',
        data: JSON.stringify(data),
        contentType: 'application/json',
        url: 'http://localhost:3000/ajaxtest',
        success: function(data) {
            console.log('success');
            console.log(JSON.stringify(data));
        }
    });
})

});

In the above code, result is successfully logged onto my console, but the 'success' and data does not get returned. Is there a reason why result is not being sent back to the template (ajaxTest.ejs)?

I'd greatly appreciate any feedback on the situation!

@Aer0 i tried res.json as well, it won't work too. is this the right way of getting back success data? — Louis.L
– Louis.L, Commented Jul 10, 2016 at 14:27

Iceman · Accepted Answer · 2016-07-10 16:04:40Z

2

res.send("Result "+JSON.stringify(result));

sends not valid json.

Either use:

res.send(JSON.stringify(result));

or

res.json(result);

answered Jul 10, 2016 at 16:04

Iceman

6,1652 gold badges25 silver badges34 bronze badges

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

Comments

Sachin Sharma · Accepted Answer · 2016-07-10 15:10:50Z

1

Its because you are corrupting the syntax of JSON by prepending it with 'Result'.

 res.send("Result "+JSON.stringify(result));

Instead do simple

res.send(JSON.stringify(result));

edited Jul 10, 2016 at 15:10

answered Jul 10, 2016 at 14:42

Sachin Sharma

2,6462 gold badges24 silver badges40 bronze badges

Comments

Alongkorn · Accepted Answer · 2016-07-10 15:29:42Z

0

Your front-end expects json data. Your back end should returned corresponding data too.

on your node.js, please change the return line from

res.send("Result "+JSON.stringify(result));

to

res.status(201).json(result); // return status 201, and json data (do not stringify)

answered Jul 10, 2016 at 15:29

Alongkorn

4,2371 gold badge28 silver badges43 bronze badges

Collectives™ on Stack Overflow

Express js - How to get response from ajax call?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related