How to iterate mysql array?

Question

Node.js

Can't iterate over array with EJS template engine. Gives [object Object]
index.ejs

<h1>
    <% for (var i = 0; i < sms.length; i++) { %>
            <p><%= sms[i].text %></p>
        <% } %>
  </h1>

app.js

var reqDB = 'SELECT * FROM messages';
var sms = db.query(reqDB, (err, result) => {
  if (err) throw err;
  console.log(result);
});

// Chat
app.get('/chat', function (req, res) {
  res.render('chat', {
    sms
  })
});

Answer 1

It's not about the template engine, but about the request, which does not write the result of the request to the database in the sms variable. You can check through the logs in the console.
Here is the solution to your problem

Answer 2

The template engine calls .toString() on whatever you output. For objects, this method returns exactly what you see. Use JSON.stringify() , see what you actually output. Well, or use a debugger, if you know how.