newbie here, I want to display my sql query result into my ejs file but I don't know how to.
any help will be appreciated.
1
-
1what have you done so far? ie sample codebooyaa– booyaa2013-04-07 09:39:29 +00:00Commented Apr 7, 2013 at 9:39
Add a comment
|
2 Answers
To use ejs, the Express render engine must be set.
app.engine('html', require('ejs').renderFile);
Then you can pass variables to templates a SQL query:
connection.query('SELECT 1', function (err, rows) {
res.render('file.html', {
'sql': rows
});
});
In your template, then you can use code like so:
<%= sql.property %>
and even use scripts inside tags:
<% sql.forEach(function(field){ %>
<%= field.property %>
<% }) %>
Comments
Use EJS template url and send sql results using:
.render()
