Data from mysql in ejs but only get [object Object]

Question

I only get [object Object] when I use EJS to render the data from MySQL. JSON.parse does not work as well with this string: "JSON.parse: unexpected character at line 1 column 2 of the JSON data"

app.get("/favorites", function(req, res) {
  var favorites = {};
  db.query("SELECT * FROM favs WHERE user_id = '1'", function (error, result, fields) {
    if (error) throw error;
    favorites = result;
    res.render("favorites", {data: {print: favorites, page: true}});
  });
});

console.log("<%= data.print %>");
<!-- [object Object] -->

Mureinik · Accepted Answer · 2020-08-31 02:52:42Z

1

You have an object. You don't need to parse it, but to stringify it:

res.render("favorites", JSON.stringgify({data: {print: favorites, page: true}}));

answered Aug 31, 2020 at 2:52

Mureinik

316k54 gold badges399 silver badges405 bronze badges

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

Collectives™ on Stack Overflow

Data from mysql in ejs but only get [object Object]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related